Question 1

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

Accepted Answer

A)   Input Mask
B)   Format
C)   Visual Guide
D)   Caption

Question 2

For a State field that stores two-letter state abbreviations, you can set the _____ property for the field in Table Datasheet view.

Accepted Answer

A)   Default Value
B)   Format
C)   Field Size
D)   Lookup

Question 3

How can you identify a linked table in a database?

Accepted Answer

A)   A linked table appears with a link icon in the Navigation Pane.
B)   A linked table opens in a separate window, not on a tab.
C)   A linked table is red in the Linked Table Manager.
D)   A linked table has "Linked" at the beginning of its name.

Question 4

In a database with a Products table and Orders table, you want to see which products have not been ordered.What type of query should you create?

Accepted Answer

A)   Select query with a self join.
B)   Update query.
C)   Select query with an outer join.
D)   Append query.

Question 5

Where do you set the Allow Multiple Values property of a field in Table Design view?

Accepted Answer

A)   in the Data Type column of the upper pane
B)   on the Lookup tab of the Field Properties pane
C)   in the property sheet for the table
D)   in the Description column of the upper pane

Question 6

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

Accepted Answer

A) True 
 B)False

Question 7

Each item on a form is called a _____.

Accepted Answer

A)   control
B)   field
C)   layout
D)   format

Question 8

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

Accepted Answer

A)   
B)   > 0
C)   '+ 1
D)   "Positive"

Question 9

You set the opening Display Form for a database using the Access Preferences dialog box.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following are Access data types? Select all the options that apply.

Accepted Answer

A)   Number
B)   Street Address
C)   Date/Time
D)   Currency

Question 11

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

Accepted Answer

A)   select query
B)   subtotal query
C)   statistics query
D)   summary query

Question 12

Which of the following are action queries? Select all the options that apply.

Accepted Answer

A)   Delete query
B)   Update query
C)   Depend query
D)   Append query

Question 13

In which object can you rename a field?

Accepted Answer

A)   form
B)   macro
C)   report
D)   table

Question 14

In Query Design view, you enter parameter criteria within curly brackets, as in {Enter department:}.

Accepted Answer

A) True 
 B)False

Question 15

When you export a query to use in Word, Access creates a Rich Text Format (RTF) file.

Accepted Answer

A) True 
 B)False

Question 16

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

Accepted Answer

A) True 
 B)False

Question 17

When does Access save changes you make to a record?

Accepted Answer

A)   when you click the Save button
B)   when you close the table
C)   when you move to a different record
D)   when you select the record

Question 18

A command button in a report typically appears in the _____ section.

Accepted Answer

A)   Detail
B)   Report Header
C)   Group Header
D)   Totals

Question 19

In Table Design view, "State must be AZ or CO" is an example of integrity text.

Accepted Answer

A) True 
 B)False

Question 20

Use the Move up and Move down buttons to move macro actions in Macro Design View.

Accepted Answer

A) True 
 B)False

Exam 9: Access

In a database with a Products table and Orders table, you want to see which products have not been ordered.What type of query should you create?

Correct AnswerverifiedShow Answer

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

Correct AnswerverifiedShow Answer

Which of the following are Access data types? Select all the options that apply.

Correct AnswerverifiedShow Answer

When does Access save changes you make to a record?

Correct AnswerverifiedShow Answer

In Table Design view, "State must be AZ or CO" is an example of integrity text.

Correct AnswerverifiedShow Answer

Which of the following are action queries? Select all the options that apply.

Correct AnswerverifiedShow Answer

When you export a query to use in Word, Access creates a Rich Text Format (RTF) file.

Correct AnswerverifiedShow Answer

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

Correct AnswerverifiedShow Answer

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

Correct AnswerverifiedShow Answer

Each item on a form is called a _____.

Correct AnswerverifiedShow Answer

Use the Move up and Move down buttons to move macro actions in Macro Design View.

Correct AnswerverifiedShow Answer

You set the opening Display Form for a database using the Access Preferences dialog box.

Correct AnswerverifiedShow Answer

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

Correct AnswerverifiedShow Answer

In which object can you rename a field?

Correct AnswerverifiedShow Answer

In Query Design view, you enter parameter criteria within curly brackets, as in {Enter department:}.

Correct AnswerverifiedShow Answer

How can you identify a linked table in a database?

Correct AnswerverifiedShow Answer

Where do you set the Allow Multiple Values property of a field in Table Design view?

Correct AnswerverifiedShow Answer

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

Correct AnswerverifiedShow Answer

For a State field that stores two-letter state abbreviations, you can set the _____ property for the field in Table Datasheet view.

Correct AnswerverifiedShow Answer

A command button in a report typically appears in the _____ section.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified