Practical Lab: KoKo's Pets...
Provide hardcopy of your professionally prepared work:
Maintenance Form(s):
Create a form that will allow the maintenance of data in the Client table. Use the draft of the form in Figure 1 as a guideline for your work.
Create a form that will allow the maintenance of data in the Pet table. Use the draft of the form in Figure 2 as a guideline for your work.
Provide a screen shot of the forms displaying:
Client Form - the LAST client data row
Pet Form - the FIRST pet data row
Report(s):
Walker Schedule Report:
Use the draft of the report in Figure 3 as a guideline for your work.
Sort by walk time code within walkers last name...make the walker last name the first column and the walk time code the second column.
Leave the report date and page numbering in the page footer where the report wizard places them.
Add your name and znumber to the top of the report below the report title.
Provide deliverables of:
A screen shot (copy/paste) of query design
Printed report output
Information Specifications Section - Answer the following question(s) with a query and report:
Question #4:
Sort by clients last name...make this data the first column on report.
Leave the report date and page numbering in the page footer where the report wizard places them.
Add your name and znumber to the top of the report below the report title.
Provide deliverables of:
A screen shot (copy/paste) of query design
Printed report output
Provide additional hardcopy output of:
Relationship Screen...showing all tables, organized Left-to-Right/Top-to-Bottom for parent and child tables, all relationships to enforce referential integrity.
Lab 5: Krystal Kleen 2...Modeling MSS
Provide hardcopy of your professionally formatted report(s):
Gross Sales by Month
Monthly Sales Totals by Service Number
Price Usage by Service Number
Lab 4: Krystal Kleen 1...Modeling TPS
Provide hardcopy output of:
Print all of the rows/records for the SALES DETAIL table ONLY. Fit to one if possible to save paper.
Customer Form...Print the image of the form displaying the FIRST (#1) CUSTOMER.
Print the Relationship Screen that will show that you have established the data relationship.
Lab 3: Not-For-Profit Raffle
Provide hardcopy of your professionally prepared model(s):
Football Mania Family Ticket Report
Required layout and appearance example will be distributed in class.
Use a font size of 14.
Generate and deliver 2 reports. Family names of:
Demrow
Orlowski
You are to design and develop an additional Pivot Table Report sourced from the same data.
Your report is to SUMMARIZE the data.
You are to identify the BUSINESS VALUE of your report. Author a statement on this deliverable page that concisely states the business value.
Provide additional hardcopy output of:
None for this assignment...
Lab 2: Miller - Terrell & Terrell Properties
Provide hardcopy of your professionally prepared model(s):
Commercial Property Summary
Individual Property - Halley Property Sheet only
Provide hardcopy of formula audit for:
Commercial Property Summary sheet...ONLY THE COLUMNS OF:
January, February and March
Answer the following by highlighting each numeric answer in your Commercial Property Summary model, above:
What was the income from all commercial units last year?
What was the single largest monthly expense incurred?
Provide hardcopy to answer the questions in the section entitled "Information Specifications":
Author a Word Processed business memo that answers Question 7:
Follow format shared in class
Address to the business owners.
Lab 1: Miller - Piedmont Trailer
Provide hardcopy of your professionally prepared model(s):
Economic Feasibility Summary sheet with Cash Flow Analysis (pg1)
Provide hardcopy of each of the three source data models (pg2+):
Tangible Benefits/Costs
One-Time Costs
Recurring Costs
Provide hardcopy output to answer the questions in the section entitled "Information Specifications":
Q4...by reducing IT staff dollars by specified amount. Print:
EFSW with results (pg+3)
Recurring Cost sheet (pg+4)