Question 1

________ queries allow you to take full advantage of table relationships.

Accepted Answer

The answer of ________ queries allow you to take full...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

There might be times when you want to add the same field to a query several times.

Accepted Answer

A) True 
 B)False

Question 4

Although you can link to external data,it is not recommended.

Accepted Answer

A) True 
 B)False

Question 5

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 6

The term that can be used in a query to refer to blank cells is ________.

Accepted Answer

The answer of The term that can be used in...

Question 7

Match between columns
                        Premises: Step 2
Step 1
Step 5
Step 3
Step 4

Accepted Answer

The Answer of Drag the fields you want and Click is...

Question 8

The ________ relationship is used when joining two primary keys.

Accepted Answer

one-to-one

Question 9

You should store data in their ________ parts.

Accepted Answer

The answer of You should store data in their ________...

Question 10

Which logical operator would return the fewest records?

Accepted Answer

A) AND 
B) OR 
C) NOT 
D) NOR 
A) AND 
B) OR 
C) NOT 
D) NOR

Question 11

What field property insures that all phone numbers have a consistent look?

Accepted Answer

A) Caption 
B) Format 
C) Default Value 
D) Input Mask 
A) Caption 
B) Format 
C) Default Value 
D) Input Mask

Question 12

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 13

Which of the following would make a good primary key?

Accepted Answer

A) AutoNumber data type 
B) Customer name 
C) Number data type 
D) Birthday 
A) AutoNumber data type 
B) Customer name 
C) Number data type 
D) Birthday

Question 14

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 15

Enforcing referential integrity assures that ________.

Accepted Answer

A) you cannot enter a value in the foreign key if there is no corresponding value in the primary key 
B) you cannot enter the same value in the foreign key of the same table 
C) you cannot leave that field empty 
D) you cannot enter invalid or incorrect information 
A) you cannot enter a value in the foreign key if there is no corresponding value in the primary key 
B) you cannot enter the same value in the foreign key of the same table 
C) you cannot leave that field empty 
D) you cannot enter invalid or incorrect information

Question 16

Use the ________ data type if you need to store a True or False value.

Accepted Answer

The answer of Use the ________ data type if you...

Question 17

When you run a query,it displays in what view?

Accepted Answer

A) Design 
B) Layout 
C) Print Preview 
D) Datasheet 
A) Design 
B) Layout 
C) Print Preview 
D) Datasheet

Question 18

Match between columns
                        Premises: Caption
Required
Result Type
Format
Indexed

Accepted Answer

The Answer of More understandable than field names and Cannot is...

Question 19

What field property makes up for the limitation of the field naming rules or common practices?

Accepted Answer

A) Validation Rule 
B) Input Mask 
C) Format 
D) Caption 
A) Validation Rule 
B) Input Mask 
C) Format 
D) Caption

Question 20

Access provides a wizard for easily importing Excel data into Access.

Accepted Answer

A) True 
 B)False

________ queries allow you to take full advantage of table relationships.

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

There might be times when you want to add the same field to a query several times.

Although you can link to external data,it is not recommended.

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

The term that can be used in a query to refer to blank cells is ________.

The ________ relationship is used when joining two primary keys.

You should store data in their ________ parts.

Which logical operator would return the fewest records?

What field property insures that all phone numbers have a consistent look?

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?

Which of the following would make a good primary key?

When does the validation rule check the entered data?

Enforcing referential integrity assures that ________.

Use the ________ data type if you need to store a True or False value.

When you run a query,it displays in what view?

What field property makes up for the limitation of the field naming rules or common practices?

Access provides a wizard for easily importing Excel data into Access.

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

________ queries allow you to take full advantage of table relationships.

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

There might be times when you want to add the same field to a query several times.

Although you can link to external data,it is not recommended.

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

The term that can be used in a query to refer to blank cells is ________.

The ________ relationship is used when joining two primary keys.

You should store data in their ________ parts.

Which logical operator would return the fewest records?

What field property insures that all phone numbers have a consistent look?

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?

Which of the following would make a good primary key?

When does the validation rule check the entered data?

Enforcing referential integrity assures that ________.

Use the ________ data type if you need to store a True or False value.

When you run a query,it displays in what view?

What field property makes up for the limitation of the field naming rules or common practices?

Access provides a wizard for easily importing Excel data into Access.

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