Question 1

Which form creation tool can you use to build a form based on Multiple Items, Datasheet, or Split Form, for example?
A) Form Design
B) Blank Form
C) More Forms
D) Form Wizard

Accepted Answer

The "More Forms" option allows users to choose from various form creation templates including Multiple Items, Datasheet, and Split Form.

Question 2

You can add fields to a form in either Layout View or Design View.

Accepted Answer

Both Layout View and Design View allow you to add fields to a form.

Question 3

On a form, text box controls display data from an underlying record source.

Accepted Answer

Text box controls can display data from an underlying record source on a form.

Question 4

Deleting a field from a form does not delete it from the underlying table or have any effect on the data contained in the field.

Accepted Answer

When a field is deleted from a form, it only affects the display of the form and does not impact the underlying data stored in the table. Therefore, the data in the deleted field will still be present in the table, unless it is specifically deleted or updated through other means.

Question 5

In an expression, you must type the field name exactly as it was created in Table Design View; you also need to match the capitalization.​

Accepted Answer

The answer of In an expression, you must type the...

Question 6

It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

Accepted Answer

Setting the Tab Stop property to No for a text box that will not be used for data entry prevents the cursor from stopping on that text box when tabbing through the controls on a form. This can improve the usability and flow of the form.

Question 7

You can press an arrow key to move a selected control.

Accepted Answer

This is true. When a control is selected, pressing an arrow key will move it in the direction of the arrow key that was pressed.

Question 8

A background image is an image that fills the entire form or report, appearing "behind" the other controls.

Accepted Answer

A background image is an image that fills the entire form or report, appearing "behind" the other controls.

Question 9

The Spacing feature represents the space between controls.

Accepted Answer

The answer of The Spacing feature represents the space between...

Question 10

The Form Wizard prompts you for information it needs to create a form, such as the ____ for the form.
A) fields
B) title
C) layout
D) All of the above.

Accepted Answer

The Form Wizard prompts for all three options including fields, title, and layout to create a complete form.

Question 11

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?
A) Form Wizard
B) More Forms
C) Split Form
D) Navigation

Accepted Answer

The Form Wizard in Microsoft Access allows users to create a new form by answering a series of questions presented in dialog boxes. This feature can be useful for those who are new to creating forms or those who want to save time by quickly generating a form based on pre-defined themes or settings.

Question 12

Forms can be used to enter and edit data.

Accepted Answer

Forms provide a user-friendly interface for entering and editing data in a database or website.

Question 13

A form allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

Accepted Answer

A form is designed to organize the fields of a record in a user-friendly and efficient manner, making it easy for database users to navigate and interact with data.

Question 14

Each item on a form is called a control.

Accepted Answer

Each item on a form, such as a textbox or checkbox, is referred to as a control.

Question 15

If you want to apply the same formatting enhancement to multiple controls, select them at the same time to make the same change to both.

Accepted Answer

Selecting multiple controls and applying formatting changes to them simultaneously is a time-saving technique in UI design.

Question 16

Referential integrity prevents the creation of ____ records.
A) indexed
B) split
C) unlicensed
D) orphan

Accepted Answer

Referential integrity ensures that every foreign key value in one table corresponds to a primary key value in another table. If a foreign key value is entered in a table that doesn't exist in the primary key of the related table, it creates an orphan record in the table. Therefore, referential integrity prevents the creation of orphan records.

Question 17

Which of the following is NOT a form view?
A) Data
B) Form
C) Layout
D) Design

Accepted Answer

The answer of Which of the following is NOT a...

Question 18

A tab control is an unbound control.

Accepted Answer

A tab control is not bound to a specific field or record source, but rather serves as a container for other controls and allows the user to switch between different pages or tabs of information.

Question 19

Which form creation tool can you use to create a form from scratch in Form Design View?
A) Form
B) Blank Form
C) Form Design
D) Form Wizard

Accepted Answer

Form Design view allows the creation and customization of every aspect of the form, including adding fields, controls, and formatting.

Question 20

Bound controls exist only to describe or enhance the appearance of the form.

Accepted Answer

Bound controls are used to display and manipulate data from a data source, such as a table or query. They are not just for enhancing the appearance of a form.

Quiz 3: Using Forms

Which form creation tool can you use to build a form based on Multiple Items, Datasheet, or Split Form, for example?

You can add fields to a form in either Layout View or Design View.

On a form, text box controls display data from an underlying record source.

Deleting a field from a form does not delete it from the underlying table or have any effect on the data contained in the field.

In an expression, you must type the field name exactly as it was created in Table Design View; you also need to match the capitalization.​

It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

You can press an arrow key to move a selected control.

A background image is an image that fills the entire form or report, appearing "behind" the other controls.

The Spacing feature represents the space between controls.

The Form Wizard prompts you for information it needs to create a form, such as the ____ for the form.

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

Forms can be used to enter and edit data.

A form allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

Each item on a form is called a control.

If you want to apply the same formatting enhancement to multiple controls, select them at the same time to make the same change to both.

Referential integrity prevents the creation of ____ records.

Which of the following is NOT a form view?

A tab control is an unbound control.

Which form creation tool can you use to create a form from scratch in Form Design View?

Bound controls exist only to describe or enhance the appearance of the form.

In an expression, you must type the field name exactly as it was created in Table Design View; you also need to match the capitalization.