Access XP: Adding Form Records

Lesson 10: Adding Form Records

/en/accessxp/editing-and-deleting-table-records/content/

Introduction

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

  • Open a form using the Forms Object button
  • Navigate the Switchboard menu
  • Navigate the records in a form
  • Add new records to the Contacts table
  • Add new records to the Calls table
  • Add new records to the Contact Types table

Opening forms in the contact management database

Forms can be opened several ways in the contact management database. When the contact management database is first opened, a main switchboard of menu items is automatically displayed. A form can also be displayed by opening it from the Forms object.

If a table has been defined to a database, it does not matter whether records are inputted into the table using Datasheet view or through the data entry form discussed in this lesson. Both methods update the same table.

To open a form from the forms object:

  • Open the contact management database.
  • In the database window, click the Forms tab from the Objects palette.

    Forms Selection on Objects Palette
  • In the right white pane, double-click the Contacts form.

    OR
  • Click once on the Contacts form and click Open.

    OR

  • Right-click the Contacts form and select Open from the shortcut menu.

    Contacts Form Selection

Using the contact management main switchboard

The contact management database has been created so you may never need to access a table in Datasheet view. Forms have been created and linked together in a menu structure to allow you to navigate quickly and easily to different forms. These forms collectively retrieve information from or are used to input and update records in any given table in the contact management database.

To open a form using the main switchboard form:

The main switchboard form automatically loads each time the contact management database is opened. You can manage all contact information in the database by using any of the forms linked to the switchboard.

The Main Switchboard form lists five options:

  • Enter/View Contacts is selected to enter contact information or the specifics about any given phone call in the database.
  • Enter/View Other Information is an administrative function that allows you to define contact types, such as family, friends, and relatives.
  • Preview Reports provides access to different reports.
  • Change Switchboard Items (will not be discussed in this tutorial).
  • Exit this database is selected to exit the contact management database.

Main Switchboard Form

To display any of the contact management subforms:

  • Click the option you want to access. For example, click the Enter/View Contacts menu selection to add new records to the contact management database.

Adding records using the enter and view Contacts form

The Contacts form is used to add or change information in the Contacts table. The only time the Contacts form is blank is when the new table to which it is associated does not yet have any records added to it. Otherwise, information reflecting the first record in the table is presented when the form is displayed. When adding new records, you are required to input information in the required fields of a blank data entry form.

Contacts Form

To add a contact record:

  • Click the New Record button to display a blank data entry form. A blank entry form is displayed.
  • Type the requested information into each field on the form. If the field label reads First Name, type the first name of the individual being entered into the database.
  • Press Enter or Tab to move from one field to the next, or click in the field using your mouse.
  • Complete entries in the remaining form fields: Last Name, Company (if applicable), Address, City, State/Province, Postal Code, Country, Title, Work Phone, Work Extension, Mobile Phone, and Fax Number fields.
  • When you're finished entering information on this page, click the Page 2 button to display additional fields.
  • On this page, complete entries in the Contact Type, Email Name, Referred By, and Notes fields.

    Page 2 of the Contacts Form

Saving your work: Unlike Word, Excel, and PowerPoint, you will not be prompted to save the data you entered when you exit the screen or close application. In Access, each record is saved automatically when you move to another record or exit the form.

Adding records using the Calls form

The Calls form is used to add details about specific phone calls to the the Calls table. It is accessed by using the Calls button on the Contacts form. If you're looking for a job and several calls are made to a company, you can use the Calls table to record a history of notes about each phone call.

Calls Button on the Contacts Form

To add a call record:

  • Click the Calls button located at the bottom of the Contact form. The Calls form is displayed for data entry.

    Calls Form
  • Type the requested information into each field on the form. In the Call Date field, type the date of the phone call.
  • Press Enter or Tab to move from one field to the next, or click in the field using your mouse.
  • In the Call Time field, type the time of the phone call.
  • In the Subject field, type a description that briefly describes the nature of the phone call.
  • In the Call Notes field, type specific notes or action items discussed during the phone call.

Saving your work: Unlike Word, Excel, and PowerPoint, you will not be prompted to save the data you entered when you exit the screen or close application. In Access, each record is saved automatically when you move to another record or exit the form.

Adding records using the enter and view Contact Types form

On the second page of the Contacts form, a field appears called Contact Type. This field is a drop-down menu list that contains only one entry—Family—when the contact management database is downloaded from GCFLearnFree.org. This field tells the database that the record entered is a family member.

Contact Type Field on the Contacts Form

We previously talked about how you could separate your contacts into different categories, such as family, friends, relatives, companies, and recruiters. The Contact Types form, which provides input to the Contact Types table, accepts these definitions.

This form illustrates how different tables interact with each other in the database. When you enter a new record in the Contact Types table, it will appear in the Contact Types field when a record is added or changed using the Contacts form.

To display the Contact Types Form:

  • Click once on the Enter/View Other Information menu selection on the Main Switchboard.

    Switchboard Form
  • Click once on the Enter/View Contact Types on the switchboard subform to display the Contact Types form.

    Switchboard Form

Adding records using the enter and view Contact Types form

To add a new contact type:

  • Click the New Record button to display a blank data entry form. Do not type anything in the Contact Type ID field because it is the primary key.

    Contact Types Dialog Box
  • Type the entry Friends in the Contact Type field.

Saving your work: Unlike Word, Excel, and PowerPoint, you will not be prompted to save the data you entered when you exit the screen or close application. In Access, each record is saved automatically when you move to another record or exit the form.

You can always add records to the Contact Types table while in Datasheet view. Click the Tables tab from the Objects palette of the database window, then double-click the Contact Types table to open the table in Datasheet view.

Challenge!

  • Use the switchboard to navigate to the Contacts form and input the following new records:
    • Jim Wilson, 45 Smith Street, Cary, North Carolina, 27560, United States, 919.465.3201 (Work Phone)
    • Martha Wilson, 45 Smith Street, Cary, North Carolina, 27560, United States, 919.465.3820 (Work Phone)
    • Greg George, 45 Williams Street, Apex, North Carolina, 26541, United States, 919.540.6201 (Work Phone)
  • Use the switchboard to navigate to the Contact Types form and input the following new contact type records:
    • Friend
    • Relative
    • Work
    • Recruiter
    • Company
    • Network

/en/accessxp/editing-form-records/content/