Creating Queries
You saw in Chapter 5, “Using Microsoft Query,” how to create a simple Select query in Access. The Select query was used as a data source for Microsoft Query, in situations that were too complex for Microsoft Query to manage.
Prior sections in this chapter have discussed joins in greater detail, as well as the implications of choosing names and data types for the fields in the database's tables. The present section builds on those concepts to deal with action queries and criteria in select queries.
The Select query that you saw in Chapter 5 is doubtless the most frequently used type of query. It fulfills several objectives, among them
Returning data from one or more tables that are joined by common fields
Returning data summaries, ...
Get Managing Data with Microsoft® Excel 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.
