• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Working with Jet Databases an... > Preparing to Add a Table Related to ...

Preparing to Add a Table Related to the Employees Table

Northwind.mdb includes the Employees table that provides information typical of personnel tables maintained by human resources departments. The following sections explain how to add a new table to the Northwind database that is related to the Employees table and called HRActions. The HRActions table is a record of hire date, salary, commission rate, bonuses, performance reviews, and other compensation-related events for employees. Because HRActions is based on information in the Employees table, the first step is to review the Employees table's structure. In Chapter 6, you add validation rules to the HRActions table and enter records in the table.

With the Database window active, you can open the Design view of an existing table in the following ways:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint