Database

HideShow resource information
What is a FIELD?
Column heading
1 of 16
What is a RECORD?
A row, holding data
2 of 16
What is a TABLE?
Collection of records
3 of 16
What is a KEY FIELD?
Unique Identifier, that individually identifies a record.
4 of 16
What is a database with more than one table known as?
Relational database
5 of 16
What does a QUERY icon do?
Asks questions, extracts data and performs searches
6 of 16
What does a TABLE icon do?
Creates a database, to set up fields and validations.
7 of 16
What does a REPORT icon do?
Improving the presentation the output database and gives a neat/professional print
8 of 16
What does the software use to make a link/relationship between tables?
Foreign key
9 of 16
What is the data type for 'first name'?
Text
10 of 16
What is the data type for 'surname'?
Text
11 of 16
What is the data type for 'mobile number'?
Text
12 of 16
What is the data type for 'gender'?
Look up list
13 of 16
What is the data type for 'date of birth'?
Date/Time
14 of 16
Name two additional data types.
Currency and Autonumber
15 of 16
What are the benefits of encoding data on a database?
Less to type in, fewer chance of getting a typing error because you are typing less. Also it takes up less storage, for there is less data needed.
16 of 16

Other cards in this set

Card 2

Front

A row, holding data

Back

What is a RECORD?

Card 3

Front

Collection of records

Back

Preview of the back of card 3

Card 4

Front

Unique Identifier, that individually identifies a record.

Back

Preview of the back of card 4

Card 5

Front

Relational database

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 Spreadsheets and Databases resources »