Question 1

Which Recordset Type property value should you set for a query to prevent data from being updated?

Accepted Answer

A)   Dynaset
B)   Snapshot
C)   Static
D)   AliasE) All of the above
F) B) and C)

Question 2

Which of the following security methods makes data indecipherable to other programs when sent across a network?

Accepted Answer

A)   Encryption
B)   Password
C)   Startup options
D)   Split a databaseE) None of the above
F) B) and C)

Question 3

Set the _____ startup option to add a custom title to the title bar instead of the database name and path.

Accepted Answer

A)   Program Title
B)   Display Form
C)   Application Title
D)   'CaptionE) A) and B)
F) A) and C)

Question 4

Which Access object contains all of the data in the database?

Accepted Answer

A)   form
B)   macro
C)   table
D)   queryE) A) and C)
F) C) and D)

Question 5

Which control do you use to add a report to another report?

Accepted Answer

A)   text box
B)   subform/subreport
C)   tab control
D)   chartE) B) and C)
F) All of the above

Question 6

The _____ property determines whether users can add or edit the list of items in a lookup field.

Accepted Answer

A)   Allow Zero Length
B)   Allow Multiple Values
C)   Allow Text Box
D)   Allow Value List EditsE) A) and B)
F) C) and D)

Question 7

Which control allows you to type an entry or choose an entry from a list?

Accepted Answer

A)   combo box
B)   list box
C)   label
D)   text boxE) A) and D)
F) None of the above

Question 8

Which Short Text field property should you use to indicate users must enter a value in the field?

Accepted Answer

A)   Default
B)   Required
C)   Validation Rule
D)   Yes/NoE) A) and B)
F) C) and D)

Question 9

To query for null values, use Is Null as the criterion.

Accepted Answer

A) True 
 B)False

Question 10

The most important items in the Performance Analyzer results are the _____ and the suggestions.

Accepted Answer

A)   recommendations
B)   ideas
C)   lightbulb icons
D)   proposalsE) A) and C)
F) All of the above

Question 11

What happens when you close a module?

Accepted Answer

A)   The module begins to run automatically.
B)   The Visual Basic window closes.
C)   The module is hidden in the Navigation Pane.
D)   The Visual Basic window highlights any syntax errors.E) A) and B)
F) A) and C)

Question 12

Which of the following properties can you set for a Short Text field?

Accepted Answer

A)   Format
B)   Decimal Places
C)   Default Value
D)   Input MaskE) B) and D)
F) All of the above

Question 13

The Import Spreadsheet Wizard helps you import Excel data into Access.

Accepted Answer

A) True 
 B)False

Question 14

How can you reorder the navigation buttons in a navigation form in Form Layout view?

Accepted Answer

A)   Drag a navigation button to a new position.
B)   Use the Tab Order dialog box.
C)   Use the Ascending and Descending buttons to sort the navigation buttons.
D)   Set the Button Order property for the navigation buttons.E) A) and D)
F) A) and C)

Question 15

Use the New (blank) record button to move the focus to the first record in a table.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following are types of advice the Performance Analyzer gives regarding performance? Select all the options that apply.

Accepted Answer

A)   Suggestion
B)   Idea
C)   Issue
D)   RecommendationE) A) and B)
F) None of the above

Question 17

Standard modules contain _____.

Accepted Answer

A)   code that can be executed only from a form or report
B)   macros from earlier versions of Access
C)   a list of standard functions built into Access, such as Sum
D)   global code that can be executed from anywhere in the databaseE) None of the above
F) A) and B)

Question 18

What do you click to perform the actions in a macro?

Accepted Answer

A)   Expand All button
B)   Run button
C)   Debug button
D)   View buttonE) None of the above
F) All of the above

Question 19

When you add actions to a Group program flow, the macro does not perform the actions.

Accepted Answer

A) True 
 B)False

Question 20

You can freeze one or more fields in a datasheet so they remain visible at all times.

Accepted Answer

A) True 
 B)False

Exam 8: Access

How can you reorder the navigation buttons in a navigation form in Form Layout view?

Correct AnswerverifiedShow Answer

Which Recordset Type property value should you set for a query to prevent data from being updated?

Correct AnswerverifiedShow Answer

Set the _____ startup option to add a custom title to the title bar instead of the database name and path.

Correct AnswerverifiedShow Answer

Standard modules contain _____.

Correct AnswerverifiedShow Answer

What do you click to perform the actions in a macro?

Correct AnswerverifiedShow Answer

When you add actions to a Group program flow, the macro does not perform the actions.

Correct AnswerverifiedShow Answer

Which of the following are types of advice the Performance Analyzer gives regarding performance? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which Short Text field property should you use to indicate users must enter a value in the field?

Correct AnswerverifiedShow Answer

To query for null values, use Is Null as the criterion.

Correct AnswerverifiedShow Answer

Use the New (blank) record button to move the focus to the first record in a table.

Correct AnswerverifiedShow Answer

The most important items in the Performance Analyzer results are the _____ and the suggestions.

Correct AnswerverifiedShow Answer

Which control do you use to add a report to another report?

Correct AnswerverifiedShow Answer

You can freeze one or more fields in a datasheet so they remain visible at all times.

Correct AnswerverifiedShow Answer

The _____ property determines whether users can add or edit the list of items in a lookup field.

Correct AnswerverifiedShow Answer

Which control allows you to type an entry or choose an entry from a list?

Correct AnswerverifiedShow Answer

What happens when you close a module?

Correct AnswerverifiedShow Answer

Which of the following properties can you set for a Short Text field?

Correct AnswerverifiedShow Answer

The Import Spreadsheet Wizard helps you import Excel data into Access.

Correct AnswerverifiedShow Answer

Which Access object contains all of the data in the database?

Correct AnswerverifiedShow Answer

Which of the following security methods makes data indecipherable to other programs when sent across a network?

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