Skip to Main Content
Microsoft® Office Access 2003 Step by Step
book

Microsoft® Office Access 2003 Step by Step

by Online Training Solutions Inc.
August 2003
Beginner content levelBeginner
368 pages
10h 49m
English
Microsoft Press
Content preview from Microsoft® Office Access 2003 Step by Step

Creating a Query in Design View

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Access 2003 Inside Out

Microsoft® Office Access 2003 Inside Out

John L. Viescas

Publisher Resources

ISBN: 0735615179Supplemental ContentCatalog PageErrata