Microsoft Access Quiz

What is Microsoft Access primarily used for?

• Creating presentations

• Storing and managing data

• Writing documents

• Editing images

Which field type is best for storing the title of a book?

• Number

• Short Text

• Yes/No

• Date/Time

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

• To sort data alphabetically

• To uniquely identify each record

• To make the table colorful

• To group similar data

Which data type is used for a field that will store only 'Yes' or 'No' values?

• Text

• Number

• Yes/No

• Currency

What is the default view for entering data into a table?

• Design View

• Form View

• Datasheet View

• Layout View

Which of these is NOT a valid Access data type?

• Text

• Number

• Spreadsheet

• Currency

What symbol represents a primary key in Design View?

• #

• *

• !

• Key Icon

What is a Query used for in Access?

• To delete records

• To search and filter data

• To change field names

• To design forms

Which data type should be used for the 'PublishedYear' field?

• Text

• Date/Time

• Number

• Yes/No

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

• Datasheet View

• Design View

• Form View

• Print Preview