Question 1

Which of the following comparison operators is not valid?

Accepted Answer

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

Question 2

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

Accepted Answer

attachment

Question 3

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 C

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

Storing duplicate data in more than one table is called data ________.

Accepted Answer

The answer of Storing duplicate data in more than one...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

A field's ________ determine how that field functions.

Accepted Answer

The answer of A field's ________ determine how that field...

Question 12

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 13

If you wanted the user to pick from a particular list,what would you pick from the data type drop down list for that field?

Accepted Answer

A) List 
B) Short Text 
C) Lookup Wizard 
D) Long Text 
A) List 
B) Short Text 
C) Lookup Wizard 
D) Long Text

Question 14

Match between columns Premises: >25 =25 >=25 <>25 <25

Accepted Answer

The Answer of Less than 25 and Equals 25 and is...

Question 15

Storing a book's title in more than one table within a database is considered data ________.

Accepted Answer

A) backup 
B) redundancy 
C) duplication 
D) consistency 
A) backup 
B) redundancy 
C) duplication 
D) consistency

Question 16

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 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Match between columns
                        Premises: Caption
Wildcards
Field properties
Foreign key
Data type

Accepted Answer

The Answer of Used to relate tables on common fields is...

Which of the following comparison operators is not valid?

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

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

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

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

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

Storing duplicate data in more than one table is called data ________.

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

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

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

A field's ________ determine how that field functions.

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

If you wanted the user to pick from a particular list,what would you pick from the data type drop down list for that field?

Storing a book's title in more than one table within a database is considered data ________.

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

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

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

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

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

Which of the following comparison operators is not valid?

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

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

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

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

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

Storing duplicate data in more than one table is called data ________.

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

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

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

A field's ________ determine how that field functions.

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

If you wanted the user to pick from a particular list,what would you pick from the data type drop down list for that field?

Storing a book's title in more than one table within a database is considered data ________.

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

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

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

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

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