Chapter 10: Simplifying Data Entry with Forms


Page 208

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 .

208

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 formattingof labels and controls.

  3. To change the properties of a control, in the form, right-click the control you wantto 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.

219

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 anotherrectangle in the location where you will add the caption.

  5. Type the caption, and press [ENTER].

228

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, andthen click OK .

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

230

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.

238

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 Fieldsin my new table list.

  4. To create the subform, display the Tables/Queries list, and select the tableon 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 formand subform.




Microsoft Office 2003 Step by Step
MicrosoftВ® Office ExcelВ® 2003 Step by Step (Step By Step (Microsoft))
ISBN: 0735615187
EAN: 2147483647
Year: 2005
Pages: 350
Authors: Curtis Frye

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net