Question 1

Match the following Comparison Operators expression with their example:
i. =25
II. >25
III. 25
v. >=25

Accepted Answer

A)  Less than 25 
B)  Equals 25 
C)  Does not equal 25 
D)  Greater than or equal to 25 
E)  Greater than 25 
A)  Less than 25 
B)  Equals 25 
C)  Does not equal 25 
D)  Greater than or equal to 25 
E)  Greater than 25

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

In table relationships, the foreign key of one table cannot be joined to the ________ key of another table.

Accepted Answer

The answer of In table relationships, the foreign key of...

Question 4

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

Accepted Answer

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 
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

Question 5

Match the recommended field types with their examples:
i. Short text
II. Long text
III. Number
IV. Data / Time
v. Currency

Accepted Answer

A)  A memo of indeterminate length 
B)  Phone number 
C)  Person's birthdate 
D)  Years of service 
E)  Financial information 
A)  A memo of indeterminate length 
B)  Phone number 
C)  Person's birthdate 
D)  Years of service 
E)  Financial information

Question 6

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...

Question 7

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 8

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

Accepted Answer

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

Question 9

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 10

If you want the results of a query to display only those records that meet all criteria, you would use the ________ operator.

Accepted Answer

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

Question 11

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 12

The ________ field type makes a good primary key.

Accepted Answer

AutoNumber

Question 13

The ________ relationship is used when joining two primary keys.

Accepted Answer

one-to-one

Question 14

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 15

Access requires that common fields be named exactly the same.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

many-to-ma

Question 18

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

Question 19

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

Accepted Answer

A) True 
 B)False

Question 20

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

Match the following Comparison Operators expression with their example: i. =25 II. >25 III. <25 IV. <>25 v. >=25

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

In table relationships, the foreign key of one table cannot be joined to the ________ key of another table.

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

Match the recommended field types with their examples: i. Short text II. Long text III. Number IV. Data / Time v. Currency

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

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

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

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

If you want the results of a query to display only those records that meet all criteria, you would use the ________ operator.

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

The ________ field type makes a good primary key.

The ________ relationship is used when joining two primary keys.

Enforcing referential integrity assures that ________.

Access requires that common fields be named exactly the same.

What is not true about data types?

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

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

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

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

Common Features

Access: Introduction to Powerpoint

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters

Exam 3: Access: Tables and Queries in Relational Databases

Match the following Comparison Operators expression with their example: i. =25 II. >25 III. <25 IV. <>25 v. >=25

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

In table relationships, the foreign key of one table cannot be joined to the ________ key of another table.

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

Match the recommended field types with their examples: i. Short text II. Long text III. Number IV. Data / Time v. Currency

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

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

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

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

If you want the results of a query to display only those records that meet all criteria, you would use the ________ operator.

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

The ________ field type makes a good primary key.

The ________ relationship is used when joining two primary keys.

Enforcing referential integrity assures that ________.

Access requires that common fields be named exactly the same.

What is not true about data types?

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

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

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

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

Common Features

Access: Introduction to Powerpoint

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters