Microsoft Access and Computer Basics Quiz

What is the main purpose of Microsoft Access?

• To edit images

• To store and manage information

• To create video presentations

• To browse the internet

Which data type is best for storing a book title?

• Date/Time

• Boolean

• Text

• Numeric

What is the purpose of a primary key in a database table?

• To make records visually distinct

• To ensure unique identification of each record

• To categorize data into groups

• To apply color formatting

Which field type is suitable for storing 'Yes' or 'No' answers?

• Text

• Number

• Boolean (Yes/No)

• Currency

In which view do users typically enter data into a table?

• Layout View

• Design View

• Form View

• Datasheet View

Which of these is NOT a valid data type in Microsoft Access?

• Number

• Text

• Spreadsheet

• Currency

What symbol represents the primary key in Design View?

• *

• Key icon

• #

• %

What is the role of a query in Microsoft Access?

• To remove unwanted records

• To filter and extract specific data

• To modify table structures

• To generate new tables

What data type is best suited for a 'PublishedYear' field?

• Number

• Text

• Date/Time

• Boolean

In which view can you modify the structure of a table?

• Print Preview

• Datasheet View

• Form View

• Design View