Go to the FGCU Homepage navigation bar
    
Technology Skills Orientation
Access Titlebar
A-Z FGCU Index FGCU Calendar of Events Campus Tour Library Search FGCU Web FGCU Webmail Contact FGCU
« Calculated Fields Designing Forms Generating Reports »

Forms allow you to control the look and feel of the screen for the input of data and the reports generated. 

Form Views
There are three ways to view forms in Access:


Design View

Allows you to design a form that includes a header, a footer, and details in the form.  You can also add images and control which fields appear on the form.

Form View

This is a dynamic page which allows the user to enter and edit data or navigate through data in a field. 

Layout View

This view allows you to design the form and manipulate data.

 

Create a Form
You can create a form from a table or a query.  To create a form:

  • Click the Create tab
  • Click the Form Design button

Form Design Button

  • Click the Format tab
  • Click the Add Existing Fields Button
  • In the Field List box on the right, click and drag the fields you would like on the form

Add Existing Fields Button and Dialog Box

  • To change the colors and fonts, click the Property Sheet button on the Arrange tab

Property Sheet Button

Insert pic of property sheet button

  • Choose the Section you wish to modify
  • Choose the properties you wish to modify

Property Sheet Drop Down Menus

To preview the form:

  • Click the Views button on the Home tab
  • Click the Form View button

Form View Button

Form Wizard
You can create forms with the help of the Form Wizard.  To use the form wizard:

  • On the create tab, click the More Forms down arrow
  • Click Form Wizard

More Forms Drop down Menu

  • Choose the Tables/Queries that you wish to have on the form
  • Choose the fields you wish to have on the forms
  • Click Next

Form Wizard Screen 1

  • Chose the layout for the form
  • Click Next

Form Wizard Screen 2

  • Choose a style
  • Click Next

Form Wizard Screen 3

  • Create a title for the form
  • Choose whether you want to open the form to view it or modify the form’s design
  • Click Finish

Form Wizard Screen 4

« Calculated Fields Designing Forms Generating Reports »


Office 2007 Tutorials · Word · Excel · PowerPoint · Access

FGCU does not provide personal support for Office 2007 programs to outside parties.


© FGCU 2007. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory