Using Macros in MS Access MCQs

1. What is the main purpose of a macro in MS Access?
(A) To permanently delete records
(B) To automate repetitive tasks and actions
(C) To design table structures
(D) To create queries automatically

2. Which of the following is TRUE about macros in MS Access?
(A) They allow automation without writing VBA code
(B) They require programming knowledge in SQL
(C) They can only be used in tables
(D) They are used only for importing data

3. Which of the following can a macro perform in MS Access?
(A) Open a form or report
(B) Run a query
(C) Validate data entry
(D) All of the above

4. Which tool in MS Access is used to create and edit macros?
(A) Report Wizard
(B) Table Design View
(C) Macro Designer
(D) Query Wizard

5. What type of macro runs automatically when a database is opened?
(A) AutoExec macro
(B) AutoRun macro
(C) Default macro
(D) Startup macro

6. In MS Access, embedded macros are usually stored within:
(A) Queries
(B) Reports or Forms
(C) Tables
(D) Relationships

7. Which is an advantage of using macros instead of VBA in Access?
(A) Macros allow more advanced programming
(B) Macros run faster than all queries
(C) Macros require SQL knowledge
(D) Macros are easier for beginners, no coding required

8. Which macro action would you use to automatically open a form?
(A) RunQuery
(B) OpenForm
(C) ShowTable
(D) CreateReport

9. What is the limitation of macros compared to VBA in MS Access?
(A) Macros cannot handle complex logic or error handling like VBA
(B) Macros cannot automate reports
(C) Macros cannot open forms
(D) Macros cannot run queries

10. Which of the following best describes a macro group?
(A) A collection of related forms
(B) A collection of related macros stored together
(C) A database relationship diagram
(D) A set of queries combined