Question 1

Match between columns
                        Premises: When a field displays a value that is calculated using other fields in the query, it is called a(n) ____.
Menu that opens when you click the arrow on the right side of a field selector.
When you are viewing a table or query datasheet, you can use the ____ to count the number of values in a column.
A calculation of more than one field is called a(n) ____.
The common field in the related table is called a(n) ____ when it is used in a relationship.

Accepted Answer

The Answer of Calculated field and Total row and Foreign is...

Question 2

Briefly describe Filter by Selection and Filter by Form. Imagine that you are searching for songs in a database. Give an example of a situation where you would use Filter by Selection and a situation where you would use Filter by Form.

Accepted Answer

The answer of Briefly describe Filter by Selection and Filter...

Question 3

To create a(n) ____________________ between two tables, you must design the tables so they contain a common field.

Accepted Answer

The answer of To create a(n) ____________________ between two tables,...

Question 4

A(n) ____________________ query lets you summarize relevant data, such as adding the field values in a column that stores price data.

Accepted Answer

The answer of A(n) ____________________ query lets you summarize relevant...

Question 5

Sorting a field in ____________________ order arranges records from A to Z, or smallest to largest.

Accepted Answer

The answer of Sorting a field in ____________________ order arranges...

Question 6

____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data.

Accepted Answer

The answer of ____________________ protects the data in the tables...

Quiz 3: Creating Queries

Identify the letter of the choice that best matches the phrase or definition.

Briefly describe Filter by Selection and Filter by Form. Imagine that you are searching for songs in a database. Give an example of a situation where you would use Filter by Selection and a situation where you would use Filter by Form.

To create a(n) ____________________ between two tables, you must design the tables so they contain a common field.

A(n) ____________________ query lets you summarize relevant data, such as adding the field values in a column that stores price data.

Sorting a field in ____________________ order arranges records from A to Z, or smallest to largest.

____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data.