We need a MS Access database that will produce sales reports based on imported CSV data. This doesn't need to be pretty just functional. Preference will be given to the provider that can provide insight into improvements on my specs.
High level specifications include:
- Vendors (6 fields plus change logs)
- Products (5 fields)
- Lead data (8 fields)
- Sales data ( 8 fields)
- Filtered lead data reports (requires lookup in data, vendor and product tables)
- Filtered sales data reports (requires lookup in data, vendor and product tables)
- Import lead data CSV files (must dedup new imports based on unique ID)
- Import sales data CSV files (must dedup based on unique ID)
- Export filtered CSV file for leads/sales
- Attached filtered reports to Outlook email as CSV file
Good luck in bidding.