OMIS 351 Lab Deliverables

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.

• Be prepared to discuss your solution.

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

• Be prepared to discuss your solution.

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.

• Be prepared to discuss your solution.

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)

• Be prepared to discuss your solution.