Access Forms 2003

Overview

Forms are used primarily as screens to enter data into underlying tables. They are sometimes used as windows to provide access to other forms.

Form Wizards § Open the database address.mdb. § Click on the Forms tab and then click on New. § You will see the choices: o Design View - creates a form from scratch o Form Wizard - creates a form with prompting for formatting options o AutoForm: Columnar - creates a form with one record per page vertically down page o AutoForm: Tabular - creates a form with each records going horizontally across page and multiple records going down the page. o AutoForm: Datasheet -creates a form that looks like a datasheet o Autoform: Pivot Table - creates a pivot table o Autoform: Pivot Chart - creates a pivot chart o Chart Wizard - creates a chart based on underlying data o PivotTable Wizard – Creates a pivotal table
§ Select Form Wizard. § At the bottom of the window, click the drop down arrow and select the table or query to use to create the form. Select Address Query § Click OK § Click the >> icon to move all the fields to the form § Click Next § Select the format you want
§ Click the >> icon to move all the fields to the form OR § Click the > icon to move individual fields to the form § Click Next
§ Select the format you want Ø Columnar - displays all the fields of a single record vertically. Often used for data entry. Ø Tabular – shows fields of multiple records horizontally across the screen. Sometimes not all the fields for a single record will fit on the screen Ø Datasheet – looks exactly like a table Ø Justified - displays all the fields of a single records aligned. Often used for data entry. Ø PivotTable – creates a pivot table Ø PivotChart – creates a pivot chart
§ Select Justified as the layout § Click Next § Select a style you like and click Next § Add the title Address Form. § Click Finish
Modifying forms § Open Address Form in Design.
§ You can resize the Fields or the Labels so that all information will display by clicking on the box and then clicking and dragging the squares
§ If you click on the background and then the Fill / Back Color icon, you can change the background color
§ If you click on the labels/fields and then Font / Fore Color icon, you can change the color of the font.
§ You can change the font style or size. If you increase the size of a font, you may have to enlarge the boxes so all the data shows

It is a good idea to save often and make a copy of a complex form before making changes. If you don’t like your form, it is often easier to delete it and start over than to modify it.

RLS

10/06/2005