Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Case Example

This chapter discussed many of the issues connected with creating tables, but you never actually got around to creating one from start to finish. This case example attempts to remedy that shortcoming. The Nifty Lions database currently has no Employees table. In the following exercise, you create the table using these columns and business rules:

• EmployeeID (primary key)

• Social Security Number

• Employee Last Name

• Employee First Name

• Street Address

• City

• State

• ZIP

• Biography

• Photo

• Date Hired

• Employee Website

• Hourly Wage

• Overtime (i.e., whether the employee is willing to work overtime.)

• Allowed Vacation Days (Must not exceed 10)

• Allowed Sick Days (Must not exceed 10)

Total allowed vacation days and total allowed sick days cannot exceed 20.

Here are the ...