Chapter 4 Simplifying Data Entry with Forms

Tip To create a form by using a wizard

  1. On the Objects bar, click Forms.

  2. Double-click Create form by using wizard to display the first page of the Form Wizard.

  3. Follow the instructions of the Form Wizard, and then click Finish.

Refining Form Properties To change the properties in a form

  1. Display the form in Design view.

  2. Use the buttons and boxes on the Formatting toolbar to change the formatting of labels and controls.

  3. To change the properties of a control, in the form, right-click the control you want to change, and click Properties from the shortcut menu.

  4. Click the appropriate tab, click the property you want to change, and then change the property setting.

Refining Form Properties To change the background color of a label

  1. Open the form in Design view.

  2. Right-click the label you want to change, and then click Properties from the shortcut menu.

  3. Click the Format tab, click the Back Color ... button, select the color you want, and then click OK.

Refining Form Layout To rearrange or move the controls in a form

  1. Display the form in Design view.

  2. To resize a control, select it, and drag the left, right, top or bottom edge of the control.

  3. To move a control, select it, and when the pointer changes to a hand, drag it to its new location.

Adding Controls to a Form To add a graphic and a caption to a form

  1. Display the form in Design view.

  2. Click the Image control in the Toolbox, and then drag a rectangle in the location where you will add the graphic.

  3. Navigate to the folder that contains the graphic, and double-click the graphic file.

  4. To add a caption, click the Label control in the Toolbox, and then drag another rectangle in the location where you will add the caption.

  5. Type the caption, and press .

Creating a Form by Using an AutoForm To create a form by using AutoForm

  1. On the Objects bar, click Forms.

  2. On the database window’s toolbar, click the New button.

  3. Click the AutoForm format that you want from the list, click the Table/Query down arrow, select the table or query on which you want to base the form, and then click OK.

  4. Click the Save button, enter a name for the form in the Save As dialog box, and then click OK.

Creating a Form by Using an AutoForm To add a subform to a form

  1. Make sure the tables on which you want to base your main form and the subform have a relationship.

  2. Open the main form in Design view and if necessary, open the Toolbox and make sure the Control Wizards button is active (is orange).

  3. On the Toolbox, click the Subform/Subreport button, and drag a rectangle to the location on your main form where you want to insert a subform.

  4. Follow the instructions on the Subform Wizard, and click Finish on the wizard’s last page to complete the process.

  5. Adjust the size and location of the objects on your form as necessary.

Creating a Form and Subform by Using a Wizard To create a form and subform by using a wizard

  1. To create the form in your database, on the Objects bar, click Forms, and then click the New button on the database window’s toolbar.

  2. Click Form Wizard, select the form’s base table from the list at the bottom of the page, and then click OK.

  3. Verify that the table you selected is shown in the Table/Queries list and then double-click each field that you want to include in the new form to move it to the Fields in my new table list.

  4. To create the subform, display the Tables/Queries list, and select the table on which you want to base the subform.

  5. Double-click each field you want to add to the subform, and then click Next.

  6. Follow the instructions on the wizard, and then click Finish to create the form and subform.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset