How Do I Create Queries With Access?
A query is a way to select and display data from various linked tables. Select the Queries tab in the database window and double-click either ‘Create Query in Design View’ or ‘Create Query by using Wizard’ – I think Design View is just as easy as using the wizard. Select the tables or queries you want to use and click the Add button for each of them and they will show up in the Query Design window with the relationships between them shown by lines linking the various tables. When you have finished selecting the tables you want close the Add Table dialog box. Drag individual fields from the tables at the top of the Query Design window into the grid in the lower half. If you want every field in a particular table to be in the query drag the asterisk at the top of the field list onto the grid. When you have selected all the fields for the query click on the Run Query button (it looks like an exclamation mark). Save the query for future use.
