Question data analysis

[Danny]

Greetings,

I've successfully imported XML data into Excel and Access (please see attached striped version) and start maneuvering around. My next task is the following:

1) average invoice total amount for application fees only, broken out by division, for the third quarter of this year.
2) Using the relational database, create a deduped mailing list for as many current and complete addresses as possible. Submit the mailing list as an XML file.
3) Create a reader-friendly report break out the following statistics per division, based on the relational database:
a. Total number of currently accredited sites
b. Total number of applications in process
c. Number of labs that have achieved accreditation in multiple divisions
d. Total number of sites granted accreditation in each app area
e. Average number of sites per application

I'm using office 2007, what is the best way to accomplish these?

Please help.

Thanks

D.

 

[MarkK]

Best way is to ask for less and offer more, for instance, in respect to your number 1), how much do you know about writing queries? What have you tried? What errors are you getting? Or are you getting unexpected results?
To me, if you're not looking at it that level, then it comes across like you want the work done for you, and then you should hire someone.
Cheers,