1. What is the primary purpose of a database?

A) Store unstructured data
B) Organize and retrieve structured data
C) Process images
D) Create text documents

2. Which of the following best describes a flat-file database?

A) Multiple tables with relationships
B) A single table storing all data
C) Data split across multiple databases
D) Hierarchical data structure

3. In a normalized database, what is the goal of normalization?

A) Minimize redundancy
B) Increase data entry speed
C) Maximize redundancy
D) Reduce the number of tables

4. Which relationship type is described by a scenario where each doctor can treat multiple patients, and each patient can see multiple doctors?

A) One-to-one
B) One-to-many
C) Many-to-one
D) Many-to-many

5. In a one-to-many relationship, which of the following is true?

A) One record in the first table relates to many records in the second table
B) Many records in the first table relate to one record in the second table
C) Both tables contain the same data
D) One record in the first table relates to one record in the second table

6. Which view in Access displays data in a grid format, similar to an Excel spreadsheet?

A) Form View
B) Datasheet View
C) Design View
D) Layout View

7. When entering data in Datasheet View, how do you add a new record?

A) Click on the new (blank) row at the bottom of the datasheet
B) Right-click on the datasheet and select “Add Record”
C) Use the toolbar to insert a record
D) Press Ctrl + N

8. What is the correct method to change a value in an existing record in Datasheet View?

A) Delete the record and re-enter all data
B) Click on the cell, modify the value, and press Enter
C) Modify the value in the Table Design View
D) Create a new query and update the value

9. Which action does not happen automatically when adding a new record in Datasheet View?

A) Saving the record
B) Auto-incrementing the primary key
C) Auto-filling all fields
D) Displaying the new record at the bottom

10. How do you delete a record in Datasheet View?

A) Right-click the record selector and choose “Delete Record”
B) Select the record and press Delete
C) Highlight the record and press Backspace
D) Double-click the record selector

11. Which of the following is a correct method to sort data in Datasheet View?

A) Use the Sort buttons on the toolbar
B) Rearrange the columns manually
C) Use a macro to sort
D) Create a new table for sorting

12. What is an aggregate function used for in a database?

A) Perform calculations on a set of values
B) Retrieve a specific record
C) Change data types of fields
D) Merge two tables

13. Which of the following aggregate functions returns the total number of records in a table?

A) SUM
B) COUNT
C) AVERAGE
D) MAX

14. What is the correct process for printing records from a datasheet?

A) Select File > Print and choose print options
B) Right-click the datasheet and select “Print”
C) Export the datasheet to Excel and print from Excel
D) Create a report and print from the report