Microsoft Access MCQs for Competitive Exams

111

To create a macro that runs when a user clicks a button on a form, you would attach the macro to the button's _________ event.

A On Load B On Timer C On Click D On Dirty

Answer & Solution Discuss Save Report

112

What is a "Trusted Location" in Access security settings?

A A list of trusted users B A folder on your computer or network that you have designated as safe, allowing databases in it to run without security warnings C The default folder where Access is installed D A website for getting help with Access

Answer & Solution Discuss Save Report

113

When you open an Access database from an untrusted location, a yellow ____________ often appears below the Ribbon.

A Message Bar with a security warning B Welcome message C Search bar D List of recent files

Answer & Solution Discuss Save Report

114

What is a Macro in Microsoft Access?

A A type of table for storing very large numbers B A tool for automating tasks and adding functionality to your database without writing programming code C A security feature that encrypts the database D A report that summarizes database activity

Answer & Solution Discuss Save Report

115

The process of linking the tables of a database to a separate "front-end" file is known as:

A Compacting the database B Encrypting the database C Splitting the database D Exporting the database

Answer & Solution Discuss Save Report

116

Can you import data directly from a web page (HTML file)?

A No, this is not possible B Yes, but only if the data is in a properly formatted table on the web page C Yes, Access can import any text from any web page D Only by copying and pasting manually

Answer & Solution Discuss Save Report

117

The "XML File" import/export option is used for:

A Exchanging data in a structured, text-based format that is both human-readable and machine-readable B Creating web pages C Storing compressed backup files D Importing images

Answer & Solution Discuss Save Report

118

If you export a query to Excel, what gets exported?

A The design of the query itself B The SQL code of the query C The data records that are returned when the query is run D A link to the query in the Access database

Answer & Solution Discuss Save Report

119

Before importing a large text file, it is good practice to:

A Open the text file to check for inconsistencies, such as missing delimiters or incorrect data B Restart your computer C Convert the text file to an Excel file first D Encrypt the text file

Answer & Solution Discuss Save Report

120

To ensure that an exported report maintains its exact visual layout, fonts, and colors, the best format is:

A Plain Text (.txt) B Excel (.xlsx) C PDF or XPS D CSV (.csv)

Answer & Solution Discuss Save Report