4. MICROSOFT ACCESS QUERIES

Queries are used for multiple purposes in a database environment. They can be used directly to

      • restrict the information a user can see,
      • as the basis of a MS Access form,
      • as the basis of a MS Access report.

In this chapter we use the Library database for examples. With MS Access you can create a query in multiple ways; we will examine the use of the Query Designer. To create a query, click the Create tab and then click the Query Design icon:

 

            Figure 4.1: Create a query

As a result, MS Access opens a Query By Example (QBE) window:

 

          Figure 4.2: QBE window

This window comprises two areas: Relationships and Grid. The Relationships area will show each table that needs to be accessed and the relationships to be used with those tables.

The Grid area is used to specify:

      • fields and tables,
      • sort fields,
      • fields to be included in the results display,
      • criteria fields must meet for a row to be included in the query result,
      • calculations,
      • grouping of rows for displaying summary information

 

We use the Library database; we start with simple examples and work our way to more complex situations.

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Relational Databases and Microsoft Access 365 Copyright © by Ron McFadyn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book