By using Access to create a database
By using Access to create a database, the company’s executives will have easy access to customer and product information. Report 1 shows the products that the company sells. Each product is listed by product number along with its price. Using a database helps minimize errors that might have occurred manually. “Edit Product Data” shows an individual product along with its associated product number and its price. Under “Products”, the table shows all of the products, their product number, and prices all condensed into one table. It gives an easy to view list of all the company’s products and their associated price. This table can then be used to generate other reports.