Informations Systems For Access

Application Exercises: Question 37 (Page: 613), Tracking Systems Failures with Access. Answer all parts of the question (a to e).

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

FailureNumber DataReported

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

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

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

DateFailureFixed

FixDescription

DateFixVerified

VerifiedBy (the name of the PQA engineer verifying the fix)

VerfiedBy_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 fil lin the ReportedBy FixedBy, and the VerfiedBy 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

Data File: Ex37

“File is below”

https://docs.google.com/spreadsheet/ccc?key=0AtWNzikXvnTldHkzZFJFenUwd2hCaU9GNXFuX0RFT0E#gid=0

Access Tutorial – Power Point file

Here is the link

https://docs.google.com/presentation/d/1Ck6YlJed2igSd78MIhXGbDy6KGAumHs0SlTYezlr7Ok/edit

General Access Tips: (Select the Access Topic and watch the presentation).