Creating a Form with AutoForm
To Create a Form with AutoForm: From the Database window, click the Forms icon in the Objects bar and click the New button. Select the type of form you want to create: Columnar, Tabular, Datasheet, PivotTable, or PivotChart. Click the table or query you want to use for the form from the drop-down list and Click OK.
Modifying a Form
To Modify a Form: From the Database window, click the Forms icon in the Objects bar, click the form you want to modify and click Design, or open the form and click the View button on the toolbar.
Adding and Deleting Fields
To Add a Field to a Form: Display the form in Design View and click the Field List button on the toolbar if necessary, find the field you want to add to the form in the Field List, then click and drag the field to the desired location on the form.
To Delete a Field or Control: Click the field or control to select it and then press Delete.
Moving and Sizing Controls
To Resize a Control: Click the control to select it, grab one of its sizing handles, drag and then release the mouse button when the control reaches the desired size. Hold down the Shift key while dragging to maintain the control's proportions while resizing it.
To Move a Control: Click the control and hold down the mouse button, drag the control to a new location and then release the mouse button to drop the control.
To Move a Text Box or Text Label Independently of Each Other: Position the pointer over the upper left sizing handle of the control until it changes to the hand icon, then click and drag the control.
Changing the Tab Order
To Change a Form's Tab Order: Display the form in Design View and select View To Automatically Change the Tab Order: Display the form in Design View and select View Auto Order button to automatically reorder the form controls, based on their position in the form.
Working with Control Properties
To Display the Properties for Any Control: Display the form in Design View and do any of the following:
Select the control and click the Properties button on the toolbar.
Right-click the control and select Properties from the shortcut menu.
Select the control and select View Working with Form Properties
To View and Change Form Properties: Display the form in Design View and double-click the Form Selector. Click the appropriate property tab and property box and make the desired changes.
Working with Multiple Controls
To Select Multiple Controls: Do any of following:
Press and hold down the Shift key as you click each control that you want to select.
Use the arrow pointer to draw a box around the control that you want to select.
If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls.
Adding, Cutting, Copying, and Pasting Controls
To Add a Control: Click the Toolbox button on the toolbar if necessary, click the button on the Toolbox for the type of control you want to add, in the Form window, click and drag the pointer where you want the control to appear.
To Cut a Control: Select the control and:
Forms created with the AutoForm Wizard usually come out looking sharp and professional and don't require any further clean-up work.
The AutoForm Wizard can only create forms based on a single table or query.
Which of the following statements is NOT true?
The Field List displays all the fields from a form's underlying table or query.
Click the Field List button on the Toolbar to display the Field List.
You can add fields to a form by dragging them from the Field List onto the form.
The Field List displays all the fields from every table in a database.
Controls and their corresponding text labels cannot be moved independently of one another. (True or False?)
If you move a control on a form, the Tab Order, in which you advance from one field to the next when you press the Tab key, is automatically updated. (True or False?)
A form that has a Datasheet Default View property would display one record at a time in the form. (True or False?)
A calculated field... (Select all that apply.)
...is a bound control.
...is a control that contains an expression.
...can perform calculations on fields values, such as =[Cost]*[Commission].
...can perform calculations on explicit values, such as =2+4.
Which of the following set(s) of tables would benefit from a subform? (Select all that apply.)
A Customer table and the Customer Orders table.
A Customer table and Products table.
A Customer table and Foreign Currency table.
A Customer table and a Customer Contacts table.
When you add a subform to a main form, Access always recognizes how the two forms are related (True or False?)
Open the Homework database.
Use AutoForm to create and save a columnar form named "Customers," using the Customers table as the underlying data source.
Add a text box control with today's date in the bottom-right corner of the Customers form.Hint: You will need to change the text box control's data source to the expression =Today( ).
Rearrange the control fields on the form, so that the LastName and FirstName fields appear before the SSN field.
Change the Customer form's tab order to reflect the new field order.
Delete the DOB field control from the form.
Resize the Customers form as necessary, then use the SubForm Wizard to create a subform based on the Insurance Claims table.
Modify the Insurance Claims subform so that its Default View property is Single Form View.
Save your changes to the main form and the subform. Then close the form and the Homework database.
C. The AutoForm Wizard can create in record time, but they aren't usually well-organized or professional looking.
D. The Field List only displays fields from a form's underlying table or query.
False. You can click and drag the upper left sizing handle to move a label or control independently of one another.
False. If you add or move a control on a form, you would have to change the form's tab order yourselfMicrosoft Access won't do it for you.
False. A form whose Default View property was set to Datasheet would display multiple records. A form whose Default View property was set to Single Form would display one record on the form at a time.
B, C, and D. All of these statements are true.
A and D. Because subforms are great at displaying information from one-to-many relationships, both of these tables would benefit from being displayed in a subform.
False. If you include the field that links the two tables, Access will automatically recognize it, if you have already joined the two tables. If the tables aren't related, you may have to manually join the tables by connecting their related fields.