Microsoft Access MCQs for Competitive Exams

91

Disabling macros in the Trust Center will:

A Delete all existing macros from your databases B Prevent any macros from running in any database you open, unless it is in a trusted location C Convert all your macros to VBA code D Only affect macros in forms

Answer & Solution Discuss Save Report

92

The back-end of a split database contains only the:

A Forms and Reports B Queries and Macros C Tables D User interface elements

Answer & Solution Discuss Save Report

93

A "Conditional Block" (If/Else/End If) in a macro allows you to:

A Run the same action multiple times B Run different actions based on whether a certain condition is true or false C Add a comment to your macro D Stop the macro from running

Answer & Solution Discuss Save Report

94

Before you can encrypt a database with a password, you must:

A Open it in "Exclusive" mode B Split the database C Delete all the macros D Back up the database

Answer & Solution Discuss Save Report

95

What is the `SetTempVar` macro action used for?

A To set the computer's temporary folder location B To create a temporary variable that can store a value to be used later in the macro or by other objects C To change the temperature settings of the CPU D To create a temporary table

Answer & Solution Discuss Save Report

96

Why might a company choose to disable all macros by default across their organization via group policy?

A Macros slow down computers B As a security measure to prevent users from accidentally running malicious code from an untrusted email attachment C Macros are an old feature and are no longer supported D To save on software licensing costs

Answer & Solution Discuss Save Report

97

The "Single Step" mode for debugging a macro allows you to:

A Run the entire macro at once B Run the macro one action at a time, pausing after each step C Check the macro for spelling errors D Undo the actions of a macro

Answer & Solution Discuss Save Report

98

To run a macro that opens a report and then closes the database, you would need how many actions in the Macro Builder?

A One B Two C Three D Four

Answer & Solution Discuss Save Report

99

What is the role of an "argument" for a macro action?

A It specifies the conditions under which the macro will run B It provides the specific information needed for an action to run, such as which form to open or which query to run C It is a comment explaining what the action does D It is an error message

Answer & Solution Discuss Save Report

100

If you forget the password you used to encrypt an Access database:

A You can call Microsoft to have it reset B The data is generally considered unrecoverable C You can use a master password to open it D It can be easily removed in the Trust Center

Answer & Solution Discuss Save Report