Question 1

To limit the number of records displayed when a query is run you add ________.

Accepted Answer

A)  sorting 
B)  criteria 
C)  less fields 
D)  less tables 
A)  sorting 
B)  criteria 
C)  less fields 
D)  less tables

Question 2

A good way to know what fields you will need is to think of what reports you might need later.

Accepted Answer

A) True 
 B)False

Question 3

What is the correct order of steps for creating a multitable query?
I. Step 1
II. Step 2
III. Step 3
IV. Step 4
V. Step 5
A. Add the tables you want
B. Click Query Design in the Queries group
C. Click Run
D. Drag the fields you want
E. Click the Create tab

Accepted Answer

The answer of What is the correct order of steps...

Question 4

For security purposes you want to have data redundancy in your tables.

Accepted Answer

A) True 
 B)False

Question 5

Match the following terms with their description:
I. Caption
II. Foreign key
III. Data type
IV. Field properties
V. Wildcards
A. Used to relate tables on common fields
B. Effects what operations can be performed on data
C. Characteristic of a field
D. Special characters that can represent other characters
E. More understandable than a field name

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 6

It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

Accepted Answer

A) True 
 B)False

Question 7

Access uses ________ to speed up the sorting or filtering process.

Accepted Answer

The answer of Access uses ________ to speed up the...

Question 8

You can only have one primary key in a table, but you can have several foreign keys.

Accepted Answer

A) True 
 B)False

Question 9

It is best when designing a query to add all the fields from a table in case you need them later.

Accepted Answer

A) True 
 B)False

Question 10

You can save time and help prevent errors when you ________ data from an external source.

Accepted Answer

The answer of You can save time and help prevent...

Question 11

What field property helps to make sure that correct data is entered?

Accepted Answer

A)  Validation text 
B)  Validation rule 
C)  Format 
D)  Required 
A)  Validation text 
B)  Validation rule 
C)  Format 
D)  Required

Question 12

Logical operators only work with text and numbers, not dates.

Accepted Answer

A) True 
 B)False

Question 13

Multitable queries inherit their relationships and you cannot change those in the query. You need to open the Relationships window to make any changes.

Accepted Answer

A) True 
 B)False

Question 14

The ________ relationship requires a junction table for it to function properly.

Accepted Answer

many-to-ma

Question 15

When creating a multitable query from scratch only include related tables in your query.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Use the ________ data type when you want to store multiple pictures in your records.

Accepted Answer

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

Question 19

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

Accepted Answer

A) True 
 B)False

Question 20

Although you can create calculated fields in a query, most prefer to add them the table instead.

Accepted Answer

A) True 
 B)False

To limit the number of records displayed when a query is run you add ________.

A good way to know what fields you will need is to think of what reports you might need later.

What is the correct order of steps for creating a multitable query? I. Step 1 II. Step 2 III. Step 3 IV. Step 4 V. Step 5 A. Add the tables you want B. Click Query Design in the Queries group C. Click Run D. Drag the fields you want E. Click the Create tab

For security purposes you want to have data redundancy in your tables.

It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

Access uses ________ to speed up the sorting or filtering process.

You can only have one primary key in a table, but you can have several foreign keys.

It is best when designing a query to add all the fields from a table in case you need them later.

You can save time and help prevent errors when you ________ data from an external source.

What field property helps to make sure that correct data is entered?

Logical operators only work with text and numbers, not dates.

Multitable queries inherit their relationships and you cannot change those in the query. You need to open the Relationships window to make any changes.

The ________ relationship requires a junction table for it to function properly.

When creating a multitable query from scratch only include related tables in your query.

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

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

Use the ________ data type when you want to store multiple pictures in your records.

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

Although you can create calculated fields in a query, most prefer to add them the table instead.

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

To limit the number of records displayed when a query is run you add ________.

A good way to know what fields you will need is to think of what reports you might need later.

What is the correct order of steps for creating a multitable query? I. Step 1 II. Step 2 III. Step 3 IV. Step 4 V. Step 5 A. Add the tables you want B. Click Query Design in the Queries group C. Click Run D. Drag the fields you want E. Click the Create tab

For security purposes you want to have data redundancy in your tables.

It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

Access uses ________ to speed up the sorting or filtering process.

You can only have one primary key in a table, but you can have several foreign keys.

It is best when designing a query to add all the fields from a table in case you need them later.

You can save time and help prevent errors when you ________ data from an external source.

What field property helps to make sure that correct data is entered?

Logical operators only work with text and numbers, not dates.

Multitable queries inherit their relationships and you cannot change those in the query. You need to open the Relationships window to make any changes.

The ________ relationship requires a junction table for it to function properly.

When creating a multitable query from scratch only include related tables in your query.

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

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

Use the ________ data type when you want to store multiple pictures in your records.

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

Although you can create calculated fields in a query, most prefer to add them the table instead.

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