Question 1

The Enforce Referential Integrity box should normally be checked.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

When you purchase from a store several times this would be an example of what kind of table relationship?

Accepted Answer

A)  Many-to-one (many customers - one purchase) 
B)  One-to-one (one customer - one store) 
C)  Many-to-many (many items purchased - many times) 
D)  One-to-many (one customer - many purchases) 
A)  Many-to-one (many customers - one purchase) 
B)  One-to-one (one customer - one store) 
C)  Many-to-many (many items purchased - many times) 
D)  One-to-many (one customer - many purchases) D

Question 4

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 5

Match the recommended field types with their definitions or examples:
i. Calculate
II. Lookup Wizard
III. Short text
IV. Number
v. Currency

Accepted Answer

A) 	Can hold up to 255 characters 
B) 	Used to force users to pick from a custom list 
C) 	Can be set to Euros 
D) 	References one or more existing fields 
E) 	Used if you want to store a dollar sign ($) in your data 
A) 	Can hold up to 255 characters 
B) 	Used to force users to pick from a custom list 
C) 	Can be set to Euros 
D) 	References one or more existing fields 
E) 	Used if you want to store a dollar sign ($) in your data

Question 6

________ queries allow you to take full advantage of table relationships.

Accepted Answer

The answer of ________ queries allow you to take full...

Question 7

What field property would allow the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type?

Accepted Answer

A)  Required 
B)  Indexed 
C)  Allow Zero Length 
D)  Allow Null Length 
A)  Required 
B)  Indexed 
C)  Allow Zero Length 
D)  Allow Null Length

Question 8

When does the validation rule check the entered data?

Accepted Answer

A)  As soon as it is typed into the field 
B)  When the user exits the field 
C)  When the table or form is saved 
D)  When the table of form is closed 
A)  As soon as it is typed into the field 
B)  When the user exits the field 
C)  When the table or form is saved 
D)  When the table of form is closed

Question 9

Which option would this wildcard, "H[!oe]" not display?

Accepted Answer

A)  House 
B)  Hat 
C)  His 
D)  Humming 
A)  House 
B)  Hat 
C)  His 
D)  Humming

Question 10

The ________ guides you through query design with a step-by-step process.

Accepted Answer

The answer of The ________ guides you through query design...

Question 11

Although you can link to external data, it is not recommended.

Accepted Answer

A) True 
 B)False

Question 12

The primary key can only be a single field.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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 16

Which of the following comparison operators is not valid?

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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 19

What is the suggested data type for a street address?

Accepted Answer

A)  Long Text 
B)  Number 
C)  OLE Object 
D)  Short Text 
A)  Long Text 
B)  Number 
C)  OLE Object 
D)  Short Text

Question 20

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

The Enforce Referential Integrity box should normally be checked.

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

When you purchase from a store several times this would be an example of what kind of table relationship?

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

Match the recommended field types with their definitions or examples: i. Calculate II. Lookup Wizard III. Short text IV. Number v. Currency

________ queries allow you to take full advantage of table relationships.

What field property would allow the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type?

When does the validation rule check the entered data?

Which option would this wildcard, "H[!oe]" not display?

The ________ guides you through query design with a step-by-step process.

Although you can link to external data, it is not recommended.

The primary key can only be a single field.

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

What is not true about field names?

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

Which of the following comparison operators is not valid?

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

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

What is the suggested data type for a street address?

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

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

The Enforce Referential Integrity box should normally be checked.

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

When you purchase from a store several times this would be an example of what kind of table relationship?

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

Match the recommended field types with their definitions or examples: i. Calculate II. Lookup Wizard III. Short text IV. Number v. Currency

________ queries allow you to take full advantage of table relationships.

What field property would allow the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type?

When does the validation rule check the entered data?

Which option would this wildcard, "H[!oe]" not display?

The ________ guides you through query design with a step-by-step process.

Although you can link to external data, it is not recommended.

The primary key can only be a single field.

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

What is not true about field names?

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

Which of the following comparison operators is not valid?

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

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

What is the suggested data type for a street address?

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

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