Question 1

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 2

What field property forces data to follow certain rules of data entry?

Accepted Answer

A)  Validation Rule 
B)  Validation Text 
C)  Format 
D)  Required 
A)  Validation Rule 
B)  Validation Text 
C)  Format 
D)  Required

Question 3

What is not true about the Caption property?

Accepted Answer

A)  It allows labels to be more readable than field names. 
B)  It displays at the column head instead of the field name. 
C)  It is used in both forms and reports. 
D)  The Pascal case is preferred in this property. 
A)  It allows labels to be more readable than field names. 
B)  It displays at the column head instead of the field name. 
C)  It is used in both forms and reports. 
D)  The Pascal case is preferred in this property.

Question 4

Use the ________ data type when you do not know how much text space will be required.

Accepted Answer

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

Question 5

What is not true about the hyperlink data type?

Accepted Answer

A)  It can store the URL for a web page. 
B)  It can store the path to a file. 
C)  The hyperlink becomes active anytime you hover over it. 
D)  It can store the path to a folder. 
A)  It can store the URL for a web page. 
B)  It can store the path to a file. 
C)  The hyperlink becomes active anytime you hover over it. 
D)  It can store the path to a folder.

Question 6

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 7

The ________ property provides literal characters that are typed for each entry.

Accepted Answer

A)  Validation Rule 
B)  Default Value 
C)  Validation text 
D)  Input Mask 
A)  Validation Rule 
B)  Default Value 
C)  Validation text 
D)  Input Mask

Question 8

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 9

Which of the following comparison operators is not valid?

Accepted Answer

A) B) >= C) => D) < A) B) >= C) => D) <

Question 10

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

Accepted Answer

A)  1,000 
B)  12,256 
C)  Unlimited 
D)  64,000 
A)  1,000 
B)  12,256 
C)  Unlimited 
D)  64,000

Question 11

Match the following terms with their description:
I. "And" condition
II. "Or" condition
III. Null
IV. Comparison Operator
V. Criteria
A. Blank field value
B. Examples include: >, , =
C. Returns only records that meet all criteria
D. Determines which records are selected
E. Returns records meeting any criteria

Accepted Answer

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

Question 12

What field property increases the speed at which searches can be performed?

Accepted Answer

A)  Indexed 
B)  Allow Zero Length 
C)  Required 
D)  Result Type 
A)  Indexed 
B)  Allow Zero Length 
C)  Required 
D)  Result Type

Question 13

A database designer needs to be concerned about what fields might be needed rather than file size.

Accepted Answer

A) True 
 B)False

Question 14

The ________ key is what guarantees that a record is unique.

Accepted Answer

The answer of The ________ key is what guarantees that...

Question 15

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 16

Which wildcard character matches a single character in the same position as the wildcard?

Accepted Answer

A)  (?) 
B)  * 
C)  [] 
D)  [!] 
A)  (?) 
B)  * 
C)  [] 
D)  [!]

Question 17

Having common fields is important when you begin to build ________ between the tables.

Accepted Answer

The answer of Having common fields is important when you...

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

What field property forces data to follow certain rules of data entry?

What is not true about the Caption property?

Use the ________ data type when you do not know how much text space will be required.

What is not true about the hyperlink data type?

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

The ________ property provides literal characters that are typed for each entry.

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

Which of the following comparison operators is not valid?

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

What field property increases the speed at which searches can be performed?

A database designer needs to be concerned about what fields might be needed rather than file size.

The ________ key is what guarantees that a record is unique.

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.

Which wildcard character matches a single character in the same position as the wildcard?

Having common fields is important when you begin to build ________ between the tables.

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

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

What field property forces data to follow certain rules of data entry?

What is not true about the Caption property?

Use the ________ data type when you do not know how much text space will be required.

What is not true about the hyperlink data type?

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

The ________ property provides literal characters that are typed for each entry.

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

Which of the following comparison operators is not valid?

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

What field property increases the speed at which searches can be performed?

A database designer needs to be concerned about what fields might be needed rather than file size.

The ________ key is what guarantees that a record is unique.

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.

Which wildcard character matches a single character in the same position as the wildcard?

Having common fields is important when you begin to build ________ between the tables.

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