391766 MS Access Stock / Sales System

Project Brief for Microsoft Access Stock / Sales system This project is for my client who runs a Scuba Diving shop. It's to keep track of their stock and sales and make the correct profi calculations so they know how much tax to pay. It also keeps a track of their Qualified Scuba Diver members. Stock interface must be able to: - Record VAT on items at different rates (eg. 15%, 0%, 5%, 17.5%) - Add / remove old / new stock items to the system - Change the amount of any items at any time - Change the price of any stock item at any time - VAT changes can be done to several selected items at once - Historical stock recorded information is not affected by current or future changes to the VAT rate - Produce reports of stock levels and value at any time between 2 date ranges. - Synchronize the stock items list and their excluding VAT prices with the Access Database Sales interface must be able to: - Record sales to customers including the VAT breakdown - Allow the operator to choose an item being sold from the list of stock items from a drop-down menu and enter a quantity being sold - Allow the operator to search for stock items by beginning to type the item name, and the interface autocompletes what the operator is typing - Produce reports of any sales within a start and end date range - A report for a single day's sales or the current day's sales with the minimum of mouse clicks - The net income and total VAT are shown on all sales reports