 |
Queries |   |
Software - Databases
|
You can use Queries to analyse, and change data in different ways. You can also use them as the source of records for reports and forms. They can be used to bring together data from two or more different tables in a database by linking the Primary Key of one table with the Foreign Key of another:
The upper half of the Query form above shows the fields in the two tables to be linked, and the links which are to be used. The check boxes in the lower half are for selecting the fields from the separate tables which are to be included in the new combined table to be created by the Query: The Query has used the common factor of "Publisher" to generate a new table with data on book titles and publishers' telephone numbers, which were fields in the two separate tables.
|
