Time for a quick Microsoft Access forms quiz. These are beginner-level questions, but they cover some of the little details that can make form design either smooth and painless or oddly frustrating. Grab a piece of paper if you want to keep score, and try to answer each question before checking the answer.
The questions below cover form record sources, bound controls, attached labels, resizing the Detail section, and one very common misconception about changing a text box's colors. The T-Rex is staying behind the fence. Hopefully.
Question 1: Which form property tells Access which table or query supplies its records?
A. Record Source
B. Record Source
C. Caption
D. Default View
The answer is Record Source. A form's Record Source is where Access gets the records displayed on that form. It can point to a table, a saved query, or even an SQL statement in more advanced situations. The Caption merely changes the text shown in the form's title bar, and Default View controls how the form is displayed.
Question 2: You drag a Short Text field from Add Existing Fields onto a blank form in Design View. What normally appears?
A. A new table and a query
B. A label containing every record
C. An unbound text box only
D. A bound text box and an attached label
The answer is D, a bound text box and an attached label. Access creates a text box that is bound to the field you dragged onto the form, plus a label that displays a friendly caption for that control. The text box shows and edits data from the underlying record. The label is just the descriptive text sitting next to it.
Question 3: You want to remove an attached label but keep its text box on the form. What should you delete?
A. Only the label
B. Only the text box
C. The field in the table
D. Both controls, then save the form
The answer is A, only the label. The label and text box may be attached to one another for moving and positioning purposes, but they are still separate controls. Select the label itself and delete it. Do not delete the text box unless you also want to remove the control that displays and edits the field's data. And definitely do not delete the field from the table just because you do not like the label. That would be using a chainsaw to open an envelope.
Question 4: A form has a large unused area below its controls. How can you reduce that space in Design View?
A. Make every text box taller
B. Delete records from the table
C. Drag the bottom edge of the Detail section upward
D. Change the form's Record Source
The answer is C, drag the bottom edge of the Detail section upward. In Design View, the Detail section has a lower boundary that you can drag upward to eliminate unused space. This is a simple cleanup step, but it makes forms look much more intentional. Nobody needs a form with three controls at the top and a football field of blank space underneath.
Question 5: You change an editable text box's background to gray. What does that change do by itself?
A. Prevents users from typing in it
B. Changes its appearance but does not prevent editing
C. Changes its field to AutoNumber
D. Removes it from the tab order
The answer is B, it changes the appearance but does not prevent editing. Changing the Back Color property is cosmetic. A gray text box can still be editable unless you change other properties, such as Locked or Enabled, or otherwise control editing through the form's settings. Color can suggest that something is read-only, but Access does not enforce that suggestion automatically.
How did you do? A perfect 5 out of 5 means you are well on your way to saving the park and all of its customer data. Missed a couple? No worries. These are exactly the kinds of form basics that become second nature once you spend a little time building real forms.
If you want to see these concepts in context, watch the embedded video. The related Access Beginner Level 1 lesson covers more about building and cleaning up a customer form.
Live long and prosper,
RR
No comments:
Post a Comment