ICT
FEATURES OF FIELD NAMES
1) Field names must be short n meaningful (concise)
2) Filed name must not contain spaces
NB
A data entry form is used to add data to your table.
Data view form is to see, view or display data on the table.
FEATURES OF A GOOD FORM
It must have a title
It must have a text box
Drop down / selection box
Check box
Radio button
Navigational aids
Next button
Previous button
New record
Last record
First record
Search / find box
Form control buttons
Close /exit
Minimize
Maximize
Should not be cluttered
RELATIONSHIP
Relationship are used to establish links among tables in a database.
TYPESS
1 to 1 relationship,
1 to many relationship
Many to many relationship
When is one to many relationship created?
When you link a primary key in table A to a foreign key in table B.
Query is used to ask the computer questions.
How to create a report?
NB queries are meant for technical uses reports are used for end users.
(*) is anything that follows; eg, T* means T and anything that comes after T, *E means
anything that comes before E and E.
STEPS:
1. Go to create on the menu
2. Use query wizard
3. Click simple query
4. Click on the table you are choosing then take it to the other side
5. Add the question number
6. Go to design view
7. Use the layout view to adjust the report
A derived field or calculated field is a field calculated or derived from an existing
field.
Hw/ s21_qp_21 -Task 3 (15 – 20)
When you want something to appear at the top of every page, u use a header.
When you want something to appear at the bottom of every page
Hw/ continue s14_qp_21 (1 – 29)
ICT (Mr Vroom)
Areas; [Audience n communication(stop b4 Wikipedia) ]
Characteristics of spam/ discuss spam
Know at least 5 differences between Internet n the www
The World Wide Web is usually mistaken for the Internet, but there r some differences
www is a collection of web pages/ info pages, it's part of the internet
www is accessed through the internet
it is a service on the internet
The internet is a global network of interconnecting networks
The internet is an infrastructure
A skl is planning to set up a student work files area, the skl is considering allowing students to log into it
either using the skls internet or intranet. Discuss the disad n adv as to y they shld use intranet rather
than internet. [8]
Adv
Intranet is policed or controlled by the skl
It is more secure as it needs a password
It only contains relevant info
Intranets resides behind the firewall, data is more secure
Messages target the correct student
Better bandwidth
Access from external ppl r barred(blocked)
Disadv
More expensive to set up
More time consuming to set up
More time spent on administration
May only be viewed within the skl
More expensive to maintain
Will not be able to access skl files at home
The skl will need to provide more computers across the skl so tat students can access
Explain the purpose of an intranet [3]
To facilitate communication or collaboration between workers, students or teachers.
Private or confidential data stays within a company, organisation or skl.
Make it easier to access company-specific applications
Restrict/ Regulate a
access to certain sites of the internet
Restrict access for certain ppl/employees
To store relevant or up-to-date info bout the organization available to workers.
Graph and chart (Mr Owusu)
When your asked to compare percentage values, you use pie charts.
It is used to compare parts of a whole
Line graphs are for trend analysis (increase in salary structures etc)
Steps in creating a chart:
Select or highlight numeric values
From the menu bar click on insert, locate the chart
Select the appropriate chart
Right click n go to selelct data
Features of a chart
A good chart must have an appropriate title
A chart must have axis titles
A chart may have a legend
There are two types of notes:
Presenter notes
Audience notes
Audience notes are the slides content.
Presenter notes are the notes available to the presenter. It is the notes that serves as a guide to
the presenter.
Animations n transitions
Transitions are effects that are applied from one slide to another slide. It shows how one slide
exits and how another enters.
*To show evidence of transitions, screenshot the stars at the top right of the slides.
Animations describes the movement of objects on a slide.
*To show evidence for animations, screenshot the numbers beside the animated elements.
Questions
(a) Tawara school uses both the internet n a intranet. Describe 4 disadv to students of using
the internet compared with an intranet.
(b) Email is a service provided by the internet for each of the following problems associated
with email, describe methods of protecting your data.
i. Spam – don’t reply to spam emails, use a spam email filter, block images
in html messages as these r used as web beacons, unclick check boxes
when buying items online,
ii. Viruses – scan emails and attachments before opening, do not download
attachments from unknown sources, run up to date antivirus software,
do not open spam emails.
2 uses of a company intranet
SPREADSHEET
A work sheet is a single spreadsheet document
Work book is a collection of work sheet in one file name
A cell is the area formed when a row intersects with a column on a spreadsheet
The cell is identified by the column letter n row no.
When text data is stored in a cell, its called a label
Right click n look for define name
