CREATING A FORM USING THE FORM WIZARD

1
CREATING A FORM USING THE FORM WIZARD

• In this lesson, you will learn how to use the
  Form wizard to create a form. Using the Wizard
  enables you to arrange fields in a different
  order, select only those fields that you want to
  use, and select a background and style of the
  form.

2

• Open MS Access, open SURNAME ACT 2, Click the
  forms object button. The forms window provides
  two ways of creating a new form. Select Create
  form by using wizard, and then click the New
  button.
• The New Form dialog box is displayed. Click Form
  Wizard and select Personnel File from the
  drop-down menu.
• Click Ok to activate the Form Wizard. The first
  Form Wizard dialog box enables you to select the
  fields that you want to display in the form.
  Highlight the Last Name field in the Available
  Fields box, then click the Add Field button to
  move it to the Selected Fields box.

3
NEW BUTTON
FORMS OBJECT BUTTON
4
(No Transcript)
5
ADD FIELD BUTTON
ADD ALL FIELDS BUTTON
REMOVE FIELD BUTTON
REMOVE ALL FIELDS BUTTON
6

• Click the Add all Fields button to place the rest
  of the fields in the Selected Fields box. Click
  the Next button.
• The second Form Wizard dialog box prompts you to
  structure the form. Choose Columnar, if
  necessary for the layout of the form. This will
  display the record in a single column as shown in
  the next slide. Click the Next button.
• The third Form Wizard dialog box prompts you to
  select a background style. Choose standard. A
  preview is shown on the left side of the dialog
  box. Click the Next button.

7
(No Transcript)
8
(No Transcript)
9

• The last Form Wizard dialog box prompts you to
  name the form. Type Personnel File Input Form.
  Make sure that the Open the form to view or enter
  information option is selected. Click the Finish
  button.
• Access generates the columnar form with the
  fields and background youve selected.

10
(No Transcript)
11
(No Transcript)
12
ARRANGING TEXT AND LABEL FIELDS AND ADDING
LABEL IN A FORM

• In this lesson, you will learn to move around in
  a form and change the layout of the text and
  label boxes to match the layout of a paper form.
  With this, you can design an Access form to look
  exactly like a printed form.

13

• With the columnar form displayed click the View
  button to go to the Design view. The form design
  window is displayed with the toolbox. The field
  list box may also be displayed.
• Click close button of the field list box since
  youre not going to use it. Click and drag the
  First Name field to the right of the current
  location as shown in the next slides.
• Release the mouse button. The first Name field
  is now on the right half of the screen. The work
  area automatically increases to accept the new
  field location. The sizing handles around the
  textbox indicate that this field is still
  selected.

14
FIELD LIST BOX
TOOL BOX
15
(No Transcript)
16

• 4. Drag the other fields to match the
  illustration in the next slide.
• Click the Label button on the Toolbox toolbar.
  When you move the pointer to the Detail area, it
  changes to a crosshair with a letter A attached.
  Drag it to draw a box for the label as shown in
  the figure.
• Type De La Salle University Dasmariñas in the
  box and press Enter. Click the Bold button and
  then the Center button on the formatting toolbar.
  In the font box, change the font to Garamond and
  in the font size box, change the font size to 12.
  
• Click View button to return to Form view.
  Notice that effect of what youve done and
  continue with the next lesson.

17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
Exercise 2

• 1. Using the database file youve created in
  Exercise no. 1, create a form using the Form
  Wizard.
• Type the following as the heading of your form
• De La Salle University Dasmariñas
• Student Profile
• 3. Make an additional 5 records.
• 4. Save all the changes youve made when
  prompted.