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. [2 Marks]

 

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. [ 2 Marks]

 

Task 3: Assign the primary key for each table. [1 Mark]

 

Task 4: Create relationship between the tables. [2 marks]

 

Task 5: Create car query to display: car no, company name price where the price is >5000. [3 marks]

 

Task 6: Save the query under the name "price". [1 mark]

 

Task 7: Add the suitable criteria to display license no, name to people who live in Dubai. [3 marks]

 

Task 8: Save the query under the name "Dubai city" [1 mark]

 

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". [3 marks]

 

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". [2 marks]

SophiaPretty

(5)

Status NEW Posted 04 Dec 2017 01:12 PM My Price 8.00

----------- -----------  ----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------Tha-----------nk -----------you----------- fo-----------r y-----------our----------- in-----------ter-----------est----------- an-----------d b-----------uyi-----------ng -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll -----------be -----------qui-----------ckl-----------y

Not Rated(0)

• Buy Answer