Microsoft Access MCQs for Competitive Exams

121

The "Saved Exports" button on the External Data tab allows you to:

A View all the files you have previously exported B Manage and re-run export operations that you have saved C See who has accessed your exported files D Save the current database

Answer & Solution Discuss Save Report

122

When would linking to a data source be a better choice than importing?

A When the data source is constantly being updated by other people and you need to see the most current data B When you need a static snapshot of the data for a report C When the data source is a very small file D When you plan to delete the original data source after the operation

Answer & Solution Discuss Save Report

123

Can you export the results of a query to a new table in another Access database?

A No, you can only export to non-Access formats B Yes, using the "Export > Access" option and specifying the destination database C Only by manually copying and pasting the data D Only if the other database is empty

Answer & Solution Discuss Save Report

124

What is a potential problem with importing data from an Excel file where a column contains mixed data types (e.g., numbers and text)?

A Access will refuse to import the file B Access might guess the wrong data type for the field, causing some data to be imported incorrectly or not at all C The Excel file will become corrupted D The import process will be very slow

Answer & Solution Discuss Save Report

125

To import data from a SharePoint list, you would find the option under:

A External Data > New Data Source > From File B External Data > New Data Source > From Database C External Data > New Data Source > From Online Services D It is not possible to import from SharePoint

Answer & Solution Discuss Save Report

126

A "fixed-width" text file is one where:

A Each field is separated by a comma B Each field occupies a specific, fixed number of character spaces in each row C The file can only have a certain number of rows D The file cannot be edited

Answer & Solution Discuss Save Report

127

You can export an Access object directly to an email message as:

A The body of the email B A file attachment in various formats (e.g., PDF, Excel) C A link to the database D Both A and B, depending on the object and format

Answer & Solution Discuss Save Report

128

What is a key consideration when importing data into an existing table?

A The source data must have the exact same number of records as the destination table B The data types of the source fields must be compatible with the data types of the destination fields C The destination table must be empty D The source file must be located on your C: drive

Answer & Solution Discuss Save Report

129

Which export option would you use to create a document for a mail merge in Microsoft Word?

A PDF B Excel C Rich Text Format (.rtf) or Word (.docx) D HTML Document

Answer & Solution Discuss Save Report

130

The "Append a copy of the records to the table" option in the import wizard is used when you want to:

A Create a brand new table with the imported data B Add the imported data as new records to an existing table C Overwrite the data in an existing table D Link to the data source

Answer & Solution Discuss Save Report