Question $1$: Create a Database in MS Access

Task Breakdown:

Database Tables

Create three tables: Customer, Product, Sales.

Define appropriate columns for each, such as CustomerID, Name, ProductID, Price, SalesDate, etc.

Attributes

Ensure each table has at least five attributes $($fields$).$ For instance, in the Customer table, include CustomerID, Name, Phone, Email, and Address.

Inventory and Customer Table Population

Add at least ten items in the Inventory table and ten customers in the Customer table. For example, for Inventory: Bread, Cake, Cookies, etc.

Order Column in Customer Table

Add an Order column to the Customer table and link the customers with the products they've ordered from the Inventory table.

Design View Order Field $(1$ mark$)$:

In Design View, set the Required property for the Order field to Yes.

Naming Convention

Use consistent and meaningful names for tables and fields, like tblCustomer, tblProduct, tblSales.