Use Access to develop a failure-tracking database application. Use the sample data in the Excel file Ch12Ex02_E7e 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.

When you enter (or, better, import) the data, normalize it by creating a Failure table, a PQA Engineer table, and a Developer table. Assume problems are reported and verified by PQA engineers and problems are fixed by developers. 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 use a combo box to pull down the name of a PQA engineer or developer 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.