# CBA CHS Access Lesson 3

## 33 terms

### And operator

Selects records that match two or more conditions in a query (AC 71).

### Ascending

Arranges records from A to Z, or smallest to largest (AC 56).

### AutoFilter

A menu that contains options for sorting data and clearing any filters that you have already applied (AC 58).

### Calculated field

When a field displays a value that is calculated using other fields in the query (AC 75).

### Common field

A matching field is also called this because it is the same in both tables involved in the relationship (AC 66).

### Condition

Another term for criterion; a way of telling the query which data you are interested in seeing (AC 53).

### Criteria

When the condition has two or more parts to it the two conditions are called criteria (AC 53).

### Criterion

Another term for condition; a way of telling the query which data you are interested in seeing (AC53).

### Descending

Arranges records from Z to A, or largest to smallest (AC 56).

### Detail query

Shows every field in each record (AC 55).

### Exact match condition

When records must contain an exact equal to be displayed in the query datasheet (AC 70).

### Expression

The calculation used in a calculated field (AC 75).

### Filter

Temporarily displays records in a datasheet based on the condition that you specify (AC 57).

### Filter By Form

Use when you need to display records that contain one or more values based on the values stored in one or more fields (AC 58).

### Filter By Selection

You choose a field value (or part of a field value) in a datasheet, and then click this button in the Sort & Filter group on the Home tab. A menu opens with a list of options (AC 57).

### Foreign key

The common field in the related table (AC 66).

### Join line

After you add two related tables to the query design, this shows the relationship between the tables. It connects the common field used to relate the tables (AC 69).

### Matching field

A field that appears in both tables, has the same data type, and contains the same values (AC 66).

### Multitable query

Queries that are based on more than one table. (AC69)

### One-to-many relationship

One record in the first table can match many records in the second table. (AC 66)

### Or operator

Selects records that match at least one of two or more conditions in a query.(AC 71)

### Primary table

First table. (AC 66)

### Query

A database object that lets you ask about the data it contains. The result is a datasheet that includes the records you asked to see(AC 53)

### Range-of-values condition

A condition that you can create which causes a record to be displayed in the query datasheet when the record matches a range of values.(AC 70)

### Referential integrity

Protects the data in the tables to make sure that data is not accidentally deleted or changed.(AC 66)

### Related table

The second table in a relationship. (AC 66)

### Relationship

To create a relationship between two tables, you must design the tables so they contain a matching field. (AC 66)

### Run

Action to get the results of a query. (AC 65)

### Simple query wizard

It asks you what data you want to see in a query by letting you select options in dialog boxes. (AC 56)

### Sort

Arranges records from A to Z or Z to A.(AC56)

### Subdatasheet

Contains the related records in the Orders table (the related table). (AC 68)

### Summary query

Lets you summarize relevant data, such as adding the field values in a column that stores price data. (AC 55)

### Total row

When viewing a table or query datasheet you can use this to get a quick count of the number of values in a column. (AC 74)