Question 1

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 2

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 3

Access does not require that every table has a primary key.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

How many characters can be stored in a field with a Short Text data type?

Accepted Answer

A) 100 
B) 255 
C) 500 
D) 256 
A) 100 
B) 255 
C) 500 
D) 256

Question 7

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 8

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 9

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 10

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 11

In table relationships,the primary key is normally joined to a ________ key.

Accepted Answer

The answer of In table relationships,the primary key is normally...

Question 12

When you need a query to return entries based on any of a set of criteria,then you would use the ________ condition.

Accepted Answer

The answer of When you need a query to return...

Question 13

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 14

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 15

The ________ field type makes a good primary key.

Accepted Answer

AutoNumber

Question 16

Text you add to the criteria row in a query is case sensitive,so be careful or you may get unexpected results.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following cannot be imported from one Access database into another Access database?

Accepted Answer

A) Tables 
B) Sheets 
C) Forms 
D) Reports 
A) Tables 
B) Sheets 
C) Forms 
D) Reports

Question 18

Match between columns
                        Premises: Cascade Update
Referential Integrity
Cascade Delete
AutoNumber
Data Redundancy

Accepted Answer

The Answer of Deletes records in related fields that match is...

Question 19

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

Accepted Answer

The answer of One way to fix the problem that...

Question 20

You can easily ________ your data by using a multitable query.

Accepted Answer

The answer of You can easily ________ your data by...

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

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

Access does not require that every table has a primary key.

What is not true about field names?

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

How many characters can be stored in a field with a Short Text data type?

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.

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

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

What is not true about data types?

In table relationships,the primary key is normally joined to a ________ key.

When you need a query to return entries based on any of a set of criteria,then you would use the ________ condition.

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

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

The ________ field type makes a good primary key.

Text you add to the criteria row in a query is case sensitive,so be careful or you may get unexpected results.

Which of the following cannot be imported from one Access database into another Access database?

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

You can easily ________ your data by using a multitable query.

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

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

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

Access does not require that every table has a primary key.

What is not true about field names?

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

How many characters can be stored in a field with a Short Text data type?

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.

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

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

What is not true about data types?

In table relationships,the primary key is normally joined to a ________ key.

When you need a query to return entries based on any of a set of criteria,then you would use the ________ condition.

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

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

The ________ field type makes a good primary key.

Text you add to the criteria row in a query is case sensitive,so be careful or you may get unexpected results.

Which of the following cannot be imported from one Access database into another Access database?

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

You can easily ________ your data by using a multitable query.

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