Microsoft Access 2003 free tutorial. Unit 11Forms in Access2003
Unit 11. Forms (I)
Forms generally serve to define screens with which to edit the records of a table or query.
In this unit we will see how to create a form, and how to operate it for the editing of records and changing its design.
Introduction.
To create a form we need to position ourselves in the database window with the Form object selected, if we then click on
the button a window opens with the various ways we have to create a form:
Design view opens a blank form in design view, and we then need to incorporate the various object that we would like to
appear in it. This method is not used much as it is easier and faster to create an autoform, or to use the wizard and
afterward modify the design of the created form to adjust it to our needs. We will see ahead in this unit how to modify the
form design.
Form wizard uses an a wizard that guides us step by step in the creation of the form.
Autoform consists of automatically creating a new form that contains all the data from the source table.
According to the type of form that we select (columnar, tabular,...) the form will present the data in a distinct way, when we
click on one of the options, a sample will appear on the left side with the way in which the data will be presented with this
option. E.g Autoform: columnar presents one record on a screen, meanwhile Autoform: tabular presents all the records
on one screen and every record in a row.
In order to use this function we first need to fill out the Choose the table or query where the object's data comes from:
with the name of the source. This will be the only data to introduce, and once introduced we select the kind of autoform and
click on OK button, and Access does the rest.
Chart Wizard uses a wizard that guides us step by step in the creation of a graphic.
Pivot table wizard uses a wizard that guides us step by step in the creation of dynamic table.
We will next explain how to create a form using the wizard.
http://www.teacherclick.com/access2003/t_11_1.htm (1 of 5)11/10/2010 12:54:40 PM
Access2003
Tutorial teacherClick
tutorials Tutorials
selection
Flash 8
Dreamweaver 8
Excel 2003
Windows XP
Access 2003
Dreamweaver MX 2004
Flash MX 2004
docsity.com
