In the section on Relationships, we learned that we can protect inaccurate information from being entered by enforcing referencial integrity. We can also alter the design of a table to only accept certain inputs. We will alter the design view of the PRO SHOP ORDERS table to make data entry more foolproof. This can be done by selecting a specific field and changing the Field Properties at the bottom of the box
For the purposes of this table, we will make 4 alterations. We will make the Quantity field required input, add a default value of today's date for the Date field, only allow the number 1-3 to be entered for Payment Method, and use a lookup for the Salesperson field. Click on any of the four fields below.
Once the changes are made, you can go back to Datasheet View in the table. However, the computer will warn you that the records already entered in the table may not meet the new data entry rules. It will perform a check for you. If it finds any in error, it will give you the option of fixing them or leaving the old records as they are. If you do the latter then alter the record later, the new data entry rules will be enforced.
 |
 |
 |
 |
last modified 10/20/98 pjm