Question 1

Filter By Query allows you to filter based on multiple criteria,for example,to find only those customers whose returns are $0.00 and whose book rep number is 42.

Accepted Answer

A) True 
 B)False

Question 2

If you add a field to a table and later realize the field is in the wrong location,you can move the field.To move the field,tap or click the ____________________ for the field and then drag the field to the new location.

Accepted Answer

The answer of If you add a field to a...

Question 3

If you plan to move your data to SQL Server at a later date,do not use ____________________ fields.

Accepted Answer

The answer of If you plan to move your data...

Question 4

Identify the letter of the choice that best matches the phrase or definition.
-Allows you to delete all the records satisfying some criterion.

Accepted Answer

A) append query 
B) delete query 
C) make-table query 
D) update query 
E) validation rules
F)validation text
G)required field
H)default value
I)calculated field
J)<

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-Field that can be computed from other fields.

Accepted Answer

A) append query 
B) delete query 
C) make-table query 
D) update query 
E) validation rules
F)validation text
G)required field
H)default value
I)calculated field
J)<

Question 6

Validation rules are rules that a user must follow when entering the data.

Accepted Answer

A) True 
 B)False

Question 7

To use a common filter to find only those customers whose city begins with G,tap or click the arrow to the right of the field name and point to the ____ command to display the custom text filters.

Accepted Answer

A)  Text Filters 
B)  Character Filters 
C)  Common Filters 
D)  Common Character Filters

Question 8

When the Book Rep table is related to the Customer table,it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table.The customers for the book rep will appear below the book rep in a split form.____________________

Accepted Answer

A) True 
 B)False

Question 9

A(n)____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

Accepted Answer

The answer of A(n)____________________ is a form that allows you...

Question 10

To filter records using complex criteria,tap or click the ____ button on the HOME tab and then tap or click Advanced Filter/Sort on the menu that appears.

Accepted Answer

A)  Filter 
B)  Find 
C)  Selection 
D)  Advanced

Question 11

To update records using an update query,enter the field to be updated in the design grid,enter any necessary criterion,and then tap or click the ____ button to update the records.

Accepted Answer

A)  Run 
B)  View 
C)  Execute 
D)  Update

Exam 17: Access: Maintaining a Database

Filter By Query allows you to filter based on multiple criteria,for example,to find only those customers whose returns are $0.00 and whose book rep number is 42.

If you add a field to a table and later realize the field is in the wrong location,you can move the field.To move the field,tap or click the ____________________ for the field and then drag the field to the new location.

If you plan to move your data to SQL Server at a later date,do not use ____________________ fields.

Identify the letter of the choice that best matches the phrase or definition. -Allows you to delete all the records satisfying some criterion.

Identify the letter of the choice that best matches the phrase or definition. -Field that can be computed from other fields.

Validation rules are rules that a user must follow when entering the data.

To use a common filter to find only those customers whose city begins with G,tap or click the arrow to the right of the field name and point to the ____ command to display the custom text filters.

When the Book Rep table is related to the Customer table,it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table.The customers for the book rep will appear below the book rep in a split form.____________________

A(n)____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

To filter records using complex criteria,tap or click the ____ button on the HOME tab and then tap or click Advanced Filter/Sort on the menu that appears.

To update records using an update query,enter the field to be updated in the design grid,enter any necessary criterion,and then tap or click the ____ button to update the records.