2. Use Access to develop af ailure-tracking database application. For each failure, your application should record the
Question:
2. Use Access to develop af ailure-tracking database application. For each failure, your application should record the following:
FailureNumber (Use an Access autonumber data type.)
DateReported FailureDescription ReportedBy (the name of the PQA engineer reporting the failure)
FixedBy (the name of the programmer who is assigned to fix the failure)
DateFailureFixed FixDescription DateFixVerified VerifiedBy (the name of the PQA engineer verifying the fix)
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 reporting PQA engineer and then by DateReported.
d. Construct a report that shows only fixed and verified failures
e. Construct a report that shows only fixed but unverified failures.
Step by Step Answer: