Databases

HideShow resource information
  • Created by: mobyward
  • Created on: 09-05-16 10:07
Database
an organised collection of data (held in records)
1 of 21
Fields
categories of data in a record, e.g names, addresses, phone numbers
2 of 21
unique identifier
a field containing data that is different for each record e.s. ID number
3 of 21
difference between databases and spreadsheets?
databases: better tools for searching and displaying data; search for data using 'queries'; create 'reports' showing only data needed.
4 of 21
query
search for particular data in a database; find records that fit certain criteria
5 of 21
report
create a list of certain data selected from a database
6 of 21
Access
system for setting up a database
7 of 21
setting up fields
done in 'design view'
8 of 21
primary key
the unique identifier
9 of 21
validation rule
a rule to limit what data goes in a field e.g. #01/01/2000#
10 of 21
importing data
use the extenal data tab
11 of 21
sorting
puts records in order
12 of 21
names ascending
A - z
13 of 21
names descending
Z - A
14 of 21
numbers ascending
small to large
15 of 21
numbers descending
large to small
16 of 21
dates ascending
oldest to newest
17 of 21
dates descending
newest to oldest
18 of 21
filtering
allows you to find records that contain certain bits of data
19 of 21
query design - how to search for a word or letter
type it within double quotes
20 of 21
to bring up results on a query
press the 'run' button on the 'query tools' tab
21 of 21

Other cards in this set

Card 2

Front

categories of data in a record, e.g names, addresses, phone numbers

Back

Fields

Card 3

Front

a field containing data that is different for each record e.s. ID number

Back

Preview of the back of card 3

Card 4

Front

databases: better tools for searching and displaying data; search for data using 'queries'; create 'reports' showing only data needed.

Back

Preview of the back of card 4

Card 5

Front

search for particular data in a database; find records that fit certain criteria

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »