Exercise 2

Week 3 Database Application Requirements

Points Possible

Using the FY2012 database table data, creates three queries to extract data for each report:

· Sales agents by office

· Sales agents by destination

· Destinations sold by each sales agent

25

Creates report from query of all sales agents, grouped by office, with total number of agents by office included.

25

Creates report from query of all sales agents, grouped by destination, with total number of agents

25

Creates report from query of each sales agents destinations sold with total number of destinations.

25

Submit completed Access database file (or .mdb) to the application project dropbox. Work not submitted in the correct format will be returned for revision.

Week 3 Excel Application Project Requirements

Points Possible

Adds appropriate title to the worksheet.

10

Adds labels to describe each row and column:

· Travel Scenarios

· Price

· Rate

· Time

· Number of Payments

· Payment

· Total Paid

· Total Interest

40

Incorporates calculation using the PMT function to calculate the payment amount for each scenario. Example formula =PMT(C4/E4,E4,B4,,0)*-1)

30

Incorporates calculation to calculate the Total Paid for each scenario (payment x number of payments)

10

Incorporates calculation to calculate the Total Interest for each scenario (total paid minus price)

10

Submit completed Excel workbook file to the application project dropbox. Work not submitted in the correct format will be returned for revision.