Flipped Learning Review Quiz

1. What is the main purpose of a table in a database?

• To store formulas

• To display charts

• To store and organise related data

• To write essays

2. In Microsoft Access, what is a field?

• A file name

• A row in the table

• A column that stores a specific type of data

• A type of database
  

3. Which of the following is an example of a suitable field name?

• 123Field

• !@#Data

• Student Name

• Table1

4. What is a primary key used for?

• To store images

• To create a heading

• To uniquely identify each record in a table

• To add colour to the table

5. Which field would best use the Date/Time data type?

• Student Name

• Date of Birth

• Age

• Gender

6. What data type should you choose for storing whole numbers (e.g., quantity)?

• Text

• Date/Time

• Number

• Currency

7. Which data type is best for storing prices like AED 25.50?

• Number

• Text

• Currency

• Date/Time

8. Can a table have more than one primary key?

• Yes, always

• No, only one primary key is allowed

• Only in Excel

• Yes, but only in reports

9. Which view in Access allows you to enter field names and data types?

• Form View

• Datasheet View

• Design View

• Query View

10. Why is it important to choose the correct data type for each field?

• It makes the table colourful

• It helps Access sort the data

• It ensures the data is stored accurately and functions properly

• It reduces file size