Creating a Query in Design View
When you want to work with more than one table, you need to move beyond filters and into the realm of queries. The most common type of query selects records that meet specific conditions, but there are several other types, as follows:
A select query retrieves data from one or more tables and displays the results in a datasheet. You can also use a select query to group records and calculate sums, counts, averages, and other types of totals. You can work with the results of a select query in Datasheet view to update records in one or more related tables at the same time.
A duplicate query is a form of select query that locates records that have the same information in one or more fields that you specify. The Find Duplicates ...
Get Microsoft® Office System Step by Step -- 2003 Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
