I am not extremely familiar with Access and databases, but here are my needs:
I need to be able to have one database for all my products which will have the ability to export different .csv files according to the website I am needing it for. Presently, I have one .csv with about 35 fields for the main database. I would need to update this with new imports. I would also need to be able to add new fields easily myself.
The exports would need to be customized with selected fields and different field names. I will also need to have a form where I can create new products and/or edit existing products.
Another excel spreadsheet would need to be integrated for pricing. This workbook takes 14 fields from the database and calculates pricing.