IS 2010 Lecture Notes - Lecture 7: Data Validation, Unique Key, List Box

• School: University of Utah
• Department: Operations & Information Systems
• Course: IS 2010
• Professor: Lucy Woolsey

Document Summary

Creating a table in design view- create tab, table design button, type name of first field and press tab. Click drop down arrow on next box and choose what you want, press tab again. Type useful description in next box and click tab. When finished, click the save button at the very top. Setting the primary key- click row you want, click the primary key button in the design tab. Formatting fields- click anywhere in table, fields tab, click drop down arrow in on button under date/time. To do this in design view, click anywhere in table, click drop down arrow to the right of the format row down below. Creating a custom text field format- select row, click in format row down below, type the character for the format you want. In order to have the text appear as uppercase letters, type the >. Creating field validation rules- select row, click validation rule row down below.