Use Access to develop a failure-tracking database application. Use the sample data in the Excel file Ch10Ex03_U7e.xlsx for this exercise. The data 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 are not normalized. Normalize the data 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 reporting PQA engineer 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.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.