Number 1
Answers Loading…..
Number 2
(2)
Note; PLS INSERT YOUR DETAILS IN THE SPACE PROVIDED AND REQUEST FOR A GOOD TECHNICIAN OR A GOOD INSTRUCTOR TO GUIDE YOU, Before you start, create your folder on the Desktop named “WAEC – [YOUR INDEX NUMBER]” and save ALL work there. Delete the folder after printing and submit all printouts to the supervisor.
(2a)
Bold the heading of each slide
– Click each slide title → Select the text → Press Ctrl+B
(2b)
Font sizes
– (i) Select each heading → Change font size to 16pt
– (ii) Select other texts (bullet points) → Change font size to 12pt
(2c)
Apply:
(i) Background for each slide:
– Right-click slide → Format Background
– Choose a color/design of your choice → Apply to each slide individually
(ii) Bullet numbering for each point:
– Select the bullet points on each slide
– Home tab → Paragraph group → Click Numbering button
(2d)
Footer with full name and index number
– Go to Insert → Header & Footer
– Check Footer → Type your full name and index number → Apply to All
(2e)
Save with your full name
– Press Ctrl+S → Save as your full name in your WAEC folder
(2f)
Print all slides on one sheet
– Press Ctrl+P
– Under Settings → Slides: change to 4 Slides Horizontal (or “6 slides per page”)
– Print and submit
Number 3
(3)
Note; Before you start, create your folder on the Desktop named “WAEC – [YOUR INDEX NUMBER]” and save ALL work there. Delete the folder after printing and submit all printouts to the supervisor.
(3a)
Create a database called PERSONNEL
— Open Microsoft Access
— Click Blank Database
— Name it: PERSONNEL
— Save in your WAEC folder → Click Create
(3b)
Create Table A and Table B
TABLE A:
– Go to Create → Table Design
– Add fields:
Field Name Data Type
DEPTID Number (Primary Key)
DEPTNAME Short Text
– Enter the data:
DEPTID DEPTNAME
1 Human Resource
2 Store
3 Library
4 Accounts
5 Works
TABLE B:
– Create another table in Design View
– Add fields:
Field Name Data Type
STAFFID Short Text (Primary Key)
DEPTID Number
LASTNAME Short Text
FIRSTNAME Short Text
MSTATUS Short Text
PHONENO Short Text
– Enter the data:
STAFFID DEPTID LASTNAME FIRSTNAME MSTATUS PHONENO
S001 5 Brudena Chimahe Single 30879900234
S004 1 Anibatar Oguavide Married 32976845600
S007 3 Okuntunde Danfulami Married 34019876765
S005 1 Emefunram Alfred Single 31896745647
S002 1 Agdaken Julius Single 27965806214
S009 4 Otodoli Amrat Single 29675454366
S008 2 Sulmine Olokite Married 33221097677
S012 4 Agbenkun Okorodan Single 32564098615
(3ci)
Set Primary Keys;
For Table A:
— Open Table A in Design View
— Click on DEPTID field
— Click Primary Key button (key icon) on the toolbar
For Table B:
— Open Table B in Design View
— Click on STAFFID field
— Click Primary Key button
(3cii)
Establish relationship between Table A and Table B
— Go to Database Tools → Relationships
— Add both Table A and Table B
— Drag DEPTID from Table A to DEPTID in Table B
— Check Enforce Referential Integrity → Click Create
(3ciii)
-Go to Create → Query Design
-Add both Table A and Table B
-Add these fields to the query grid:
– LASTNAME (from Table B)
– FIRSTNAME (from Table B)
– DEPTNAME (from Table A)
– PHONENO (from Table B)
–In the Sort row under DEPTNAME, select Ascending
— Save the query as: “List of Employee by Departments”
(3civ)
-Open the saved query → Click Run (! button)
-To generate report:
-Go to Create → Report Wizard
-Select the query “List of Employee by Departments”
– Follow the wizard → Finish
– The report will display employees sorted by department
(3d)
-In the report Design View
-Go to View → Report Footer
-Add a Text Box → Type your full name and index number
(3e)
-Ctrl+S → Save report with your full name
-Ctrl+P → Print
(3f)
Submit printout to supervisor
Number 4
Answers Loading…..
Number 5
Answers Loading…..
Number 6
Answers Loading…..