Building and Using Queries- Access B

Query Design View presents the fields

you can use for that query in small windows called field lists

AND criteria

means all criteria must be true for the record to be selected Created by entering 2 or more criteria in the same Criteria row of the query design grid

OR criteria

means any one criterion must be true for the record to be selected Created by entering 2 or more criteria on different Criteria rows of the query design grid Also created by entering 2 or more criteria in the same Criteria cell separated by OR

Data can be sorted by

clicking the list arrow on a datasheet's column heading, then click a sorting option

Criteria in Number, Currency, and Yes/No fields are

not surrounded by any characters

Filters

provide a temporary way to display a subset of records that match given criteria

Query design view

Add, delete, or move the fields in an existing query, to specify sort orders, or to add criteria to limit the number of records shown in the resulting datasheet Create a new query from scratch

Logical view of data

Because the query doesn't physically store the data, a query datasheet is sometimes called

Quotation marks (") around text criteria and pound signs (#) around date criteria are

automatically added by Access

Can

Change font size, font face, colors, gridlines

Filter By Selection

Filtering by a given field value. Filters records for an exact match.

Filter By Form

Filters by comparative data

Is Not Null

Finds all records where any entry has been made (even if zero)

Is Null

Finds all records where no entry has been made

join or Link Line

If you use the fields of two or more related tables in the query, the relationship between two tables is displayed with

Any edits you make in a query datasheet are permanently stored in the underlying tables, and are automatically updated in all views of the data in other queries, forms, and reports

True

You enter and edit data in a query datasheet the same way you do in a table datasheet

True

Wildcards

Used to search for a pattern; represents any character

Query

allows you to select a subset of fields and records from one or more tables and then present the selected data as a single datasheet

The Access sort and find features

are handy tools that help you quickly organize and find data in a table or query datasheet.