Background:

You run a small bakery. You've been using a recipe binder and a notebook to track sales, but it has become cumbersome and confusing. You recently learned about Microsoft $($MS$)$ Access databases and want to showcase your new skills by creating a system to make your bakery more efficient.

You have identified several entities from your research on the operations of the bakery shop and decided to include a customer, product, and sales table in your MS Access database.

Required:

Create a database in MS Access for the sales management system and upload a copy of the database on ColCampus.

Rubric:

$\backslash$table$[[$Criteria$,$Requirements,Marks$],[1,\backslash$table$[[$The student created appropriate database$],[$tables with proper columns.$]],6$ marks$],[2,$At least five attributes in each table.,$3$ marks$],[3,\backslash$table$[[$Provide at least ten items in the inventory$],[$table and ten customers in the customer table$]],4$ marks$],[4,\backslash$table$[[$Add an order column in the customer table$],[$and provide all customers with their own$],[$orders from the inventory table.$]],2$ marks$],[5,\backslash$table$[[$In the Design View, ensure that the$],["$Required$"$ property for the order field is set to$],["$Yes$".]],1$ marks$],[6,\backslash$table$[[$The correct naming convention is used, and$],[$consistency is followed.$]],4$ marks$],[,\backslash$table$[[$Total$]],]]$