1. Create a database using MsAccess 20** and name it as Tour Booking System

2. Create Table CUSTOMER with the following details. a. Customer_ID (Field size 5, Data type text, Primary Key, caption CUSTOMER ID) b. Customer Name (Field size 50, Data type text, caption CUSTOMER NAME) c. Address (Field size 100, Data type text, caption ADDRESS) d. Postal (Field size 5, Data type text, Input mask postal code, caption POSTAL) e. City (Field size 50, caption CITY, Data type text, default value KUANTAN) f. Phone (Field size 20, Data type text)

3. Create Table BOOKING with the following details. a. Booking No(Data type autonumber, non-key field) b. Customer_ID (Composite key) c. Package_ID(Composite key) d. Date Booking (Data type Date & Time)

4. Create Table PACKAGE with the following details. a. Package_ID (Field size 10, Data type text, Primary Key, caption PACKAGE ID) b. Duration (Field size 50, Data type text, caption DURATION) c. Destination (Field size 50, data type text, caption DESTINATION) d. Depart (Field size 10, data type date & time, caption DEPART)

5. Assuming that relationship between CUSTOMER and PACKAGE is BOOKING and cardinality constraint is MANY to MANY, establish Relationship among table CUSTOMER, BOOKING and PACKAGE

6. Key in five records in table CUSTOMER and table PACKAGE

7. Key in the following details in table BOOKING. a. Customer 1 booking package 1, 3 and 4 b. Customer 2 booking package 2 c. Customer 3 booking package 5 d. Customer 4 booking package 1, 3, 4 and 5 e. Customer 5 booking package 3, 4 and 5

8. Create two (2) report based on the following: a. Travel package booked by customer no 4 (Customer ID, Name, Date Booking, Package ID, Destination, Duration and Depart) b. Report on package 5 indicated customer ID and customer Name

9. Once you complete, rename the database as Tour Booking System_{your name}