Use data prompts in Access to find the data you need

There are times when users may need to see different views of the same data. Before you spend your precious time creating more than one query, check out how you can use data queries to provide each user with the data they need.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

When users require different views of the same data, there's no need to waste time creating more than one query. For example, let's say the benefits department needs to query the organization's employee database for retirement eligibility one day, and the next day it needs to query for vacation days.

Since the value in the Hire_Date field determines eligibility, you can create one parameter query and let users enter their own date criteria.

Follow these steps:

  1. Create a select query that includes all the fields of the Employee table.
  2. In the query grid, enter the following in the Criteria field for the Hire_Date field:
Between [Enter the beginning date] And [Enter the ending date]

When you run the query, Access prompts the user to enter the appropriate date range.

Editor's Picks

Free Newsletters, In your Inbox