Provides information from database to users in easy-to-understand format
Your sister has started her own home-décor shop. She sells items such as candles, pictures and knick-knacks. She wishes to track the items in her inventory, sales and customer information. You agree to assist her in setting up a simple MS Access database that will track the appropriate information.
Business Example, Continued
You identify that three tables should be created:
Product Table containing the product number, product name, product description, product price, and product on hand.
Sale Table containing the sale number, sale date, the product sold and the customer.