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

Chapter 6. Entering, Editing, and Valida... > Adding Records to the HRActions Tabl...

Adding Records to the HRActions Table

Now you can test your work in creating the HRActions table and check whether Access is enforcing domain integrity. Table 6.7 shows the initial entries for each employee of Northwind Traders. No Rating entries appear in Table 6.7 because ratings don't apply to newly hired employees.

Table 6.7. First Nine Entries for the HRActions Table
Employee ID Action Type Initiated By Scheduled Date Approved By Effective Date New Salary HRComment
1 H 1 05/01/1992 1 05/01/1992 2,000 Hired
2 H 1 08/14/1992 1 08/14/1992 3,500 Hired
3 H 1 04/01/1992 1 04/01/1992 2,250 Hired
4 H 2 05/03/1993 2 05/03/1993 2,250 Hired
5 H 2 10/17/1993 2 10/17/1993 2,500 Hired
6 H 5 10/17/1993 2 10/17/1993 4,000 Hired
7 H 5 01/02/1994 2 01/02/1994 3,000 Hired
8 H 2 05/05/1994 2 05/05/1994 2,500 Hired
9 H 5 11/15/1994 2 11/15/1994 3,000 Hired



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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