Querying your Access data
Learn how to ask questions of your Access data
Access Queries allow you to ask questions about your data. You can store queries so you can ask the same question over and over again - and the answers you get will vary as the data in your table changes.
Follow these steps to create a simple query for the table that we created in the First Steps with Access 2013 step by step tutorial:
Create the Query
This query will display the first name, last name, and Grade for the members of the club so select these three fields in turn in the left window and click the chevron (>) to move them to the right window. Click Next.
Name the query "Members by Grade" and choose the "Open the query to view information" option and click Finish. You'll see a subset of the data from your table on the screen.
Edit a query
Locate the column headed Grade and in its Criteria row, type [Type the Grade to view] - make sure to include the brackets as they tell Access to ask you for the Grade before the query results are displayed.
Test this new Query
Now, the query display only information relating to those members who play A grade cricket.
To close the query click the Close button in its top right corner. Make sure to save the changes when you are prompted to do so.
Next article in this series:
(c) 2017, Helen Bradley, All Rights Reserved.