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

Chapter 5. Entering, Editing, and Valida... > Adding Records to the Personnel Acti...

Adding Records to the Personnel Actions Table

Now you can test your work in creating the Personnel Actions table and check whether Access is enforcing referential integrity. The initial entries for each of the nine employees of Northwind Trading are shown in Table 5.7. The entries for paScheduledDate and paEffectiveDate are taken from the HireDate field of the Employees table. The HireDate field of the Employees table now is superfluous because it duplicates the data in the Personnel Actions table. (You delete the HireDate field in a later chapter.) Feel free to be as generous or as parsimonious as you want with the monthly salaries shown in the paAmount field.

Table 5.7. First Nine Entries for the Personnel Actions Table
IDTypeInitiated ByScheduledApproved ByEffective DateNew AmountComments
1H101-May-92 01-May-922,000Hired
2H114-Aug-92 14-Aug-923,500Hired
3H101-Apr-92 01-Apr-922,250Hired
4H203-May-93203-May-932,250Hired
5H217-Oct-93217-Oct-932,500Hired
6H517-Oct-93217-Oct-934,000Hired
7H502-Jan-94202-Jan-943,000Hired
8H205-Mar-94205-Mar-942,500Hired
9H515-Nov-94215-Nov-943,000Hired



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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