Queries select records from one or more tables in a database so they can be viewed, analyzed, and sorted on a common datasheet. The resulting collection of records, called a dynaset (short for dynamic subset), is saved as a database object and can therefore be easily used in the future. The query will be updated whenever the original tables are updated. Types of queries are select queries that extract data from tables based on specified values, find duplicate queries that display records with duplicate values for one or more of the specified fields, and find unmatched queries display records from one table that do not have corresponding values in a second table.
Follow these steps to create a new query in Design View:
Access' Query Wizard will easily assist you to begin creating a select query.
This query will filter out records in a single table that contain duplicate values in a field.
To delete a table from the query, click the table's title bar and press the Delete key on the keyboard.