• 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. The dates are based on values in the Employees table’s HireDate field. 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 IDAction TypeInitiated ByScheduled DateApproved ByEffective DateNew SalaryHRComment
1H105/01/1992105/01/19922,000Hired
2H108/14/1992108/14/19923,500Hired
3H104/01/1992104/01/19922,250Hired
4H205/03/1993205/03/19932,250Hired
5H210/17/1993210/17/19932,500Hired
6H510/17/1993210/17/19934,000Hired
7H501/02/1994201/02/19943,000Hired
8H205/05/1994205/05/19942,500Hired
9H511/15/1994211/15/19943,000Hired



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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