- 1). Double-click your Access database file on the hard drive. This opens the database and loads the software simultaneously.
- 2). Click the "Create" tab at the top of the window. In this tab, click the "Query Wizard" button. Click "Simple Query" in the opened window.
- 3). Click the table you want to query from the drop-down box. A list of columns are shown in the text box. Drag and drop the columns you want to retrieve from the left text box to the right one. Click "Next."
- 4). Type a name for the query in the final window. Click the option labeled "Open the query to view information." This saves and runs the query after the wizard closes.
- 5). Click "Finish" to create the query. A datasheet opens with all the columns and the table data from the tables.
Source...