We run an online store that sells DVDs and console games, and use various channels such as our own website, various shopping comparison sites, Google Adwords, and eBay.
We maintain a Master Database of products, and would like to add some macros and forms to this Access database to simplify our import and export process.
That is:
1. We run a separate application that updates stock data from our suppliers into an Update Database. We need an import macro that helps import from the Update Database into the Master Database.
2. We export from this Master Database into various file formats for different shopping comparison sites, eg [login to view URL], [login to view URL], etc. Each site requires the same data in a slightly different format and with a slightly different field name - macros should be written to easily export in the correct formats.
File includes:
a) Database [login to view URL], which explains what needs to be done in the import / export process.
b) Master [login to view URL], which is the database where the forms and macros should be created.
c) Various files (1 to 9) which are samples of the import and export files if they are prepared correctly.
*** Note: Must include basic documentation on work completed on the Master Database. ***
## Deliverables
I am available to communicate via Skype or phone conference to speed up answering any questions.