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.)

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 Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Experiencing MIS Questions!

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...

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...

(1) The Quality of Financial Information Referencing this week?s readings and lecture, describe the quality issues related to reporting revenue. What is the importance of understanding various...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

1. Referencing the State of Kansas contract, you will find this is an IDIQ contract. Which other contract type could have been used for this contract? What are the pro and cons of the contract type...

2006 National Institute of Standards and Technology Technology Administration Department of Commerce Baldrige National Quality Program Arroyo Fresco Community Health Center Case Study 2006 National...

Midwest Executive Professionals IMPROVE A DATABASE BY CREATING AND MODIFYING TABLES, QUERIES, FORMS, AND REPORTS - GETTING STARTED . Open the file IL_AC19_CS1-4a_FirstLastName Waacob, available for...

Requirements 1. Using Access or a similar relational database, create the tables needed to set up a database for contributors, contributions, and animals. 2. What data field did you use for the...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Use demand and supply analysis (draw fully labelled graph) to explain why an expectation of higher the interest rate next month would cause Treasury bond prices to fall today. If a higher inflation...

Alexsandra Isosev Industries has three operating divisionsFalilat Mining, Mourning Paperbacks, and Osygus Protection Devices. Each division maintains its own accounting system and method of revenue...

Question 1 ( 2 0 marks ) Tree Row Bank has assets of $ 1 5 0 million, liabilities of $ 1 3 5 million, and equity of $ 1 5 million. The asset duration is six years and the duration of the liabilities...

Prove that the maximum value of $R^{2}$ is less than 1 if the data contain repeated (different) observations on $y$ at the same value of $x$.

What are expert systems?

How do people share knowledge via collaboration?

What are the challenges of content management?

Identify the factors that influence the selection of specific market segments for use as target markets Identify the factors that influence the selection of specific market segments for use as target...

An insurance settlement offer includes annual payments of $36,000, $42,000, and $50,000 over the next three years, respectively, with the first payment being made one year from today. What is the...

in what year did tghe last shah first become king