Microsoft Access 2013 Inside Out

Defining a table validation rule for web apps

Table validation rules are handy when the values in one field are dependent on what’s stored in another field. You need to wait until the entire row is about to be saved before checking one field against another.

In the Restaurant App you have been creating, we need an Appointments table to track day to day appointments of managing the restaurant. This table requires a table validation rule. Click the Table button in the Create group on the Home ribbon tab to get started. On the Add Tables screen, click the Add A New Blank Table link to begin creating a new table in Design view. Define that table now using the specifications in Table 3-6. Be sure to rename the ID field Access provides for you to AppointmentID ...