O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required