Question: Video Superstore has hired you to design two online data entry screens. Based on what you know about the operation of a video rental store,

Video Superstore has hired you to design two online data entry screens. Based on what you know about the operation of a video rental store, complete the following assignments.
1. Design a weekly operations summary report that will include overall data on rentals, new customers, late charges, and anything else you think a store manager might want to review. Be sure to include numeric activity and dollar totals.
2. Design a data entry screen for entering new members.
3. Design a video rental input screen. In addition to the video data, the video rental form must include the following fields: Member Number, Name, and Date.
4. Suggest at least three data validation rules that might help reduce input errors for the video rental system.

Step by Step Solution

★★★★★

3.42 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 It should review the summary report shown in Figure page and the SWL summary report shown in Figur... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

200-B-M-A-C-S-D (471).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!

Based on what you know about the various documentation techniques, what technique(s) would you propose to the members of the group? How will the technique(s) you proposed overcome some of the...

Based on what you know about the Financial Times (FT) World Index, the Morgan Stanley Capital International World Index, and the Dow Jones World Stock Index, what level of correlation would you...

Based on what you know about the quick-service restaurant industry, does McDonald's strategy as described in Concepts & Connections 1.1 seem to be well matched to industry and competitive conditions?...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

I was wondering if someone could help me with this assignment with several things. 1. I need a Structured/Activity Flow Chart 2. Detailed Recommendations for the client 3. Cover Letter/Title...

please reas the instruction instructions are below the. write a report after reading the article only responsibilties of CEO CEO/President Job Title: CEO/President FLSA Status: EEO Code: Salary...

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

Willowbrook Case Study question: Design the monthly billing statement for a family using a printer spacing chart or graph paper. Include a mock-up report and a report analysis form for each report ....

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

4 easy accounting questions and a comfortable due date. Sorry I can't offer any more tutor credit. Thanks in advance! :-) Question 1: A few years ago, a publishing company in the fourth quarter had a...

1. What is the problem facing the ER staff in terms of the discrepancy between the ideal and actual conditions? 2. How might the hospital staff go about resolving the problem or problems described by...

Consider the sample s = (x1, . . . , xn), realization of a random sample X1, . . . , Xn from a uniform on [0, ], with unknown. The goal is to estimate the unknown mean /2, based on s. To this end we...

Refer to the data given in problem 14.11 on page 564 that represent New Zealand GDP. a. Fit a third-order autoregressive model to the GDP data and test for the significance of the third-order...

7. Compute a labor cost base index for the data in the Excel workbook C08 Problem Data for Miami Valley Aircraft Service Co. Analyze the quality cost information and prepare a memo to management...

In what ways do displays, printed output, and Web-based documents differ?

List four guidelines to facilitate the design of good display output.

What differentiates output for a DSS from that of a more traditional MIS?

b-2. Which, if either, of these projects should be chosen if the appropriate discount rate is 16 percent? Project A Project B Both projects Neither project

) LPD Logistics, Inc.'s projected sales for the first six months of 2010 are given below. Jan. $300,000 April $350,000 Feb. $350,000 May $500,000 Mar. $475,000 June $400,000 20% of sales are...

In a random sample of 100 measurements, the mean is 33.9 and the standard deviation is 3.3. Using a 95% confidence interval, what is margin of error = +- lower limit of confidence interval = upper...