SECTION 3
Lesson 3.1: Creating Forms

   

 

You will create a new form using the Wizard, then modify it using Design mode.

1.                   

Open Lesson 3.1 from the Section 3 folder of your Exercise Files.

 

 

 

2.                   

Click the Forms object and then double-click Create form by using Wizard.

 

 

3.                   

Select the Expense Categories table from the combo box, and then click the double right-facing arrow (>>) to transfer all fields from the Available Fields list to the Selected Fields list.

 

 

Click Next.

 

 

4.                   

Make sure the Columnar layout radio button is selected and click Next.

Pick a style of your choice from the list and click Next.

 

 

5.                   

Name the form Custom Expense Categories Form and click the Modify the form’s design radio button.

Click Finish.

 

 

6.                   

You should see a form similar to the following:

 

 

Move your mouse between the Form Header and Detail bars so your pointer looks like this:. Click and drag down about ½ an inch, using the ruler on the left side of Design view as a guide.

 

Move your mouse above the Form Footer Bar so the pointer looks like the same double-headed arrow. Click and drag down about a full inch.

 

Your screen should look similar to the following:

 

 

 

7.                   

Click the Label tool from the toolbox and click and drag a large box under the Form Header bar.

 

Type Expense Categories into the new label. Click somewhere in the dark grey area of Design view to deselect the tool, and then click on the label you just made.

 

Using the Formatting toolbar, increase the font size to 14, click the Underline tool, and center the text in the label.

 

Your form should now look like this:

 

 

 

8.                   

Click the Option Group button in the toolbox and draw a large rectangle under the Expense Account # label and field.

 

The Option Group Wizard will appear. Under the heading Label Names: type USD.

 

Press Tab on your keyboard, and then type EURO.

 

 

Click Next.

 

 

9.                   

Leave USD as the default choice and click Next.

 

 

 

10.               

At the next screen, leave the values of each option as they are and click Next.

At the next screen, make sure that the Save the value for later use radio button is selected and click Next.

 

 

11.               

When the Wizard prompts you for the type of controls you want in your form, pick a style you like and click Next.

The final step is to give the Option Group a name; type Currency.

Click Finish.

 

You should have something similar to the following:

 

 

 

12.               

Click View à Form View to preview your form:

 

 

 

 

13.               

Save the changes to the form, and close Microsoft Access 2003.