Building a Form in Microsoft Access

Why is the Form Wizard chosen for building the form?

• It does the heavy lifting for the user.

• It creates tables automatically.

• It generates reports quickly.

• It deletes unnecessary data.

Which view in Access allows you to enter, edit, and look at your data in a "live" environment?

• Form View

• Layout View

• Design View

• Table View

Which view in Access is best for making major changes to the structure of a form, such as adding buttons or code, but does not show the data?

• Form View

• Layout View

• Design View

• Data View

What is the main purpose of the Layout View in Access?

• To enter and edit data

• To change the look and feel of the form while seeing your data

• To add advanced features like buttons or code

• To delete forms

Which of the following is NOT a feature of the Form View in Access?

• Entering data

• Editing data

• Changing the layout while seeing data

• Looking at your data

How do forms help reduce mistakes when entering data?

• By showing one record at a time.

• By hiding all records.

• By allowing multiple users to edit at once.

• By deleting old records automatically.

Jackson has been asked to enter new staff details for his company. Which interface would likely reduce errors and make the process easier for him?

• The Raw Data (Table)

• The Friendly Interface (Form)

• A blank sheet of paper

• A calculator

What is a Primary Key (PK) in a database table?

• A field that can have duplicate values in a table.

• The unique identifier for each record in a table.

• A field used to store foreign data.

• A field that is always left empty.

Why is it important to use relationships like one-to-many in a database?

• It keeps data consistent, accurate, and reliable

• It makes the database slower

• It increases the risk of data errors

• It limits the number of staff members per department

Which of the following best describes an update anomaly in a large spreadsheet?

• Having to update the same information in multiple places, risking inconsistency

• Automatically correcting all errors

• Preventing any data from being deleted

• Making the spreadsheet smaller