1.9 - Information Handling (Databases) (WJEC)

HideShow resource information
  • Created by: daynayume
  • Created on: 17-05-16 18:13
What are Databases used for?
To store and organise large amounts of data.
1 of 21
What are queries?
You can use queries to search databases.
2 of 21
What form are queries written in?
Field-Operator-Criteria
3 of 21
What are the different Operators?
=, , >,
4 of 21
Name the different data types used in databases?
Number, Text, Date, Time, Currency, Boolean, Lists, Picture, Sound, Video.
5 of 21
What are Number data types?
Data that stores numbers only.
6 of 21
What are Text data types?
Data that stores letters, numbers and spaces.
7 of 21
What are Date data types?
Data that allows only dates to be entered.
8 of 21
What are Time data types?
Data that allows only times to be entered.
9 of 21
What are Currency data types?
Data that must begin with a currency sign like $ or £.
10 of 21
What are Boolean data types?
Used where only two choices are available. E.g. Yes/No, True/False.
11 of 21
What are Lists data types?
Used where the user is given a list of choices they can pick from a drop-down menu.
12 of 21
What are Picture data types?
Pictures of products or people.
13 of 21
What are Sound data types?
Used to organise sound or music.
14 of 21
What are Video data types?
Organises video files.
15 of 21
What are Fields?
Fields are columns of a particular item of data.
16 of 21
What are Records?
Records are rows - a collection of fields.
17 of 21
What are Files/Tables?
A collection of records.
18 of 21
What Key Fields?
Fields that are unique, such as car registration numbers and national insurance numbers.
19 of 21
What are Reports?
Reports is a way to present information gathered from searchers or queries.
20 of 21
What should reports contain?
Relevant information that is appropriately formatted, a sensible title data and page numbering, Calculated fields.
21 of 21

Other cards in this set

Card 2

Front

What are queries?

Back

You can use queries to search databases.

Card 3

Front

What form are queries written in?

Back

Preview of the front of card 3

Card 4

Front

What are the different Operators?

Back

Preview of the front of card 4

Card 5

Front

Name the different data types used in databases?

Back

Preview of the front 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 »