ECommerce Technology

 Site Map :: Contact Us

ECommerce >> Database Manipulation


Creating a Form

 In MS Access two methods exist for creating a form. Using the form wizard or using the form design view.

 Using the wizard is an easy way to create attractive but simple forms. Often a good idea is to create a form using the wizard and then make adjustments in the form design view.

 To create a form using the wizard, click first on Forms on the left hand side under Objects. Then double click on "Create form by using wizard".

 Step 1

 Select the fields you want to show on the form, by clicking on the field name and then clicking on the arrow to move the field into the selected fields box. Then click on Next.

 Step 2

 Select the required layout from a choice of 4 layouts and then click on Next. The normal is Columnar.

 

The tabular layout is similar to the columnar layout, except that more than one record is shown onscreen at a time.

 

The datasheet layout basically just gives you a fancy looking datasheet.

 

The justified layout is like the columnar layout, except that it forces the text boxes and objects in the form to fill the entire form and not leave any gaps. 

Step 3

 Select the style that you like best, this is purely cosmetic. Then click on Next.  

Step 4

Give the form a name and then click on Finish. If you wish to open the form for immediate editing from the design view, select this option first.

©2005 eCommerce Technology. All rights reserved