REQUIRED MISSIONS TO BE SUBMITTED TO THE INSTRUCTOR:
1.
The CFO is has asked you to analyze payments made to ABC Rental. Create a query that
details the payments to ABC Rental.
Create an Access report that details and summarizes
your results.
(submit Access report in database)
Payments to ABC Rental is $-1,322.65
2.
You are reviewing the outstanding check list. You see that 2 checks are still outstanding
from 1995?
Look
at the other checks written in 1995 during that time period.
Can you
suggest what might have happened to these checks??
(write a short answer that contains
the details your findings, also, what is your recommended course of action)
I see that they’re both duplicate checks with different check numbers. I would recommend
taking the second check written for both amounts off the books.
3.
The Sales Manager would like an analysis of the sales for the years 1998 and 1999.
Create
queries to summarize the sales for each of the years.
Submit a memo to the Sales
Manager that answers the following questions:
a.
What are the sales for each year?
b.
Did sales increase/decrease? increased
c.
By what percent did sales increase/decrease?
d.
Using Excel, create a graph that shows the sales trend for 1998 and 1999
4.
The CFO would like to know the three largest categories of all payments made over the
last 5 years.
Create a Summary query that ‘Groups by’ Categories and ‘Sum’s the
Amounts.
(write a short answer and submit the queries you used to formulate your
answer in the DB)
Submit all required short answers, memos, and database through the drop box.
