Question 1

What option automatically deletes records in related tables that match the primary key?

Accepted Answer

A)  Autodelete Related Records 
B)  Cascade Update Related Fields 
C)  Cascade Delete Related Records 
D)  Delete and Update Related Records 
A)  Autodelete Related Records 
B)  Cascade Update Related Fields 
C)  Cascade Delete Related Records 
D)  Delete and Update Related Records

Question 2

What is not true about data types?

Accepted Answer

A)  It is best to choose Short Text for all fields at first, because they can easily be changed later. 
B)  Every field is assigned a data type. 
C)  They determine what operations can be performed on the data. 
D)  They can be changed after the table has been created. 
A)  It is best to choose Short Text for all fields at first, because they can easily be changed later. 
B)  Every field is assigned a data type. 
C)  They determine what operations can be performed on the data. 
D)  They can be changed after the table has been created.

Question 3

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

Accepted Answer

A) True 
 B)False

Question 4

In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

Accepted Answer

A) True 
 B)False

Question 5

The ________ guides you through query design with a step-by-step process.

Accepted Answer

The answer of The ________ guides you through query design...

Question 6

If you add a table with 10 records to a query and add an unrelated table with 4 records to the same query, how many records will display when you run the query?

Accepted Answer

A)  40 
B)  10 
C)  4 
D)  0 (since the tables are not related) 
A)  40 
B)  10 
C)  4 
D)  0 (since the tables are not related)

Question 7

What field property would allow the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type?

Accepted Answer

A)  Required 
B)  Indexed 
C)  Allow Zero Length 
D)  Allow Null Length 
A)  Required 
B)  Indexed 
C)  Allow Zero Length 
D)  Allow Null Length

Question 8

Which of the following is not a way to create a multitable query?

Accepted Answer

A)  Modifying an existing query 
B)  Using the Query Wizard 
C)  Adding a table in the Relationships window 
D)  Creating a query from scratch 
A)  Modifying an existing query 
B)  Using the Query Wizard 
C)  Adding a table in the Relationships window 
D)  Creating a query from scratch

Question 9

When you purchase from a store several times this would be an example of what kind of table relationship?

Accepted Answer

A)  Many-to-one (many customers - one purchase) 
B)  One-to-one (one customer - one store) 
C)  Many-to-many (many items purchased - many times) 
D)  One-to-many (one customer - many purchases) 
A)  Many-to-one (many customers - one purchase) 
B)  One-to-one (one customer - one store) 
C)  Many-to-many (many items purchased - many times) 
D)  One-to-many (one customer - many purchases)

Question 10

Data entered in a query is actually stored in the underlying table(s).

Accepted Answer

A) True 
 B)False

Question 11

When you import data, where can you not store it?

Accepted Answer

A)  New form 
B)  New table 
C)  Existing table 
D)  Linked table 
A)  New form 
B)  New table 
C)  Existing table 
D)  Linked table

Question 12

Match the recommended field types with their definitions or examples:
I. Calculate
II. Lookup Wizard
III. Short text
IV. Number
V. Currency
A. Can hold up to 255 characters
B. Used to force users to pick from a custom list
C. Can be set to Euros
D. References one or more existing fields
E. Used if you want to store a dollar sign ($) in your data

Accepted Answer

The answer of Match the recommended field types with their...

Question 13

Match the recommended field types with their examples:
I. Short text
II. Long text
III. Number
IV. Data/Time
V. Currency
A. A memo of indeterminate length
B. Phone number
C. Person's birthdate
D. Years of service
E. Financial information

Accepted Answer

The answer of Match the recommended field types with their...

Question 14

Match the following field properties with their description or something true about the property:
I. Caption
II. Format
III. Required
IV. Indexed
V. Result Type
A. Does not affect the stored value
B. Increases efficiency during searches
C. Used for calculated fields only
D. More understandable than field names
E. Cannot be Null

Accepted Answer

The answer of Match the following field properties with their...

Question 15

The Enforce Referential Integrity box should normally be checked.

Accepted Answer

A) True 
 B)False

Question 16

What is not true about field names?

Accepted Answer

A)  They can be up to 64 characters in length. 
B)  They should describe the data they will store. 
C)  They can contain numbers. 
D)  They can begin with a space. 
A)  They can be up to 64 characters in length. 
B)  They should describe the data they will store. 
C)  They can contain numbers. 
D)  They can begin with a space.

Question 17

When does the validation rule check the entered data?

Accepted Answer

A)  As soon as it is typed into the field 
B)  When the user exits the field 
C)  When the table or form is saved 
D)  When the table of form is closed 
A)  As soon as it is typed into the field 
B)  When the user exits the field 
C)  When the table or form is saved 
D)  When the table of form is closed

Question 18

The first step in creating a query is selecting the fields you need.

Accepted Answer

A) True 
 B)False

Question 19

The AND operator will give you the most results in a query.

Accepted Answer

A) True 
 B)False

Question 20

What field property would you use to automatically enter "PA" in a state field?

Accepted Answer

A)  Format 
B)  Caption 
C)  Default Value 
D)  Start Value 
A)  Format 
B)  Caption 
C)  Default Value 
D)  Start Value

What option automatically deletes records in related tables that match the primary key?

What is not true about data types?

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

The ________ guides you through query design with a step-by-step process.

If you add a table with 10 records to a query and add an unrelated table with 4 records to the same query, how many records will display when you run the query?

What field property would allow the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type?

Which of the following is not a way to create a multitable query?

When you purchase from a store several times this would be an example of what kind of table relationship?

Data entered in a query is actually stored in the underlying table(s).

When you import data, where can you not store it?

Match the recommended field types with their examples: I. Short text II. Long text III. Number IV. Data/Time V. Currency A. A memo of indeterminate length B. Phone number C. Person's birthdate D. Years of service E. Financial information

The Enforce Referential Integrity box should normally be checked.

What is not true about field names?

When does the validation rule check the entered data?

The first step in creating a query is selecting the fields you need.

The AND operator will give you the most results in a query.

What field property would you use to automatically enter "PA" in a state field?

Office 365 Common Features

Introduction to Access

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 3: Tables and Queries in Relational Databases

What option automatically deletes records in related tables that match the primary key?

What is not true about data types?

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

The ________ guides you through query design with a step-by-step process.

If you add a table with 10 records to a query and add an unrelated table with 4 records to the same query, how many records will display when you run the query?

What field property would allow the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type?

Which of the following is not a way to create a multitable query?

When you purchase from a store several times this would be an example of what kind of table relationship?

Data entered in a query is actually stored in the underlying table(s).

When you import data, where can you not store it?

Match the recommended field types with their examples: I. Short text II. Long text III. Number IV. Data/Time V. Currency A. A memo of indeterminate length B. Phone number C. Person's birthdate D. Years of service E. Financial information

The Enforce Referential Integrity box should normally be checked.

What is not true about field names?

When does the validation rule check the entered data?

The first step in creating a query is selecting the fields you need.

The AND operator will give you the most results in a query.

What field property would you use to automatically enter "PA" in a state field?

Office 365 Common Features

Introduction to Access

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters