Importing and Exporting Data in MS Access MCQs

1. What is the purpose of importing data into MS Access?
(A) To design forms automatically
(B) To bring data from external sources into Access tables
(C) To delete old records from Access
(D) To create reports directly

2. Which of the following formats can data be imported from into MS Access?
(A) Excel files
(B) Text/CSV files
(C) Other Access databases
(D) All of the above

3. What is the difference between importing and linking data in MS Access?
(A) Importing copies data into Access; linking creates a live connection
(B) Importing keeps a live connection; linking copies data
(C) Both importing and linking copy data permanently
(D) Both importing and linking delete the source file

4. When exporting a table from Access to Excel:
(A) The table structure only is exported
(B) Only queries are exported
(C) Both table data and structure are exported
(D) Data is deleted from Access

5. Which wizard in MS Access helps in importing text files such as CSV?
(A) Query Wizard
(B) Import Text Wizard
(C) Report Wizard
(D) Export Wizard

6. Exporting a report as PDF in MS Access is useful because:
(A) It allows further editing of records
(B) It converts the database to Excel format
(C) It automatically updates linked data
(D) It creates a secure, read-only, and printable document

7. What must be ensured when importing data from Excel into Access?
(A) Worksheet has consistent column names
(B) Workbook is at least 1 GB in size
(C) File contains no text fields
(D) Workbook must be password protected

8. Which option allows Access data to stay updated when the external source changes?
(A) Importing the data
(B) Exporting the data
(C) Linking the data source
(D) Archiving the data

9. Which export format is most suitable for advanced calculations and data analysis?
(A) PDF
(B) Excel
(C) Text File
(D) HTML

10. Which of the following is NOT a valid export destination in MS Access?
(A) Excel
(B) Word
(C) PDF
(D) Windows Media Player