Page 61 - Computer Class 08
P. 61
Queries
You use queries to view, change and analyse data in different ways. You can also use them
as a source of records for forms and reports.
Let’s Learn...
Let’s
Learn...
To create a query.
1. Click on the Create tab.
2. Click on Query Design in the Queries group.
3. Select the table that you would like to base your query on.
4. Click Add .
5. Repeat steps 3 and 4 until all tables are added.
6. Close the Show Table window.
1
2
4 6
The table(s) will now be displayed in the upper part of the Query Design Screen by boxes
containing the tables’ fields.
Computer-8 61