Other pages in this set

Page 2

Preview of page 2

Here's a taster:

Suggested Notes Plan
What is a database?
What is it used for?
How can we capture data to store in
databases?
How can we prevent data capture errors?…read more

Page 3

Preview of page 3

Here's a taster:

What is a database?
A database is a collection of data held
together in an organised and logical way
± Eg address books
± Filing cabinets
± Even the yellow pages
These are all paper based databases
Stored everything in a logical way (mostly
alphabetic)…read more

Page 4

Preview of page 4

Here's a taster:

Computer based databases
Also store data in a logical and ordered fashion
BUT the data is stored on a computer system (not
paper)
± When you search Google you are not actually
searching the Internet you are searching Googles
database of the Internet
± Electoral register
± Police criminal database (most government databases
are computerised see http://data.gov.…read more

Page 5

Preview of page 5

Here's a taster:

Advantages of Computerised
databases
Hold vast amounts of data
Can find data in a computerised system very quickly
Can find data based on specific criteria (all customers
who live in OX3 postcode)
Can analyse data fairly easily
Can sort data on ascending or descending using
multiple criteria
Can easily update or delete a record
Records are stored safely (as long as database is backed
up)
Database can be kept secure by use of passwords…read more

Page 6

Preview of page 6

Here's a taster:

How do databases work
Databases store data in tables which contain
fields and records
How many fields and how many records in this
table?
StudentID FirstName LastName DOB
CA345 Ben Smith 23/4/95
CB567 John Deer 12/6/95
CC979 Sally Pine 2/8/95
CD455 Joseph Rolf 1/3/95
CE233 Richard Dawkins 10/10/95…read more

Page 7

Preview of page 7

Here's a taster:

Activity 1
Use Microsoft Access to setup a basic
database
± Database must store details on your DVD
collection
± Create a drop down box using the lookup wizard
within one of your fields…read more

Page 8

Preview of page 8

Here's a taster:

Entering Data into a Database
Initially you would have entered data using a
table
What was it like entering the data?
If you were entering data into a database
which someone else had built would you
find it easy?…read more

Page 9

Preview of page 9

Here's a taster:

This screenshot shows the signup
screen for Hotmail.…read more

Page 10

Preview of page 10

Here's a taster:

Capturing Data
When you enter data into a database it is
called capturing data
There are two ways to enter data
± Automatic (eg scanning a product at a checkout)
± Manual (typing data about a product into the till)
We will be focussing on Manual data entry
which uses Forms…read more

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »