Project Detail

Description

I am looking for excel/access guru who can help me out to create/build following project:

a) take information from several excel files and copy into access database that needs to be created also.

b) design simple user interface in access so the user can pick a report based on month or YTD preference

c) translate/copy our excel graphs/summaries into access reports - I want same reports be crated in access. right now it is excel based.

all reports are done in excel sheets and I would like to transfer them into access database rather than 3 excel sheets that are growing larger (new month = new sheet etc)

you must know access and excel very well, knowledge of graphs, privot tables in access and excel is a must. VBA in excel needed to.

any suggestions are welcome and nothing set in stone. please attach some samples of your work in access and excel.


Additional information submitted:

04/14/2009 at 12:41 EDT:
here is the sample of data file and output desired.

04/14/2009 at 12:41 EDT:
here is the output

Additional files submitted:
pic37-data.jpg
pic37-output.jpg