Access07:Heights:Forms

Previously data was entered directly into the table. To produce a clear data entry screen where headings can be used, and user instructions added we use a form. Forms can be created in a variety of ways. The most common places a single record on the screen. The Access form wizard can create four different types of form; For this introduction we will produce a Columnar form.
 * Columnar
 * Tabular
 * Datasheet, and
 * Justified.

Creating a form
Access will create a form automatically.

1. Click on tblPeople in the left hand pane

2. Click on the Create tab and, choose Form



A very yucky form is produced!!!



Note: It is probably better to use the form wizard when creating a form (Use the Create tab then Select More Forms )

Navigating through a form
You can move through the records using the navigation controls at the base of the form and can change the data in the form

On the bottom of your form you will see the navigation buttons.




 * To view the data click on the First, Previous , Next record and Last record buttons. To go directly to a record type in the record number into the central box.


 * To edit (change) any data, first locate the record then click on the appropriate field and make the changes.


 * To add new data use the Blank (new) record button.

Task

1. Scroll forwards and backwards through the records.

2. Jump to the first and last records

3. Add four more records (add your name plus use your own or the ones below)

Changing the design
You can change the form design by selecting the Home tab, and changing the Views to Design view.

Tip: Access has by default locked all the controls on the form - which is really not that useful. So after you get into design view (all the fields should be highlighted - if not press [Ctrl]+[A]) Then Use the Arrange tab and click on the button Remove in the Control Layout. Now you can play with the controls as much as you want!!



Save the form
Finally save the form as frmPeople by clicking on the Disk save icon on the quicklinks bar at the top of the screen.