Download Microsoft Access 2003 Forms Design: Editing Data and Creating Forms and more Study Guides, Projects, Research Microsoft Access Skills in PDF only on Docsity!
Unit 11. Forms (II).
Editing data in a form
To edit the data of a table using a form , we need to open the form by positioning ourselves in the Database window with the Forms object selected and click on the button, or simply double click on the name of the form in the Database window. The source data of the form will appear with the appearance defined in the form ( Form view ). We can then search for data using the navigation buttons we know , replace values, and modify it as if we were in the Datasheet view of a table, the only thing that changes is the appearance of the screen.
To practice you can perform the Step by step Creating forms.
The form design view
The form design view is that which allows us to define a form, here we need to indicate to Access how to present the source data in the form, and here we can use the controls we will see ahead. To enter into the design view we need to position ourselves in the Database window with Forms selected , and then click on the button. The Form design window will appear:
The area consists of three sections : The Form Header , here we put what we wish to appear at the beginning of the form.
http://www.teacherclick.com/access2003/t_11_2.htm (1 of 4)11/10/2010 12:54:59 PM
Access Tutorial
teacherClick tutorials
Tutorials selection
docsity.com
The Detail section, here the source records of the form appear, either various records or one per screen, depending on the type of form. Even though various records are visualized on one screen, we need to indicate the design corresponding to just one record in the Detail section. The Footer section, here we need to put what we want to appear at the end of the form. Using the View menu, and then the option Form header/Footer option we can close or open the header and footer. The mark to the left of the option indicates to us whether the sections are open or closed, if we remove the sections we lose all the controls associated with them. To open them we just need to select the option again.
Around the design area we have various rulers that permit us to measure the distances and the controls, we also have available to us a grid that helps us to place the controls within the design area. To hide or see the ruler or the grid we have the Ruler and Grid options in the View menu, as we can see in the example above.
The form design bar
Finally we can access the Access help by clicking on the button.
If you want to continue with this unit go to the next page...
Page.
Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.
