Creating Forms
Access forms are much
like paper forms: you can use them to enter, edit, or display data. They are based on tables.
When using a form, you can choose the format, the arrangement, and which fields
you want to display. This lesson teaches you how to create forms.
Using the Form Button
Access can automatically create several types of forms. For example,
when you click the Form button on the Create tab, Access places all fields in
the selected table on a form. If the table has a one-to-many relationship with
one other table or query, Access
creates a stacked form (the records are displayed in a column) for the primary
table and a datasheet for the related table. If there are several tables with a
one-to-many relationship, Access does not create the datasheet.
To create a form:
1. Open the Navigation pane.
2. Click the table or query on which you want to base your form.
3. Activate
the Create tab.
4. Click
Form in the Forms group. Access creates a form.
You can use the Navigation bars to move through the records on a form.
|
1
|
Go to First Record
|
|
2
|
Go to Previous Record
|
|
3
|
The Current Record
|
|
4
|
Go to Next Record
|
|
5
|
Go to Last Record
|
|
6
|
Create a New (Blank) Record
|
To save a form:
1.
Click the Save button on the Quick Access toolbar. Access
saves the form unless you are saving for the first time. If you are saving for the first time, the Save As dialog box appears.
2. Type the name you want to give the form.
3. Click
OK. Access saves the form. You can now access the form by using the
Navigation pane.
You can also save by right-clicking a form’s tab and then selecting
Save from the menu that appears. Access saves the form unless you are saving
for the first time. If you are saving for the first time, the Save As dialog
box appears. Type the name you want to give the form and then click OK. Access
saves the form. You can now access the form by using the Navigation pane.
.jpg)
0 comments:
Post a Comment
Enter your comments to JoxTech