I need a MS Access database to help with vendor sales reporting.
[url removed, login to view] database should allow me to upload a CSV and/or EXCEL file with sales data. (about a 5MB file size)
2. The sales data CSV file will just have 7 fields.[SALES DATE & several tracking code fields]
3. The database should allow me to setup products and assign a price for each product. Products should be able to have tiered pricing based on unit volume.
4. The database should allow me to setup vendors and assign a product(s) to a vendor. It should also allow me to input their contact information which will include multiple email addresses.
5. The database should allow me to produce reports based on a specific vendor and date range. [List all sales for a date range X payout per sale amount]
6. The datasebase should allow me to email a report based on a specific date range to the email address(s)on record for a specific vendor.
VENDORS THAT CAN PROVIDE PROOF OF SIMILAR WORK DONE PREVIOUSLY WILL BE GIVEN PREFERENCE.