Inventory Management System for Small Business in Access Templates Specifications
|
Manage inventory and product transactions in Microsoft Access.
Small Business Inventory Management System for Microsoft Access Templates, Features: 1. Products - Product ID; Product Name; Product Unit Cost; Adjusted Qty (Automatically Calculated). 2. a. Suppliers - Supplier ID, First Name, Last Name, E-mail Address, Address, Phone Number; b. Deliveries details by the Supplier: - Product, Qty Bought, Expected Date, Actual Delivery Date, Order Status. 3. a. Customers - Customer ID, First Name, Last Name, E-mail Address, Phone Number, Address; b. Sale to the Customer: Product, Transaction Data, Qty Sold, Unit Cost, Total Cost, Available Qty (Automatically Calculated/Adjusted). 3. Reports: Generate Printable Report for: Sales Report: Customer Transaction; Orders Report: Supplier Transaction; Product Inventory Report: Inventory Quantity Status.