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 ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.