Trendigt
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
Designing a brochure is just easy to use templates
On the Start page that appears when you open Publisher, click Brochure (You can get to the Start page anytime by clicking File -New). Search for Brochures.
or design from scratch. In This video, we shall design from scratch.
Below is the Question
Use Desktop publishing software to prepare a brochure for JK Computer Center with the following details.
Company Name: JK Computer Center
Motto: Computer skills for better standards.
Location: Seventh Street, Jinja Road
Address: P.O Box 38, Kampala
Telephone Contact: 0775610762, 0701517817, 0758767895
E-mail Address: jkcomputercenter@gmail.com
Website: https://www.jkcomputer.net
Introduction: JK Computer Center is a home of computer services and accessories. We have customer centered service providers. Please come and enjoy our excellent services.
Services offered: Internet services, Printing, Photocopying, Scanning, Binding, Mobile Money, Computer and phone repair, Computer and phone accessories, Airtime selling, Telecommunications services, Report writing, Typing and Computer lessons.
(a) Divide each page into three panels
(b) Enter the given details in suitable panels
(c) Use appropriate images, fonts and background in the brochure.
(d) Add your name and personal number as footer
(e) Save your brochure as your name and personal number.
(f) Print your work.
More Video Lessons on Desktop Publishing By Kakuru Benard
Lesson 1: https://youtu.be/QRzLXw7gx_o
Lesson 2: https://youtu.be/CbLR6mi9hOk
Lesson 3: https://youtu.be/KGXxogpB6B0
Lesson 4: https://youtu.be/dzJP70T1poc
Lesson 5: https://youtu.be/xNMz5tfEkW0
Lesson 6: https://youtu.be/F85pzjaQYgI
Lesson 7: https://youtu.be/12WPjN92Sns
Lesson 8: https://youtu.be/L_EZbCC05tc
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
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
Find out more about Dr Nick White's ANU Supramolecular Chemistry Group at https://nwhitegroup.com.
For practice questions after each video, register an account to access our free senior science courses at https://courses.meristem.anu.edu.au. Teachers can access free lesson plans and in-class activities by joining our teacher community via http://meristem.anu.edu.au/ind....ex.php/new-to-merist
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
The table below shows the medical records of a certain clinic
(a) Create a database called Medical Details.
(b) Design a table with appropriate data types in the design view called Patients.
(c) Enter the given data in the table.
(d) Assign a UGX symbol to the treatment fee field and change the date to medium format.
(e) Create a query to display all the details of patients who come from either Jinja or Busia. Save it as Eastern Patients.
(f) Create a query to display all the details that were not diagnosed with Malaria. Save it as No Malaria.
(g) Create a form from the table and save it as Main form
(h) If the Government pays 40% of the treatment fee for all patients, create a query to calculate the discounted fee. Put only Fname, DoB, Diagnosis, and Treatment Fee on the display. Save it as a Discounted fee.
(i) Create a report to display the information in the discounted fee query. Save it as a Discounted Report.
Create a tabular form from the discounted fee query showing all details and save it as a Patient’s form.
(j) Print your work.
#microsoft #microsoftaccess #database
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
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
