آموزش کامل Access 2000 -EN

[A M I R]

[h=2]Adding Form Records

[h=3]Introduction
[h=4]By the end of this lesson, learners should be able to:

• Open a form in an existing database

• Navigate a form in an existing database

• Add form records

​

 

[A M I R]

[h=2]Adding Form Records

[h=3]Opening a Form
If you have taken Access 2000 lessons 1-5, you already are acquainted with basic tables.


However, forms, another type of database object, provide a way for Access

users to enter data into a database without having to know how a table is designed.

​

 

[A M I R]

[h=2]Adding Form Records

[h=5]To Open an Existing Form:
Open the Great Lake Elementary database.

In the database window, choose the Forms tab from the Object palette.

To open a form, double-click it, select it and click the Open button,

or

right-click it and choose Open from the shortcut menu.

​

 

[A M I R]

[h=2]Adding Form Records

[h=3]Navigating a Form
Navigating, or moving through records in a form, lets you review, add, or edit information.

Like Datasheet View, the Form View window contains a status

area (shown below) in the lower left corner. Use the arrows to navigate through the forms.

​

 

[A M I R]

[h=2]Adding Form Records

Use the keyboard to navigate the fields in a form.

Key	Selects the
Tab	Next field to the right
Shift + Tab	Next field to the left
Down Arrow	Field below the current record
Up Arrow	Field above the current record

​

 

[A M I R]

[h=2]Adding Form Records

[h=3]Adding Records in a Form
The data entry form is the easiest way to enter records.

​

 

[A M I R]

[h=2]Adding Form Records

[h=5]To Add a Record:
Click on the New Record button.

A blank entry form, consisting of several blank fields, displays.

Type in the appropriate field information. For example, if the field label reads, First

Name, type the first name of the individual you are entering into the database.


Press Enter or Tab to move from one field to the next, or click in the field using your mouse.

Fill in the rest of the appropriate information.

​

 

[A M I R]

[h=2]Adding Form Records

[h=3]Challenge!

Add a form record.



Open the Great Lake Elementary database.

In the database window, choose the Forms tab from the Object palette.

Double-click the New Student form to open it.

Practice navigating the form.
Click the New Record button to display a blank entry.




Enter the following data for new student Amanda Lewis.

• Student Name: Amanda Lewis
• Student ID: 999887777
• Grade: 4
• Teacher ID: 4
• Parent Name: Thurman Lewis
• 456 Tutor Drive
• Anytown
• Phone: Do not attempt to pre-format the number. Enter 1012339571.

Use Enter or Tab to move from one field to the next.

Close the form.

Double-click on the New Student form to re-open it.
Check to see if Access 2000 saved your addition. Remember, Access saves records automatically.

Close the New Student form.


​

 

[A M I R]

[h=2]Editing Form Records

[h=3]Introduction

[h=4]By the end of this lesson, learners should be able to:

Edit form records


​

 

[A M I R]

Editing Form Records

Editing Form Records


In the previous lesson, you learned to open an existing form, navigate a form, and add a form record.

​

Editing a form record is very easy. If you can locate a record and type a correction, you can edit a form record.
​

 

[A M I R]

[h=2]Editing Form Records

[h=5]To Edit a Form Record:


Using the status area to navigate the forms, display the form record you want to edit.

The record displays on the screen.

​

 

[A M I R]

[h=2]Editing Form Records

[h=3]Editing Form Records - Continued

[h=5]To Edit a Form Record:

Select a word in the field to be modified. The existing data is selected and a blinking insertion point appears.

Type a correction.

The corrected data will be saved with the record.




​

 

[A M I R]

[h=2]Editing Form Records

[h=3]Challenge!

Edit a form record.





Open the Great Lake Elementary database.

In the database window, choose the Forms tab from the Object palette.

Double-click the New Student form to open it.


Using the status area to navigate the forms, display any record. You may wish

to edit the record you created about Amanda Lewis (in Challenge lesson 6).


Click in any field you wish to modify. The existing data is selected and a blinking insertion point appears.

Type a correction.

The corrected data will be saved with the record.

Close the New Student form.
​

 

[A M I R]

[h=2]Deleting Form Records

[h=3]Introduction
[h=4]By the end of this lesson, learners should be able to:

• Delete form records

​

 

[A M I R]

[h=2]Deleting Form Records

[h=3]Deleting Form Records
In the previous lesson, you learned to edit form records.

If you need to delete a form record from your database, the entire record will be deleted.

​

 

[A M I R]

[h=2]Deleting Form Records

[h=5]To Delete a Form Record:

Using the status area to navigate the forms, display the form record you want to delete.

The record displays on the screen.
Click the Delete button.

A delete confirmation message appears.

Click Yes if you are sure you would like to delete the record. The record is deleted.



​

 

[A M I R]

[h=2]Deleting Form Records

[h=3]The Delete Confirmation Message
The confirmation message varies. For example, if any of the information in this record is

linked to other tables in the database, deleting this record will also affect data in those tables.

Be careful, deleting a record cannot be undone.




​

 

[A M I R]

[h=2]Deleting Form Records

[h=3]Challenge!
Practice deleting a form record.


Open the Great Lake Elementary database.

In the database window, choose the Forms tab from the Object palette.

Double-click the New Student form to open it.







Using the status area to navigate the forms, display the record you wish to delete.
Click the Delete button.

A confirmation message appears.

Click Yes. The record is deleted.

Close the New Student form.
​

 

[A M I R]

[h=2]Sorting Records

[h=3]Introduction

[h=4]By the end of this lesson, learners should be able to:

• Review table records and form records concepts

• Perform a simple sort

• Save a sort

​

 

[A M I R]

[h=2]Sorting Records

[h=3]Review: Table and Form Concepts

In the preceding Access 2000 lessons, you learned to open an existing table and add, edit

and delete table records. You also learned to open an existing form and add, edit and delete form records.


Remember, tables are the building blocks of any database. Forms are simply a way

of customizing the display of data in a table, making it easy to enter and view data.




Different methods of accessing data require that you work in different views. When

working with tables, you work in Datasheet View. When working with forms, you work in Form View.

In this lesson, you will learn to sort and find records.

Using a database, finding information is quick and easy. Depending on what you

want to know, Access offers several search methods ranging from the simple to the complex.
​