Creating a Select query in Design View in Microsoft Access 2019

  1. Open the database to base the queries in. We will continue with theSSGStudents.accdb database.
  2. On the Create tab, locate theQueries group, and click the Query Design icon, as illustrated in thefollowing screenshot:
ms office 343
  1. The Show Table dialog box willpresent itself, where you will need to select the table on which youwish to base the new query. Choose StudentsTbl.
If one table is used in a query, then it is called a singletable query.
  1. Click Add, then click on Close.
  2. Select the fields from the table list by double-clicking to add themto the query grid. For this example, we will select Name, Surname, HouseType, and Gender. 
  1. Add the criteria for the specific query requirements in the Criteria: row. We will use Sapphire for the HouseType field and Male for the Gender field. Notice that once you enter thecriteria, the text is automatically formatted to include inverted commasbefore and after the field. This is because the field is a text entryfield. The criteria can be viewed in the following screenshot:
ms office 665
  1. From the Design tab, locate theResults group. Click the ! Run iconto view the results (see the preceding screenshot to view this),which can be seen in the following screenshot:

ms office 623
  1. The results open up in DatasheetView, named Query1. Save thequery as HouseQry, using the Quick AccessToolbar (QAT) or by right-clicking on theQuery1 tab. Enter the name of thequery into the dialog box, which populates. Remember that naming is veryimportant in this instance as the name will notify the user as to thetype of information it will produce when run, as illustrated in thefollowing screenshot:
ms office 501
  1. The HouseQry query appears underthe Queries object heading in theAll Access Objects Navigation Pane, asillustrated in the preceding screenshot.

Leave a Comment