Microsoft Access and AI Quiz

What is the primary function of Microsoft Access?

• To design graphics

• To store and manage data

• To write and edit documents

• To create multimedia presentations

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

• Date/Time

• Yes/No

• Short Text

• Currency

What role does the primary key play in a database table?

• To ensure each record is uniquely identifiable

• To help with alphabetical sorting

• To group related data

• To color-code the entries

Which data type should be used for a field storing only 'Yes' or 'No' values?

• Text

• Number

• Yes/No

• Currency

Which view is most commonly used for entering data into a table?

• Layout View

• Design View

• Form View

• Datasheet View

Which of the following is NOT a valid data type in Access?

• Number

• Text

• Spreadsheet

• Currency

What symbol represents the primary key in Design View?

• *

• Key Icon

• #

• !

What function does a Query serve in Access?

• To delete records

• To filter and search for data

• To design reports

• To change table structures

What data type should be used for storing a 'PublishedYear' field?

• Number

• Text

• Date/Time

• Yes/No

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

• Print Preview

• Datasheet View

• Form View

• Design View