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