In the examples above queries have been directed at a single table. It is frequently the case, however, that queries need to be directed at more that one table which contain related information. A composite record is build from the pairs of records. This is illustrated by the example below where table1 and table2 to be joined - the join fields are field2 from table1 and field1 from table2 . In database theory, a number of different sorts of join have been identified as useful.
Access uses queries to join tables and supports both natural and outer joins .
Start by adding the Account and Branch tables to a new query. The join columns are identified in the diagram above by the line running between them. Release the mouse button and the line appears. Figure 20 Output from the Query specified in previous Figure Query Properties Associated with each query are a number of properties, the settings of which affect the way it runs and what data is displayed. Those most commonly used are detailed below.