Unit 6 Assignment: Data Validation and Security Outcomes addressed in this Assig

Unit 6 Assignment: Data Validation and Security
Outcomes addressed in this Assignment:
Examine data validation concepts.
Use data validation in a form in Microsoft Access.
Apply Encryption to an Access database.
Course Outcome:
IT163-3: Create forms to input data.
Purpose
The form is the mechanism for transferring data from the user into the program and back again. Understanding how the form is used and how data is validated is essential to building an interactive database application. In this assignment, you will extend your knowledge of forms to include working with a form with subform, the use of controls in a form and data validation.
Assignment Instructions
You will create a form for the Customer table with a subform for the Customer Contacts table so that data can be entered into both tables at the same time. You will also add controls and apply data validation to several fields in the Customer form. You will also apply encryption to password protect your database.
Open the sample database.
For this assignment you will use this sample database:
IT163_ModelCarSampleDatabase.accdb
You will apply encryption to your database and use the password “PurdueGlobal.”
For extra help see Optional Resources for Assignment under the Academic Tools, Library link:
Reference:
Encrypt a database by using a password
https://support.microsoft.com/en-us/office/encrypt-a-database-by-using-a-database-password-12aa0e5c-34c6-4957-af3b-b5f5cfa9a766
Create a form with subform for the Customer (main form) and Customer Contacts tables (subform).
Reference:
Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 19: “Working with Form Controls / Working with Subforms”
Name the new form with subform CustomerContactSubForm and save it as a new form object in your database.
You will add validation and controls for the Customer data as follows. Use the validation rule with validation text to ensure a custom error message is displayed when a rule is violated where appropriate:
Company – Validate that field is not left blank
Address – Validate that field is not left blank
City – Validate that field is not left blank
State – Create a dropdown box control (include at least three states in the list)
ZipCode – Validate that field is at leave five numeric digits
Phone – Validate that field is not left blank and add an appropriate input mask
Fax -Validate that field is not left blank and add an appropriate input mask
Email – Validate that field is not left blank
WebSite -Validate that field is not left blank
Note: No validation required for the remaining fields.
Reference:
Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 19: “Working with Form Controls / The Combo Box and List Box controls”
Ulrich, L. A. & Cook, K. (2019). Access 2019 for dummies. Wiley.
Chapter 7: “Types, Masks, and Triggers”
For extra help see Optional Resources for Assignment under the Academic Tools, Library link:
Restrict Data Input by Using Validation Rules
https://support.microsoft.com/en-us/office/restrict-data-input-by-using-validation-rules-b91c6b15-bcd3-42c1-90bf-e3a0272e988d
Add one new record to the Customer table and one new record to the CustomerContacts table using the form with subform. Use your own last name in the Company field in the Customer table entry and in the Last Name field in the CustomerContacts table entry. The other data can be of your own choosing.
Save your Microsoft Access database file for submission.
Assignment Requirements
For this assignment, you will submit your entire Microsoft Access database.
Directions for Submitting Your Assignment
Name your file according to this convention: IT163_Unit6_Lastname.accdb (use your own last name of course). Submit your completed assignment to the Unit 6 Dropbox by the deadline.
Review the rubric before beginning this