ICT PRACTICAL 12: KCSE 2013 DATABASE QUESTION|TABLES, FORMS, QUERIES, RELATIONSHIPS AND REPORTS

Get pdf
drive.google.com/file/d/19VGv...
This video contains all possible skills tested in ICT exams.
watch it and you'll be done with 90% of Database skills
FULL TABLE OF CONTENTS
0:00 INTRODUCTION TO DATABASE
0:30 CREATING MS ACCESS DATABASE FILE
0:50 CREATING TABLES IN MS ACCESS DATABASE
1:10 SETTING PRIMARY KEY IN A TABLE
1:30 FORMING RELATIONSHIP BETWEEN TABLES
2:05 CREATING FORMS USING FORM WIZARD
2:30 USING A FORM TO ENTER DATA INTO THE TABLES
2:50 SOLVING AN ERROR: YOU CAN NOT ADD OR CHANGE A RECORD BECAUSE A RELATED RECORD IS REQUIRED IN TABLE
3:20 COMPUTING AGE USING A QUERY
4:50 SELECT QUERY TO SELECT DETAILS OF A PATIENT ADDRESSED BY A DOCTOR.
5:45 HIDE UNWANTED FIELDS IN QUERY
6:25 CREATING A REPORT USING REPORT WIZARD
6:25 APPLYING GROUPING IN A REPORT
6:50 RENAMING REPORT TITLE
7:00 Applying formulae in a report. count function for subtotals..
7:50 Printing tables, queries and forms and reports

[@lifeaskiki]

Thank you! mwalimu

[@ictkenyar]

Welcome