Access Database Enhancement

Job ID: 39565809

Budget: $10 – $20 USD

I'm looking for an experienced Microsoft Access developer to enhance my existing invoice management database with two key features:

Real-Time Inventory Tracking
- Automatically calculate and display remaining stock on the product form/report.
- Formula: InitialStock minus sold quantities.

Bulk Product Import
- Add a CSV upload function to import or update products.
- Fields: ProductID, Name, Cost, SellPrice, StockQty, etc.
- Basic validation required.

Ideal Skills and Experience:
- Proficiency in Microsoft Access.
- Experience with database automation and CSV integration.
- Attention to detail for accurate data handling.

Looking forward to your proposals!