How to Insert a Query in Access 2003
Inserting queries in Access 2003 lets you extract information from your database. Queries let you ask a question in data that has been added to the database. You can decide which information is displayed when the query is executed. Query display fields are selected in the design view. The executed query displays the results of the query in the query datasheet view.
Other People Are Reading
Instructions
-
-
1
Open Access 2003 and select a database. Click "File" on the menu bar. Click "Open." Browse your files and locate the database. Click the database and select the "Open" button.
-
2
Click the "Query" object in the database window. Select "New." Click "Query Design." The "Show Table" dialog box appears. Add a table to the query by clicking the table name and selecting "Add." Close the "Show Table" dialog box by clicking the "Close" button.
-
-
3
Add fields to the query by clicking the table field names and dragging them into the query. Run the query by clicking the exclamation "Run" icon on the menu bar. Review the query results in the datasheet view.
-
1
