1.Mid Term Mini Project

You will create an Access database for inventory management for the Pie Safe Bakery and Creamery in Deary Idaho. This will be for finished products only.

Deliverables

1.ERD

2. Data Dictionary

Then Create a database in Access from the ERD

1.Screen shot of each table

2.Screen shot of the relationship page.

Then develop a two table query and enter in some test data. Then run the query and show me that it works.

1.Screen shot of the results

2.Screen shot of the query in SQL View.

Then write a paragraph or two on what you learned doing the project.

The best way to put this together would be to take all your screen shots and put them into a Word document.