MS Access assignment

Task 1:

1. Create a table “Products information” with correct data types. Table contains -

·

· Product_ID

· Category

· Sub_Category

· Product_Name

· Sales

· Quantity

· Discount

· Profit

· Order_ID

· Customer_ID

(Product_ID is the primary key)

2. Enter these data in the table

3. Create a table “Order information” with correct data types. Table contains –

·

· Order_ID

· Order_Date

· Ship_Date

· Ship_Mode

(Order_ID is the primary key)

4. Enter these data in the table

5. Create a table “Customer information” with correct data types. Table contains –

·

· Customer_ID

· Customer_Name

· Segment

· City

· State

· PostalCode

· Region

· Country

6.

7. Enter these data in the table

8. Make a relationship among these three tables.

Task 2:

1. Create a query which shows product details. Condition –

· Products only for Canada.

2. Create a query which show product details. Condition –

· Ship mode is Standard Class.