Microsoft Access Forms Quiz: What Happens When You Change Records?

Question one, you changed the label besides the text box from first name to first space name.

What changes? The underlying table field is renamed, only the label displayed to the user changes, access creates a second first name field, or the text box becomes unbound.

That is B, only the label displayed to the user

changes.

Question two, staff members need to enter customer information, but they should not see the customer's credit limits.

What is the best form design choice? Delete the credit limit field from the table, change credit limit to an auto number field, leave credit limit off the staff form, put credit limit in

the form header.

That is C, leave credit limit off the

staff form.

Question 3.

After saving and reopening a bound form, which view is normally used to enter and edit its records? Form view, layout view,

design view, or print preview? That's going to be A, form view.

Question 4.

A user edits a record on a bound form and the pencil icon appears.

What normally happens when the user moves to another record? The edit is discarded automatically.

Access saves the edit only when Control-S is pressed.

The form becomes read-only until reopened.

Or Access saves the changed record to its

underlying table.

That'll be D.

Access saves

the changed record to its underlying table.

And question five.

You want to display many records at once with the same custom set of controls repeated for each record.

Which type of form is designed for that? A single record form, continuous form, split form, or a modal