| Join Telegram |  |
| Join Whatsapp Groups |  |
Microsoft Access MCQs and Answers with Explanation: Welcome to the Microsoft Access Multiple Choice Questions (MCQs) section! Here, you will be able to test your knowledge and proficiency in using Microsoft Access, a powerful relational database management system. These Microsoft Access Quiz Questions cover various topics such as database design, table creation, query creation, form creation, report creation, and more.
Microsoft Access MCQ Questions and Answers
Answering these Microsoft Access MCQs/ Microsoft Access Quiz will not only help you evaluate your understanding of Access but also enhance your skills and make you a more competent user. So, before moving ahead and checking these Top 55 MS Access MCQ Questions, kindly do know about Microsoft Access first. Microsoft Access is a powerful database management system developed by Microsoft Corporation. It is widely used in various industries and domains, ranging from small businesses to large corporations, to store, manage and analyze their data. Access provides a range of tools and features, including data entry forms, queries, reports, and macros, that allow users to create and manipulate their databases more efficiently.
Microsoft Access Multiple Choice Questions
| Name | Microsoft Access |
| Exam Type | MCQ (Multiple Choice Questions) |
| Category | Technical Quiz |
| Mode of Quiz | Online |
Top 55 Microsoft Access MCQs | Practice MS Access Quiz
1. Which of the following is a relational database management system?
a) Microsoft Access
b) Microsoft Excel
c) Microsoft Word
d) Microsoft PowerPoint
Answer: a) Microsoft Access
Explanation: Microsoft Access is a relational database management system that is used to create and manage databases.
2. Which of the following is not a database object in Microsoft Access?
a) Table
b) Query
c) Form
d) Workbook
Answer: d) Workbook
Explanation: Workbooks are associated with Microsoft Excel and are not a database object in Microsoft Access.
3. Which of the following is used to create tables in Microsoft Access?
a) Form
b) Report
c) Query
d) Table Design View
Answer: d) Table Design View
Explanation: Table Design View is used to create and design tables in Microsoft Access.
4. Which of the following is used to enter data into a table in Microsoft Access?
a) Query
b) Report
c) Form
d) Table Design View
Answer: c) Form
Explanation: Forms are used to enter and view data in Microsoft Access tables.
5. Which of the following is used to search for specific data in a table in Microsoft Access?
a) Report
b) Form
c) Query
d) Table Design View
Answer: c) Query
Explanation: Queries are used to search for and retrieve specific data from tables in Microsoft Access.
6. Which of the following is used to sort data in a table in Microsoft Access?
a) Report
b) Form
c) Query
d) Table Design View
Answer: c) Query
Explanation: Queries can be used to sort data in a table in Microsoft Access.
7. Which of the following is used to create a relationship between two tables in Microsoft Access?
a) Form
b) Report
c) Query
d) Relationship Window
Answer: d) Relationship Window
Explanation: The Relationship Window is used to create and manage relationships between tables in Microsoft Access.
8. Which of the following is used to create a report in Microsoft Access?
a) Form
b) Report Design View
c) Query
d) Table Design View
Answer: b) Report Design View
Explanation: Report Design View is used to create and design reports in Microsoft Access.
9. Which of the following is used to summarize data in a table in Microsoft Access?
a) Report
b) Form
c) Query
d) Table Design View
Answer: a) Report
Explanation: Reports can be used to summarize and display data from tables in Microsoft Access.
10. Which of the following is used to create a calculated field in a query in Microsoft Access?
a) Form
b) Report
c) Query Design View
d) Table Design View
Answer: c) Query Design View
Explanation: Query Design View is used to create and modify queries in Microsoft Access, including calculated fields.
11. Which of the following is used to create a custom input mask in Microsoft Access?
a) Form Wizard
b) Report Wizard
c) Query Wizard
d) Input Mask Wizard
Answer: d) Input Mask Wizard
Explanation: The Input Mask Wizard is used to create custom input masks in Microsoft Access.
12. Which of the following is used to create a subform in Microsoft Access?
a) Form Design View
b) Report Design View
c) Query Design View
d) Subform Wizard
Answer: a) Form Design View
Explanation: Subforms can be created in Form Design View in Microsoft Access.
13. Which of the following is used to create a backup copy of a Microsoft Access database?
a) Compact and Repair Database
b) Backup Database
c) Export Database
d) Import Database
Answer: b) Backup Database
Explanation: The Backup Database option is used to create a backup copy of a Microsoft Access database.
14. Which of the following is used to compact and repair a Microsoft Access database?
a) Compact and Repair Database
b) Backup Database
c) Export Database
d) Import Database
Answer: a) Compact and Repair Database
Explanation: The Compact and Repair Database option is used to optimize and repair a Microsoft Access database.
15. Which of the following is used to import data from an external source into a Microsoft Access database?
a) Compact and Repair Database
b) Backup Database
c) Export Database
d) Import Database
Answer: d) Import Database
Explanation: The Import Database option is used to import data from external sources into a Microsoft Access database.
16. Which of the following is used to export data from a Microsoft Access database to an external source?
a) Compact and Repair Database
b) Backup Database
c) Export Database
d) Import Database
Answer: c) Export Database
Explanation: The Export Database option is used to export data from a Microsoft Access database to an external source.
17. Which of the following is used to create a macro in Microsoft Access?
a) Macro Design View
b) Form Design View
c) Report Design View
d) Query Design View
Answer: a) Macro Design View
Explanation: Macro Design View is used to create and modify macros in Microsoft Access.
18. Which of the following is used to create a module in Microsoft Access?
a) Macro Design View
b) Form Design View
c) Report Design View
d) Module Design View
Answer: d) Module Design View
Explanation: Module Design View is used to create and modify modules in Microsoft Access.
19. Which of the following is used to create a custom function in Microsoft Access?
a) Macro Design View
b) Form Design View
c) Report Design View
d) Module Design View
Answer: d) Module Design View
Explanation: Custom functions can be created in Module Design View in Microsoft Access.
20. Which of the following is used to create a data access page in Microsoft Access?
a) Data Access Page Wizard
b) Form Design View
c) Report Design View
d) Query Design View
Answer: a) Data Access Page Wizard
Explanation: The Data Access Page Wizard is used to create data access pages in Microsoft Access.
21. Which of the following is used to create a chart in a report in Microsoft Access?
a) Chart Wizard
b) Form Design View
c) Report Design View
d) Query Design View
Answer: c) Report Design View
Explanation: Charts can be added to reports in Report Design View in Microsoft Access.
22. Which of the following is used to create a hyperlink in a form in Microsoft Access?
a) Hyperlink Wizard
b) Form Design View
c) Report Design View
d) Query Design View
Answer: b) Form Design View
Explanation: Hyperlinks can be added to forms in Form Design View in Microsoft Access.
23. Which of the following is used to create a password-protected Microsoft Access database?
a) Database Encryption
b) User-Level Security Wizard
c) Object-Level Security Wizard
d) None of the above
Answer: b) User-Level Security Wizard
Explanation: The User-Level Security Wizard is used to create a password-protected Microsoft Access database.
24. Which of the following is used to create a custom error message in Microsoft Access?
a) Macro Design View
b) Form Design View
c) Report Design View
d) Module Design View
Answer: d) Module Design View
Explanation: Custom error messages can be created in Module Design View in Microsoft Access.
25. Which of the following is used to set a default value for a field in a table in Microsoft Access?
a) Field Properties
b) Table Properties
c) Form Properties
d) Report Properties
Answer: a) Field Properties
Explanation: The Field Properties option is used to set a default value for a field in a table in Microsoft Access.
26. Which of the following is used to set a validation rule for a field in a table in Microsoft Access?
a) Field Properties
b) Table Properties
c) Form Properties
d) Report Properties
Answer: a) Field Properties
Explanation: The Field Properties option is used to set a validation rule for a field in a table in Microsoft Access.
27. Which of the following is used to set a primary key for a table in Microsoft Access?
a) Field Properties
b) Table Properties
c) Form Properties
d) Report Properties
Answer: b) Table Properties
Explanation: The Table Properties option is used to set a primary key for a table in Microsoft Access.
28. Which of the following is used to set a relationship between two tables in Microsoft Access?
a) Relationship Wizard
b) Table Properties
c) Form Properties
d) Report Properties
Answer: a) Relationship Wizard
Explanation: The Relationship Wizard is used to set a relationship between two tables in Microsoft Access.
29. Which of the following is used to set a filter for a form in Microsoft Access?
a) Filter By Form
b) Filter By Selection
c) Filter By Query
d) None of the above
Answer: a) Filter By Form
Explanation: The Filter By Form option is used to set a filter for a form in Microsoft Access.
30. Which of the following is used to set a filter for a report in Microsoft Access?
a) Filter By Form
b) Filter By Selection
c) Filter By Query
d) None of the above
Answer: c) Filter By Query
Explanation: The Filter By Query option is used to set a filter for a report in Microsoft Access.
31. Which of the following is used to create a parameter query in Microsoft Access?
a) Query Wizard
b) Query Design View
c) SQL View
d) None of the above
Answer: b) Query Design View
Explanation: Parameter queries can be created in Query Design View in Microsoft Access.
32. Which of the following is used to create a crosstab query in Microsoft Access?
a) Query Wizard
b) Query Design View
c) SQL View
d) None of the above
Answer: a) Query Wizard
Explanation: Crosstab queries can be created using the Query Wizard in Microsoft Access.
33. Which of the following is used to create a form in Microsoft Access?
a) Form Wizard
b) Form Design View
c) Layout View
d) All of the above
Answer: d) All of the above
Explanation: Forms can be created using the Form Wizard, Form Design View, and Layout View in Microsoft Access.
34. Which of the following is used to create a navigation form in Microsoft Access?
a) Navigation Pane
b) Navigation Form
c) Navigation Bar
d) Navigation Menu
Answer: b) Navigation Form
Explanation: Navigation forms can be created in Microsoft Access using the Navigation Form option.
35. Which of the following is used to create a split form in Microsoft Access?
a) Form Wizard
b) Form Design View
c) Layout View
d) All of the above
Answer: a) Form Wizard
Explanation: Split forms can be created using the Form Wizard in Microsoft Access.
36. Which of the following is used to create a data macro in Microsoft Access?
a) Macro Design View
b) Table Design View
c) Form Design View
d) Report Design View
Answer: a) Macro Design View
Explanation: Data macros can be created in Macro Design View in Microsoft Access.
37. Which of the following is used to import data into Microsoft Access?
a) Import Wizard
b) Export Wizard
c) Table Design View
d) Query Design View
Answer: a) Import Wizard
Explanation: The Import Wizard is used to import data into Microsoft Access.
38. Which of the following is used to export data from Microsoft Access?
a) Import Wizard
b) Export Wizard
c) Table Design View
d) Query Design View
Answer: b) Export Wizard
Explanation: The Export Wizard is used to export data from Microsoft Access.
39. Which of the following is used to compact and repair a database in Microsoft Access?
a) Database Tools
b) Quick Access Toolbar
c) Home Tab
d) File Tab
Answer: a) Database Tools
Explanation: The Database Tools option is used to compact and repair a database in Microsoft Access.
40. Which of the following is used to create a backup of a database in Microsoft Access?
a) Save As
b) Backup Database
c) Export
d) None of the above
Answer: b) Backup Database
Explanation: The Backup Database option is used to create a backup of a database in Microsoft Access.
41. Which of the following is used to create a parameterized report in Microsoft Access?
a) Report Wizard
b) Report Design View
c) Layout View
d) None of the above
Answer: a) Report Wizard
Explanation: Parameterized reports can be created using the Report Wizard in Microsoft Access.
42. Which of the following is used to create a multivalued field in a table in Microsoft Access?
a) Field Properties
b) Table Properties
c) Form Properties
d) Report Properties
Answer: a) Field Properties
Explanation: The Field Properties option is used to create a multivalued field in a table in Microsoft Access.
43. Which of the following is used to create a calculated control in a report in Microsoft Access?
a) Report Wizard
b) Report Design View
c) Layout View
d) All of the above
Answer: b) Report Design View
Explanation: Calculated controls can be created in Report Design View in Microsoft Access.
44. Which of the following is used to create a hyperlink in a table in Microsoft Access?
a) Text Box
b) Hyperlink Field
c) Memo Field
d) None of the above
Answer: b) Hyperlink Field
Explanation: The Hyperlink Field option is used to create a hyperlink in a table in Microsoft Access.
45. Which of the following is used to create a lookup field in a table in Microsoft Access?
a) Field Properties
b) Table Properties
c) Form Properties
d) Report Properties
Answer: a) Field Properties
Explanation: The Field Properties option is used to create a lookup field in a table in Microsoft Access.
46. Which of the following is used to create a relationship between tables in Microsoft Access?
a) Relationship Wizard
b) Table Design View
c) Query Design View
d) All of the above
Answer: a) Relationship Wizard
Explanation: Relationships can be created between tables using the Relationship Wizard in Microsoft Access.
47. Which of the following is used to create a primary key in a table in Microsoft Access?
a) Field Properties
b) Table Properties
c) Form Properties
d) Report Properties
Answer: a) Field Properties
Explanation: The Field Properties option is used to create a primary key in a table in Microsoft Access.
48. Which of the following is used to create a composite key in a table in Microsoft Access?
a) Field Properties
b) Table Properties
c) Form Properties
d) Report Properties
Answer: a) Field Properties
Explanation: The Field Properties option is used to create a composite key in a table in Microsoft Access.
49. Which of the following is used to create a validation rule in a table in Microsoft Access?
a) Field Properties
b) Table Properties
c) Form Properties
d) Report Properties
Answer: a) Field Properties
Explanation: The Field Properties option is used to create a validation rule in a table in Microsoft Access.
50. Which of the following is used to create a select query in Microsoft Access?
a) Query Wizard
b) Query Design View
c) SQL View
d) All of the above
Answer: d) All of the above
Explanation: Select queries can be created using the Query Wizard, Query Design View, or SQL View in Microsoft Access.
51. Which of the following is used to create a pivot table in Microsoft Access?
a) Pivot Table Wizard
b) Pivot Table Design View
c) SQL View
d) All of the above
Answer: a) Pivot Table Wizard
Explanation: Pivot tables can be created using the Pivot Table Wizard in Microsoft Access.
52. Which of the following is used to import data into Microsoft Access from an Excel worksheet?
a) Import Wizard
b) Excel Worksheet Wizard
c) Export Wizard
d) All of the above
Answer: a) Import Wizard
Explanation: Data can be imported into Microsoft Access from an Excel worksheet using the Import Wizard.
53. Which of the following is used to export data from Microsoft Access to an Excel worksheet?
a) Import Wizard
b) Excel Worksheet Wizard
c) Export Wizard
d) All of the above
Answer: c) Export Wizard
Explanation: Data can be exported from Microsoft Access to an Excel worksheet using the Export Wizard.
54. Which of the following is used to create a backup of a Microsoft Access database?
a) Compact and Repair Database
b) Backup Wizard
c) Export Wizard
d) All of the above
Answer: d) All of the above
Explanation: A backup of a Microsoft Access database can be created using the Compact and Repair Database option, Backup Wizard, or Export Wizard.
55. Which of the following is used to set a password for a Microsoft Access database?
a) Database Properties
b) Table Properties
c) Form Properties
d) Report Properties
Answer: a) Database Properties
Explanation: A password can be set for a Microsoft Access database using the Database Properties option.
The Microsoft Access Multiple Choice Questions (MCQs) have provided a valuable opportunity for you to test your knowledge and proficiency in using this powerful database management system. By answering these Microsoft Access Quiz Questions, you will not only evaluate your understanding of Access but also enhanced your skills and become a more competent user. Whether you are a student, a professional, or an aspiring database developer, the knowledge and experience gained from these Microsoft Access Solved MCQs will prove to be valuable assets in your career. We hope that this exercise has been both enjoyable and informative, and we encourage you to continue exploring and learning more about Microsoft Access. For more Technical MCQs like Microsoft Access keep visiting us Freshersnow regularly.