S2 Microsoft Access Database Quiz

What is the primary purpose of a database?

• To create presentations

• To store and organize related data in a structured way

• To edit photos and videos

• To browse the internet

Which view in Microsoft Access allows you to modify the structure of a table?

• Form View

• Report View

• Design View

• Print View

In Microsoft Access, what is a field?

• A collection of records

• A type of report

• A column that contains specific information about an item

• A backup copy of the database

What does Datasheet View display in Access?

• Only the field names

• The data in a table format with rows and columns

• The relationships between tables

• The database security settings

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

• Circle

• Picture

• Number

• Graph

What is a record in a database?

• A single row of information in a table

• The name of a field

• A type of query

• A database password

How are fields displayed in Design View?

• As a spreadsheet

• As a form

• One field per row with properties

• As a report

Which data type would you use for storing large amounts of text?

• Currency

• Memo

• Yes/No

• Number

What is the maximum number of fields allowed in an Access table?

• 255

• 1000

• 500

• 2048

Which view would you use to enter data into a table?

• Report View

• Query View

• Design View

• Datasheet View