Creating Microsoft Access Queries
A query can be based on tables or on other queries. To create a query, you open the tables or queries on which you are going to base your query in Query Design view, and then use the options in Design view to create your query. You then click the Run button to display the results. You can save queries for later use.
To open tables or queries in Query Design view:
1. Activate the Create tab.
2. Click the Query Design button in the Other group. The Show Table dialog box appears.
3. Activate the Tables tab if you want to base your query on tables, activate the Queries tab if you
want base your query on queries or activate the Both tab if you want to base your query on both tables and queries.
4. Click to choose the table or query on which you want to base your query.
5. Click Add. The table appears in the window.
a. Click to choose the next table or query on which you want to base your query.
b. Continue clicking tables or queries until you have all the tables and queries you plan to use.
6. Click Close. Access changes to Query Design view.
Display All Records and All Fields
In Query Design view, each table has an option that allows you to display all of the fields and all of the records in a table. This option appears on the field line on the drop-down menu as the table name followed by a period and an asterisk (tablename.*).
To display all records and all fields:
1. Open a table or query in Query Design view.
2. Click the down-arrow in the first field on the Field row and then select the tablename.* option.
The table name appears on the table line.
3. Click the Run button. Access retrieves all of the fields and records for the table and displays
them in Datasheet view.
Post a Comment