More Query Design Options
In Access query design is essential for getting the data you want. Use query design in Access to design almost any query you want.
More query options
We offer mini-lessons on creating additional types of queries in the last lesson in this tutorial. Below is a list of the queries we currently cover.
- Parameter query
A parameter query allows you to create a query that can be updated easily to reflect a new criterion, or search term. When you open a parameter query, Access will prompt you for a search term and then show you query results that reflect that search.
- Find duplicates query
A find duplicates query lets you find all duplicate records in your database so you can delete them. Duplicate records can negatively affect the integrity of your database.
Other query-building resources