BC: Access, Chapter 3, Review for Reassessment

wildcard: *

Characters that find words or phrases that contain specific letters, or combinations of letters. When placed before a character or set, finds results that end with that character or set. When placed after a character or set, finds results that begin with that character or set. When placed before and after a character or set, finds results that contain that character or set.

OR criteria

Criteria placed on different rows of the query design grid. A record will appear in the resulting datasheet if it is true for any single row (this row or that row).

Design Grid

Portion of the window where you specify fields and criteria for the query. You may sort results and show/hide fields.

AND criteria

Setting criteria for two different fields on the Criteria row (same row) in the query design grid.

Return tool

When creating and setting up a query, you can choose to limit the number of results returned by using the Return tool (Top Values, 5, 10, 5%, 10%, and so on).

Foreign Key

A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. A foreign key is not a primary key.

Queries

Questions the database can answer that are created for multiple use and so are generally saved (but don't have to be saved).

Primary Key

The field selected as a unique identifier for the database that uniquely identifies a record in a table. To ensure the most effective results in a query, the primary key should be selected.

Criteria: <Emp1SW

When using various types of criteria such as the less than sign in a query, numbers and letters may be sorted from left to right within the data.

Query Resulting Objects

You can create forms and reports with a query.

Calculated field

a field that can be computed from other fields is sometimes called a computed field. It can contain other field names, literal values, and must have an alias name (name added for this new field just in the query). It is not part of the tables used in the query and is not added to those tables. They update and recalculate each time the query is run. This new field can be used in a form or a report. This type of field can also enable the user to combine the values of two text fields into one field!

Show check box

in Design View, this hides the data if unchecked. The field information and criteria will still be used in the query; however, that field won't show in the display results.

Editing Data in Queries

If you edit data in the query, it immediately changes that information in the related table.