Microsoft Access MCQs for Competitive Exams

101

A "data macro" is a type of macro that is attached to:

A A form event B A report event C A table event (e.g., Before Change, After Insert) D The database startup

Answer & Solution Discuss Save Report

102

What does "compiling" an Access database into an ACCDE file do?

A It encrypts the database with a password B It removes all the data from the tables C It compiles all VBA code, removes the source code, and prevents changes to the design of forms, reports, and modules D It splits the database into a front-end and back-end

Answer & Solution Discuss Save Report

103

The `MsgBox` macro action is used to:

A Send an email message B Display a pop-up message box with information or a warning for the user C Find a specific record D Close the current form

Answer & Solution Discuss Save Report

104

What is the main security benefit of a split database design?

A The front-end can be easily replaced or updated without affecting the data in the back-end B It prevents users from directly accessing and modifying the tables in the back-end C It encrypts the network traffic between the front-end and back-end D Both A and B

Answer & Solution Discuss Save Report

105

By default, Access is typically configured to ___________ macros in databases from untrusted sources.

A Run all B Disable all with notification C Ask for a password before running D Delete all

Answer & Solution Discuss Save Report

106

An "embedded macro" is a macro that is:

A Stored as part of an object's event property, rather than as a separate object in the Navigation Pane B Sent as an email attachment C Used to import data D Written in VBA instead of the Macro Builder

Answer & Solution Discuss Save Report

107

Where would you go to manage security settings like Trusted Locations and Macro Settings?

A The Create tab B The Database Tools tab C The Access Options > Trust Center D The Navigation Pane

Answer & Solution Discuss Save Report

108

Splitting a database into a "front-end" and a "back-end" is a common strategy to:

A Improve performance and security in a multi-user environment B Make the database file larger C Combine two databases into one D Delete all macros from the database

Answer & Solution Discuss Save Report

109

Which of the following is an example of an "Action" you can choose in the Macro Builder?

A OpenForm B RunQuery C CloseDatabase D All of the above

Answer & Solution Discuss Save Report

110

The "Encrypt with Password" feature in Access is used to:

A Hide specific tables from certain users B Scramble the entire database file so that it cannot be opened without the correct password C Prevent users from editing data in forms D Create a read-only copy of the database

Answer & Solution Discuss Save Report