1. What is the primary purpose of Microsoft Access?
A) Word processing
B) Spreadsheet analysis
C) Database management
D) Presentation design
Answer: C) Database management
2. Which of the following is a type of database object in Access?
A) Table
B) Form
C) Report
D) All of the above
Answer: D) All of the above
3. What is the purpose of a primary key in an Access table?
A) To uniquely identify each record
B) To establish relationships between tables
C) To sort and index data
D) To create a backup of the database
Answer: A) To uniquely identify each record
4. What is a query in Access?
A) A request for data from a table
B) A new table created from existing data
C) A report based on a table or query
D) A form used to enter data
Answer: A) A request for data from a table
5. How do you create a new database in Access?
A) File > New > Database
B) File > Open > Database
C) File > Save > Database
D) File > Exit > Database
Answer: A) File > New > Database
6. What is the purpose of a relationship between tables in Access?
A) To combine data from multiple tables
B) To create a new table from existing data
C) To establish a connection between tables
D) To delete data from a table
Answer: C) To establish a connection between tables
7. What is a form in Access?
A) A table used to store data
B) A query used to retrieve data
C) A report used to display data
D) A user interface used to interact with data
Answer: D) A user interface used to interact with data
8. How do you create a new table in Access?
A) File > New > Table
B) File > Open > Table
C) File > Save > Table
D) File > Exit > Table
Answer: A) File > New > Table
9. What is a report in Access?
A) A table used to store data
B) A query used to retrieve data
C) A form used to interact with data
D) A formatted display of data
Answer: D) A formatted display of data
10. How do you create a new query in Access?
A) File > New > Query
B) File > Open > Query
C) File > Save > Query
D) File > Exit > Query
Answer: A) File > New > Query
11. What is the purpose of indexing a field in Access?
A) To sort data in ascending order
B) To sort data in descending order
C) To improve query performance
D) To delete data from a table
Answer: C) To improve query performance
12. How do you create a new form in Access?
A) File > New > Form
B) File > Open > Form
C) File > Save > Form
D) File > Exit > Form
Answer: A) File > New > Form
13. What is the purpose of a subform in Access?
A) To display data from a single table
B) To display data from multiple tables
C) To create a new table from existing data
D) To delete data from a table
Answer: B) To display data from multiple tables
14. How do you create a new report in Access?
A) File > New > Report
B) File > Open > Report
C) File > Save > Report
D) File > Exit > Report
Answer: A) File > New > Report
15. What is the purpose of a macro in Access?
A) To automate repetitive tasks
B) To create a new table from existing data
C) To delete data from a table
D) To sort data in ascending order
Answer: A) To automate repetitive tasks
16. How do you create a new macro in Access?
A) File > New > Macro
B) File > Open > Macro
C) File > Save > Macro
D) File > Exit > Macro
Answer: A) File > New > Macro
17. What is the purpose of a module in Access?
A) To create a new table from existing data
B) To delete data from a table
C) To sort data in ascending order
D) To store and run VBA code
Answer: D) To store and run VBA code
Click here for more
Advanced Excel MCQs Questions and Answers Pdf
Ms PowerPoint MCQs ll Ms PowerPoint MCQs Online Test
18. How do you create a new module in Access?
A) File > New > Module
B) File > Open > Module
C) File > Save > Module
D) File > Exit > Module
Answer: A) File > New > Module
19. What is the purpose of the "AutoNumber" data type in Access?
A) To store text data
B) To store numerical data
C) To automatically assign a unique number to each record
D) To store date and time data
Answer: C) To automatically assign a unique number to each record
20. How do you create a new field in an Access table?
A) Right-click on the table and select "Insert Field"
B) Go to the "Design" view and click on the "Field" button
C) Go to the "Datasheet" view and click on the "Insert" button
D) Go to the "Home" tab and click on the "Field" button
Answer: B) Go to the "Design" view and click on the "Field" button
21. What is the purpose of the "Lookup" field in Access?
A) To store text data
B) To store numerical data
C) To display a list of values from which the user can select
D) To store date and time data
Answer: C) To display a list of values from which the user can select
22. How do you create a new relationship between two tables in Access?
A) Go to the "Relationships" window and click on the "New" button
B) Go to the "Design" view of one of the tables and click on the "Relationship" button
C) Go to the "Datasheet" view of one of the tables and click on the "Relationship" button
D) Go to the "Home" tab and click on the "Relationship" button
Answer: A) Go to the "Relationships" window and click on the "New" button
23. What is the purpose of the "Index" feature in Access?
A) To sort data in ascending order
B) To sort data in descending order
C) To improve query performance
D) To delete data from a table
Answer: C) To improve query performance
24. How do you create a new query in Access?
A) Go to the "Create" tab and click on the "Query" button
B) Go to the "Design" view of a table and click on the "Query" button
C) Go to the "Datasheet" view of a table and click on the "Query" button
D) Go to the "Home" tab and click on the "Query" button
Answer: A) Go to the "Create" tab and click on the "Query" button
25. What is the purpose of the "Group By" feature in Access?
A) To sort data in ascending order
B) To sort data in descending order
C) To group data by one or more fields
D) To delete data from a table
Answer: C) To group data by one or more fields
26. How do you create a new form in Access?
A) Go to the "Create" tab and click on the "Form" button
B) Go to the "Design" view of a table and click on the "Form" button
C) Go to the "Datasheet" view of a table and click on the "Form" button
D) Go to the "Home" tab and click on the "Form" button
Answer: A) Go to the "Create" tab and click on the "Form" button
27. What is the purpose of the "Subform" feature in Access?
A) To display data from a single table
B) To display data from multiple tables
C) To create a new table from existing data
D) To delete data from a table
Answer: B) To display data from multiple tables
28. How do you create a new report in Access?
A) Go to the "Create" tab and click on the "Report" button
B) Go to the "Design" view of a table and click on the "Report" button
C) Go to the "Datasheet" view of a table and click on the "Report" button
D) Go to the "Home" tab and click on the "Report" button
Answer: A) Go to the "Create" tab and click on the "Report" button
29. What is the purpose of the "Primary Key" in an Access table?
A) To uniquely identify each record
B) To establish relationships between tables
C) To sort and index data
D) To delete data from a table
Answer: A) To uniquely identify each record
30. What is the purpose of the "Query Wizard" in Access?
A) To create a new table
B) To create a new query
C) To create a new form
D) To create a new report
Answer: B) To create a new query
31. What is the purpose of the "Validation Rule" in an Access table?
A) To ensure data consistency
B) To establish relationships between tables
C) To sort and index data
D) To delete data from a table
Answer: A) To ensure data consistency
32. How do you create a new form in Access?
A) Go to the "Create" tab and click on the "Form" button
B) Go to the "Design" view of a table and click on the "Form" button
C) Go to the "Datasheet" view of a table and click on the "Form" button
D) Go to the "Home" tab and click on the "Form" button
Answer: A) Go to the "Create" tab and click on the "Form" button
33. What is the purse of the "Macro" feature in Access?
A) To automate repetitive tasks
B) To create a new table from existing data
C) To delete data from a table
D) To sort data in ascending order
Answer: A) To automate repetitive tasks
Let me know in the comment if you want pdf file 🗃️.
0 Comments