Dear Sir/Madam,
I have over 10 years of experience as a data analyst, who uses a lot of Excel and SQL in my daily work. As for MS Access, I have built a system used by Nuplex Industry New Zealand to manage their formulas, clients, orders. Thus, I believe that I should be able to help you with your projects.
In my opinion, to manage customer data, track inventory and sales, and analyze financial data as you required, 5 tables might not be enough. So far you would need:
- Customers table where you will store customer information. To ensure clean and consistent data, this table might require a few more tables (i.e. Cities where the client is located, Contact person, States, etc.)
- Items table to store your products information. Similar to customers table, to ensure clean and consistent data, this table might require additional tables (i.e. item types)
- Inventory table to record movements of your products (how many sold, import, destroyed etc.)
- Sales table to record your sales
When given more details regarding your business, I would be able to design and create the Access database in approximately 2-3 hours. Then we can look at the specific requirements. If you already have something in mind, I can recreate it as you wish. However, if you don't, it would take some time going back and forth to find the designs that meets your approval. My design style is minimalist so it would look professional but might be bland to your taste.