MS Access Quiz

What is the main purpose of using a form in MS Access?

• To view data

• To enter and edit data

• To delete data

• To create a database

What is the first step in creating a form in MS Access?

• Create a table

• Enter data directly into a query

• Open the Report Wizard

• Design the relationships between tables

Which tool helps you create a form automatically in MS Access?

• Form Wizard

• Table Designer

• Query Builder

• Form Layout

Which field type would you use to store a student's age in the table?

• Short Text

• Number

• AutoNumber

• Yes/No

Which control would you use to create a dropdown list in a form?

• Text Box

• Combo Box

• Label

• Check Box

What view in MS Access allows you to input data into a form?

• Design View

• Form View

• Datasheet View

• Layout View

What is a key benefit of using forms for data entry?

• It makes databases harder to use

• It simplifies and structures data entry

• It creates complex queries automatically

• It generates reports

What is the purpose of the AutoNumber field in a table?

• To automatically generate unique numbers for each record

• To input age values

• To format text data

• To calculate sums

In the sample data, what is the field type for the 'Phone Number'?

• Number

• Short Text

• Date/Time

• AutoNumber

After creating a form, where can you see the data you have entered?

• In the Relationships window

• In the Form View

• In the Table's Datasheet View

• In the Form Wizard