Access XP

Introduction

By the end of this lesson, learners should be able to:

• Locate an existing form record
• Edit a form record

Using the Status Area to Navigate through Records in a Form:

Contact records need to be updated whenever information changes. Changes occur when people move from one address to another, switch companies, or change phone numbers. In the Contact Management database, you can change this information using the Contacts form.

Navigating through records in a form works very much like navigating through records in Datasheet View. The Form View window contains a status area in the lower left corner. Use the arrows to navigate through the forms.

• Click the arrows in the status area to move to the first record, previous record, next record, or last record in the table.
• The new record button displays a blank form into which information for a new record can be added to the table.

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

Editing Form Records

Information will undoubtedly change in your database. Contacts move to a different address, change their telephone numbers, or switch companies. You can either change the information for any of these records, or, if no longer needed, even delete the record from the database.

Editing a form record in Access is very easy. It entails locating the record and then typing the corrected information in the appropriate field.

To Edit a Form Record:

• Using the status area to navigate the forms, display the form record that is to be edited.
  
  
• Either click in a field or use the keyboard to navigate to the first field to be changed or added.
  
  
• Type the new information or correct the information in the selected field.
• Navigate to the next field that needs to be corrected and make any necessary changes.
• When finished editing information on this page, click the Page 2 button to display additional fields.
  
  

In the previous lesson, we saw how to enter new Contact Types on the Contact Types form. These entries are now available for use in the Contact Type field of the Contacts form.

• Click on the drop-down button associated with Contact Type. If you successfully completed the challenge in the last lesson, this drop-down list now contains several entries: Family, Friend, Relative, Work, Recruiter, Company, and Network.

Saving Your Work: After you input the data into a form record, Access automatically saves the record when you use the mouse, an arrow key, the Tab key, or the Enter key to move the cursor out of that field and into a different field, or record.

Remember, you can always add records to the Contact Types table while in Datasheet View. First, click on the Tables tab from the Object palette of the database window. Then double-click the Contact Types table to open the table in Datasheet View.

Challenge!

Display the Contacts form and use the Status area to display each record shown. Change the Contact Type of each contact record to that indicated below:

• Assign a "Company" Contact Type for the Bob Binford record
• Assign a "Friend" Contact Type for the Mike Allen record
• Assign a "Relative" Contact Type for the Jim Wilson record
• Assign a "Relative" Contact Type for the Martha Wilson record
• Assign a "Friend" Contact Type for the Greg George record

Review the information contained in all records and add make-believe Mobile Phone numbers and Email Name for any record(s) missing this information.

Display the Bob Binford record.

• Click the Calls button on the Contacts form to open the Calls table.
• In the Subject field, type: "Interview"
• In the Call Notes field, type: "Telephone interview went well. Face-to-face interview scheduled for Friday of next week."

Display the Mike Allen record.

• Click the Calls button on the Contacts form to open the Calls table.
• In the Subject field, type: "Recruiter for Engineering Position"
• In the Call Notes field, type: "Allen called in response to resume sent on 12-17. Allen will arrange an interview with Lisa McDougal of e76 Engineering."