I am a novice Access user. I have designed a couple of tables and a query to get the information that I am looking for. I am looking for a Microsoft Access 2013 Expert to help me do the following:
• Design an Executive Dashboard to run Reports
• Design Reports that can filter records in order to drill down and/or some-up as needed.
I want to be able to use the following Drop Down Menus to filter the database records, where I can select a specific filter like one Division, Customer or if I want all Customers to show up on the Report.
Drop Down Menus
• Division (2 Divisions)
• Customer (25+ Customers and growing)
• Class (12-15 Classes) Every Customer/Transaction is assigned a Class
• Collection (25+ Collections and growing)
I want to be able to run the reports in whole dollars or rounded to the thousands with one decimal point.
The database should run reports efficiently. I am adding 2500-5000 detail records monthly.
I have attached my current access file. Please review the current files/tables/queries/Reports carefully.
Please provide the following to help me in selecting your services:
1. Project Quote
2. Completion Date
3. Proposed changes to be made to the Current Tables
4. Any limitations on what I am proposing