- 1). Open Microsoft Access and click the tab labeled "Create" at the top of your window. These tabs are called "ribbons" in Microsoft 2007 Office software. The ribbon displays a list of options. On the far right, click the button labeled "Query Wizard." This opens the query creation wizard.
- 2). Select "Simple Query" from the list of options and click "OK" to move to the next wizard window. The first drop-down box labeled "Tables/Queries" lists the tables programmed for the Access database. Choose a table from the list. The wizard automatically displays a list of fields underneath the drop-down.
- 3). Select each column from the table that you want included in the query. With the column selected, click the ">" button to add it to the query. The columns selected are displayed each time the user executes this query. Click the "Next" button to move to the next screen.
- 4). Enter a name for the new query. Make sure you have "Open the query in view information" selected and click the "Finish" button. This option executes the query immediately after its creation, so you can view the final product.
- 5). Click the "Queries" button on the main menu to view a list of programmed queries for your Access database. This new query is now listed and available for use.
SHARE
