Microsoft Access MCQs for Competitive Exams

131

When you link to a data source, can you change the table's structure (e.g., add or delete fields) from within Access?

A Yes, you have full control over the linked table's structure B No, the structure of a linked table can only be changed in the original source application C Only if the source is another Access database D Only if you have administrator rights

Answer & Solution Discuss Save Report

132

What is a "delimited" text file?

A A text file that is password protected B A text file where the columns are separated by a specific character, such as a comma or a tab C A text file that has a fixed number of lines D A text file that contains images

Answer & Solution Discuss Save Report

133

The "Get & Transform Data" features (also known as Power Query) in modern Access and Excel are used for:

A Advanced data cleaning, shaping, and transformation before the final import B Creating forms and reports C Setting database passwords D Designing table relationships

Answer & Solution Discuss Save Report

134

To start the process of bringing data from an Excel spreadsheet into a new Access table, you would go to:

A External Data > New Data Source > From File > Excel B Home > Import > Excel C Create > Import from Excel D Database Tools > Import Excel File

Answer & Solution Discuss Save Report

135

Which of the following is NOT a common source for importing data into Access?

A Excel File B Text (CSV) File C Another Access Database D A Photoshop (.psd) File

Answer & Solution Discuss Save Report

136

When linking to a table in another Access database, what does Access create in your current database?

A A full copy of the table and its data B A new query C A shortcut, or pointer, to the original table D A report based on the table

Answer & Solution Discuss Save Report

137

What is the purpose of saving import or export steps?

A To create a backup of the data B To allow you to quickly re-run the same import or export operation in the future without going through the wizard again C To encrypt the data during the transfer D To share the data with other users

Answer & Solution Discuss Save Report

138

If you want to send a formatted, non-editable version of an Access report to a colleague who does not have Access, which is the best export format?

A Excel (.xlsx) B Text File (.txt) C PDF (.pdf) D Another Access Database (.accdb)

Answer & Solution Discuss Save Report

139

When importing data from an Excel file, the Import Wizard allows you to:

A Specify if the first row contains column headings B Choose which worksheet or named range to import C Let Access choose a primary key or select your own D All of the above

Answer & Solution Discuss Save Report

140

Which file format is commonly used for importing and exporting tabular data and is easily opened by spreadsheet programs?

A .pdf (Portable Document Format) B .docx (Word Document) C .csv (Comma Separated Values) D .mp3 (Audio File)

Answer & Solution Discuss Save Report