Lesson7.1.Creating a Form with AutoForm


Lesson 7.1. Creating a Form with AutoForm

Figure 7-1. Selecting an AutoForm from the New Form dialog box


Figure 7-2. A Columnar form created by the AutoForm Wizard


The fastest and easiest way to create a form in Access is with one of the AutoForm Wizards. The automatically creates a form by arranging all the fields from a table or query.

The AutoForm Wizards are fast and easy to use, but limitedthere are only five AutoForm Wizards, and each can create only one type of form, as shown in Table 7-1. Of course, you can always modify a form created by an AutoForm Wizard.

In this lesson you will learn how to create a form using an AutoForm Wizard.

  1. Open the Lesson 7 database.

    First you need to go to the Forms icon in the Objects bar.

  2. Click the Forms icon in the Objects bar, then click the New button.

    The New Form dialog box appears, as shown in Figure 7-1. You create a form with the AutoForm Wizard by selecting one of the five AutoForm Wizards...

  3. Select AutoForm: Columnar from the list.

    ... and the table or query you want to use in your form.

  4. Click the Choose the table or query where the object's data comes from: arrow and select qryCustomers from the list.

    That's all the information the AutoForm Wizard needs to create your form.

  5. Click OK to create the columnar form.

    Access takes all the fields in the qryCustomers query, arranges them, and creates a form similar to the one shown in Figure 7-2.

  6. Click the Close button to close the form. Click No to saving changes.

AutoForm Wizards forms aren't really very pretty to look at, but they can give you a good start at creating the form you really want since it's a lot easier to modify an existing form than it is to create one from scratch.

Table 7-1. Available Form Layouts

Form Type

Form Layout

Description

Columnar

Displays only one record at a time. Data for each record is displayed vertically. Technically, Columnar form's Default View property is set to Single.

Tabular

Displays several records at once. Data for the records is displayed horizontally. Technically, Tabular form's Default View property is set to Continuous.

Datasheet

Displays several records at once in Datasheet View. Technically, Datasheet form's Default View property is set to Datasheet.

PivotTable

Dynamically analyzes information and summarizes it into a datasheet-like table.

PivotChart

Dynamically analyzes information and summarizes it into a chart.


QUICK REFERENCE

TO CREATE A FORM WITH AUTOFORM:

  1. FROM THE DATABASE WINDOW, CLICK THE FORMS ICON IN THE OBJECTS BAR AND CLICK THE NEW BUTTON.

  2. SELECT ONE OF THE FOLLOWING:

    AUTOFORM: COLUMNAR
    AUTOFORM: TABULAR
    AUTOFORM: DATASHEET
    AUTOFORM: PIVOTTABLE
    AUTOFORM: PIVOTCHART

  3. CLICK THE TABLE OR QUERY YOU WANT TO USE FOR THE FORM FROM THE DROP-DOWN LIST.

  4. CLICK OK.




CustomGuide Inc - Access 2003 Personal Trainer
Access 2003 Personal Trainer (Personal Trainer (OReilly))
ISBN: 0596009372
EAN: 2147483647
Year: 2005
Pages: 209

Similar book on Amazon

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