IT163 Database Concepts Using Microsoft Access

IT163-3: Create forms to input data.

Instructions

Using Microsoft Access You must use the attached .zip Access Database for this assignment. Using the form you created in unit 5, you will add validation as follows

Company Name – Validate that field is not blank

Address – Validate that field is not blank City – Validate that field is not blank

Zip Code – Validate that field is numeric and 5 characters Phone Number

– Validate that field is not blank

Payment Terms – Create a dropdown box State -Create a dropdown box

Country -Create a dropdown box (include at least three countries) Fax

Number -Validate that field is not blank

Website -Validate that field is not blank

Notes – No validation as user may not have notes to add
Use this image as an example, yours may differ: