Use Access to develop a failure-tracking database application. Use the data in the Excel file Ex37 for this exercise. The file includes columns for the following:

FailureNumber DateReported FailureDescription ReportedBy (the name of the PQA engineer reporting the failure)

ReportedBy_email (the email address of the PQA engineer reporting the failure)

FixedBy (the name of the programmer who is assigned to fix the failure)

FixedBy_email (the email address of the programmer assigned to fix the failure)

DateFailureFixed FixDescription DateFixVerified VerifiedBy (the name of the PQA engineer verifying the fix)

VerifiedBy_email (the email address of the PQA engineer verifying the fix)

a. The data in the spreadsheet have not been normalized.
Normalize the data by creating a Failure table, a PQA Engineer table, and a Programmer table. Add other appropriate columns to each table. Create appropriate relationships.

b. Create one or more forms that can be used to report a failure, to report a failure fix, and to report a failure verification. Create the form(s)
so that the user can just pull down the name of a PQA engineer or programmer from the appropriate table to fill in the ReportedBy, FixedBy, and VerifiedBy fields.

c. Construct a report that shows all failures sorted by ReportedBy and then by Date Reported.

d. Construct a report that shows only fixed and verified failures.

e. Construct a report that shows only fixed but unverified failures.