ICT PRACTICAL 17: DEPARTMENT DATABASE IN PURE SQL |TABLES, FORMS, QUERIES, RELATIONSHIPS AND REPORTS

Unlock the power of SQL in our tutorial! From CREATE TABLE to SELECT QUERY, delve into database fundamentals. Plus, discover form and report design in Access for comprehensive learning. Dive into SQL mastery now!
#queries #reports #sql #tables
Get PDF from
docs.google.com/document/d/1Q...
TABLE OF CONTENTS
0:00 Introduction
0:45 Create a data base called personnel and create a table named Department. CREATE DATABASE query, CREATE TABLE QUERY syntax.
2:45 INSERT INTO QUERY syntax
Create queries to determine (save each query using the alphabet numbers below)
6:00 Number of people with basic salary greater than 32,000=
8:10 Number of people with basic salary less than 45,000= AND come from computer department .
9:20 Names of people who are either married or single
11:05 Those whose salary fall between 25,000/= and 50,000=
12:25 Those whose name begin with letter M or end in letter S
14:25 Create a query to compute the new salary if there is an increment of basic pay by 50%
15:45 Filter using query those who earn above 33000/= and aged between 39 and 70
17:05 Create a form using form wizard using the Department table above.
17:35 Create a form in design view using the departmental table above on the form calculate the total basic salary for the whole table, add current date and time on the form header
21:45 Create a report using report design

[@user-ql3jq9ch8v]

Good work

[@ictkenyar]

Thank you.

[@paulmweu-su3im]

Good educative content

[@ictkenyar]

Thank you. Feel free to visit more on Word, Excel, etc and learn more

[@user-oi3th4mg4s]

Thanks alot🙏

[@carorinenjeri4611]

❤❤

[@ictkenyar]

Thank you.

[@user-zg8ez4ng8g]

Awesome work my brother....the sky is the limit

[@ictkenyar]

Thank you Bro

[@RuthKadzo-ud4zj]

Great work

[@ictkenyar]

Thank you. Dive in for more

[@XlynPatryq]

Legit💥💥

[@ictkenyar]

Thank you

[@ictkenyar]

Thank you for choosin this video. Do you want to try the questions by yourself? Get them here th-cam.com/users/redirect?event=video_description&redir_token=QUFFLUhqbmNXcVpvZEdoUzhaR2plZW9wWFAyekY1VjZDd3xBQ3Jtc0tsWTZ1MzZwTmlTYVQ2eGpFd3VkeENOTWpoYzRpS0NnQy03bjN1eHhoRnN5NDYzRnpoRFNHbkhjT0lTY0dsSGhCQnFoZEp6dEpIRk5vVG9ZSHVfQ1FRdGl0Y084N3k0LWVuYkcwZGdnWjNCQ0xFS0sxYw&q=https%3A%2F%2Fdocs.google.com%2Fdocument%2Fd%2F1QRB50wA5HBPKQbSGE5MhmFSUHvXc_oLu%2Fedit%3Fusp%3Ddrivesdk%26ouid%3D103080780577623956852%26rtpof%3Dtrue%26sd%3Dtrue&v=ER-WpATwfH4