11th Grade Database Assessment

What is the purpose of creating forms in an Access desktop database?

• To confuse users
• To make it easier to view or edit data
• To slow down data entry
• To complicate the database structure

How can you create a form from an existing table or query in Access?

• Click the Home tab and select New Form
• Click the Form tab and select Create Form
• Click the table or query in the Navigation Pane, then click Form on the Create tab
• Access automatically creates a form for you

What does a split form in Access provide?

• Only a Form view
• Only a Datasheet view
• Two views of the data simultaneously
• No view of the data

When is a multiple item form useful in Access?

• When you want to confuse users
• When you want a form that displays multiple records
• When you want a form with only one record at a time
• When you want a form with limited customization

What is the purpose of a sub form in Access?

• To make the main form invisible
• To complicate the form design
• To view data from multiple tables or queries on the same form
• To replace the main form

Why is creating a navigation form important if you plan to publish a database to the web?

• To slow down the navigation process
• To complicate the database structure
• Because the Access Navigation Pane does not display in a browser
• To increase data entry accuracy

What does the Form Wizard in Access allow you to do?

• Create forms with a single click
• Group and sort data
• Use fields from only one table or query
• Define complex relationships between forms and reports

How can you create a split form in Access?

• Click the Form tab and select Split Form
• Use the Split Form tool in the Create tab after selecting a table or query
• Access does not support split forms
• Manually create two separate forms

Which form type in Access allows for displaying multiple records with more customization than a datasheet?

• Split form
• Sub form
• Navigation form
• Multiple item form

What object in Access is similar to display cases in stores for data viewing and editing?

• Forms
• Tables
• Queries
• Reports