Task 1: By using Ms. Office Excel create two Work sheets and enter the columns below in each sheet and then insert ten records below these columns.
Sheet 1: Car Number, Car Model, Company, Color, Price, License Number
Sheet 2:License, Number, Name, Address, Age
Task 2 : Create a Database file and name it [Car Info]. Then, Import MS Excel sheets into as an MS Access table.
Task 3: Assign the primary key for each table.
Task 4: Create relationship between the tables.
Task 5: Create car query to display: car no, company name price where the price is >5000.
Task 6: Save the query under the name "price".
Task 7: Add the suitable criteria to display license no, name to people who live in Dubai.
Task 8: Save the query under the name "Dubai city"
Task 9: Create a form by using form wizard that is based on the car table to display all car details, save it under the name "car info".
Task 10: Create a report by using report wizard that is based on the owner table to display all car details, save it under the name "Owner info".