Creating a Select query using the QueryWizard in Microsoft Access 2019

  1. We will continue with the example from the previous section. Locatethe Query Wizard on the Create tab from the Queries group.
  2. Choose the type of query to design from the dialog box. For thisexercise, we are using the Simple QueryWizard, as illustrated in the following screenshot:
ms office 478
  1. Click on OK to continue, thenchoose the table on which to base the query from the drop-down listunder Tables/Queries. Choose StudentsTbl.
  1. Add fields from the AvailableFields: area to the SelectedFields: area. For this example, we will add Name, Surname, HouseType, and Grade, as illustrated in the followingscreenshot:
ms office 365
  1. Click on Next > tocontinue. Choose whether to produce a summary for the query or use allthe fields (detailed).
  2. Click on Next > tocontinue. Name the query StudentsQuery. Click on Finish. Note that there will be no criteriaentries added to the query. This would need to be done using the Query Design grid after using thewizard.
  1. Click on the Home tab to change toDesign View so that the query can be edited. Addthe criteria for the specific query requirements in the criteria row. Wewould like to search for all the Grade 12e students. Enter thiscriterion into the query grid. You will need to add the Class field to the grid in order to searchfor all the students in the e class,as illustrated in the following screenshot:
ms office 78
  1. From DesignResults, click the Run icon. The query results are displayed inDatasheet View. Close the query, thenrename the query by right-clicking on the query name in the All Access Objects pane, selecting Rename, and entering Grade12E.Press Enter on the keyboard to commit the change.

In the next section, we will look at more complex queries that youwould use to analyze data in Access 2019.

Leave a Comment