Module Outcomes: Examine the forms available in Microsoft Access.Create a simple form in Microsoft Access.Examine data validation concepts.Use data validation in a form in Microsoft Access.Apply encr

by


Module Outcomes: 

  • Examine the forms available in Microsoft Access.
  • Create a simple form in Microsoft Access.
  • Examine data validation concepts.
  • Use data validation in a form in Microsoft Access.
  • Apply encryption to an Access database.

Explanation

This assessment is divided into 2 parts with multiple file submissions. Please read all directions, including submission directions for each part, and submit as directed.

Module 3 Assessment Part 1

Purpose

In the business world, the people who enter data for insertion into a database are not typically technical people. Therefore, the use of well-designed, easy to use forms ensures that the data is entered correctly. You will focus on the design and layout of a form.

Assessment Instructions

You will create a split form for the Products table (tblProducts) from the provided sample database. This will allow the user to enter information for a single record using a simple data entry form while also having access to the datasheet view of the table.

  1. Open the sample database.

For this assessment, you will use this sample database: IT163_ModelCarSampleDatabase.accdb

  1. Select tblProducts from the list of table objects in the navigation pane.
  2. Create a split form for the Products table. A split form shows two views of the same table (one for single record data entry and the other is the datasheet view of the records currently in the table).

Hint: Select the Create tab on the ribbon and click the More Forms command in the Forms group and choose Split Form.

Reference:

Ulrich, L. A. & Cook, K. (2019). Access 2019 for dummies. Wiley.

  • Chapter 8: “A Form for All Reasons”
    • Generating Forms
  1. Save the form as Products and close it.
  2. Right-click the form in the navigation pane to open in the design view.

Reference:Alexander, M., & Kusleika, D. (2019). Access 2019 bible (1st ed.). Wiley.

  • Chapter 17: “Creating Basic Access Forms”
    • Working with Form Views
  1. Add the current date/time to the header for the form.

Reference:

Alexander, M., & Kusleika, D. (2019). Access 2019 bible (1st ed.). Wiley.

  • Chapter 18: “Working with Data on Access Forms”
    • Adding a Form Header or Footer
  1. Right-click the form tab and switch to the layout view.
  2. Go to the Form Layout Tools/Design tab.
  3. Change the title of the form to “Product Entry Form.”

Reference:

Alexander, M., & Kusleika, D. (2019). Access 2019 bible (1st ed.). Wiley.

  • Chapter 18: “Working with Data on Access Forms”
    • Working with Form Properties
  1. Return to the form view.
  2. Use the navigation controls at the bottom of the form to advance to the sixth record in the table (it should show the product described as the 1967 Ford Fairlane for $31.99).

Reference:

Ulrich, L. A. & Cook, K. (2019). Access 2019 for dummies. Wiley.

  • Chapter 8: “A Form for All Reasons”
    • Managing Data in Form View
  1. Take a screenshot showing the data for that record in the form view showing the split form format. Paste into a Word document.

Example: IT163_Example_SplitForm.jpg

Assessment Requirements

For this part of the assessment, you will submit a single document including the required screenshot showing the split form successfully created per instructions in Microsoft Access.

Module 3 Assessment Part 2

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 assessment, 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.

Assessment 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.

  1. Open the sample database.For this assessment, you will use this sample database: IT163_ModelCarSampleDatabase.accdb
  2. You will apply encryption to your database and use the password “PurdueGlobal”

For extra help see Optional Resources for Assessment under the Academic Tools, Library link:

Reference:

Microsoft. (n.d.). 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

  1. Create a form with subform for the Customer (main form) and Customer Contacts tables (subform).

Reference:Alexander, M., & Kusleika, D. (2019). Access 2019 bible (1st ed.). Wiley.

  • Chapter 19: “Working with Form Controls”
    • Working with Subforms
  1. Name the new form with subform CustomerContactSubForm and save it as a new form object in your database.
  2. 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 (1st ed.). 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 Assessment under the Academic Tools, Library link:

Microsoft. (n.d.). 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

  1. 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.
  2. Save your Microsoft Access database file for submission.

Assessment Requirements

For this part of the assessment, you will submit your entire Microsoft Access database.