Supermarket+database

Create a database for one of the main supermarkets (Tesco, Asda, Morrisons etc.)

Task
You should use the company's website to find the actual product items. The database should contain the following fields:


 * Product ID
 * Product Name
 * Supplier/Manufacturer
 * Category (e.g. fruit & veg, dairy, frozen etc.)
 * Price
 * Image

Create the flat file database and include 30 records. These should be based on actual products

Create two layouts for your database:

1. Shop manager view (report), showing all products in a single scrollable page 2. Customer view showing one product per page, laid out in a professional manager

Further work
Can you create a summary view for the chief executive which shows a total of the number of records in each category?