Sedang Disiapkan

226411 MS Access Database

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:

Tables

- Vendors (6 fields plus change logs)

- Products (5 fields)

- Lead data (8 fields)

- Sales data ( 8 fields)

Reports

- Filtered lead data reports (requires lookup in data, vendor and product tables)

- Filtered sales data reports (requires lookup in data, vendor and product tables)

Features

- 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.

Kemahiran: Semua Boleh, Microsoft Access

Lihat lebih lanjut: vendor database ms access, ms lookup, access vendor database, database vendor, ms access, ms access email, MS Access Database, access database, csv product export, sales access, sales database microsoft access, microsoft access vendor, vendors access, vendor database access, access vendors, microsoft access lead database, can import data database, import data access, outlook email access database, import email outlook access database, database export data, import csv database, improvements access, lead database access, improvements access database

Tentang Majikan:
( 47 ulasan ) Buda, United States

ID Projek: #1972649