Database Lesson 9 | Using Query Wizards, Form and Report Formatting Techniques

Create a database for Jett Car Hire Ltd saved as your name and personal number and carry out the following tasks.
Instructions:
(a). Design a table saved as drivers to hold the above data.
(b). Design a tabular form having a sky-blue background colour, footer of your name you will use to populate the table. Save the form as Data Entry.
(c). Design three queries that will return workers who:
(i). have no remarks against their records. Save the query as Not Appraised.
(ii). drive Car_Type that is not a Wish. Save the query as Not Wish.
(iii). celebrate birth day in the month of January. Save the query as Born Jan.
(d). Create a report to return drivers who drive a Premio Car_Type. Save the report as Premio.
(e) Create a report having all the records on one sheet. Save the report as All.
The report should have the following details:
(i). A good red line boarder.
(ii). Group and sort your records in order of car_type
(iii). Add a title: MOTO VEHICLES INFORMATION REPORT size 24
(f) Add an image Motor.png on your report to serve as a logo
(g) Print your queries and report only.


More Video Lessons On Database Access By Kakuru Benard
Lesson 1: https://youtu.be/dJaCGMqGJvc
Lesson 2: https://youtu.be/Y3W9DVcgEPU
Lesson 3: https://youtu.be/qNnvdX1ibRk
Lesson 4: https://youtu.be/41UWvApgg58
Lesson 5: https://youtu.be/REQESvACSSs
Lesson 6: https://youtu.be/RoXjFYqwcSo
Lesson 7: https://youtu.be/NIjSEl5Kopw
Lesson 8: https://youtu.be/FUdtRE4fKf8
Lesson 9: https://youtu.be/n5PDGCFKyLM
Wakisha 2023: https://youtu.be/U5-oYEIUn5o
UNEB 2023 Paper 2: https://youtu.be/jAgtwfS6OC8
UNEB 2023 Paper 3: https://youtu.be/E2bwpS-Gwgw
UNEB 2023 Paper 1: https://youtu.be/GWRXjetAjpg