Microsoft Access MCQs for Competitive Exams

141

Which tab on the Ribbon contains all the commands for importing and exporting data?

A Home B Create C External Data D Database Tools

Answer & Solution Discuss Save Report

142

What is the main difference between "importing" data from Excel and "linking" to an Excel file?

A Importing creates a copy of the data in Access; linking creates a live connection to the original Excel file. B Linking is faster than importing. C You can edit data in a linked table, but not in an imported table. D There is no difference.

Answer & Solution Discuss Save Report

143

"Exporting" data from Access means:

A Bringing data into Access from another program B Saving data from an Access object (like a table or query) into an external file format C Creating a query D Deleting data from a table

Answer & Solution Discuss Save Report

144

"Importing" data into Access means:

A Sending data from Access to another program, like Excel B Creating a new table in Access and populating it with a copy of data from an external source C Printing data from Access D Creating a relationship between two tables

Answer & Solution Discuss Save Report

145

Before running an action query, it's a good practice to:

A First run it as a Select Query to preview which records will be affected B Delete the table it will affect C Close the database D Back up the entire database

Answer & Solution Discuss Save Report

146

To perform a calculation in a query, you create a new field and type an _________ into it.

A Report B Table Name C Expression D Action

Answer & Solution Discuss Save Report

147

The SQL statement `SELECT * FROM Customers;` will:

A Select only the first field from the Customers table B Select all fields from the Customers table C Select only the last field from the Customers table D Generate an error

Answer & Solution Discuss Save Report

148

The `Is Null` criterion is used to find records where:

A A field has a value of zero B A field has an empty or blank value C A field contains text D A field contains an error

Answer & Solution Discuss Save Report

149

An "Inner Join" (the default join type in Access) will return:

A All records from the first table, and only matching records from the second table B All records from both tables, regardless of whether they match C Only the records where the joined fields from both tables are equal D All records from the second table, and only matching records from the first table

Answer & Solution Discuss Save Report

150

A "Join" in a query is used to:

A Combine the text from two fields into one B Combine records from two or more related tables based on a common field C Add new records to a table D Filter records

Answer & Solution Discuss Save Report