S3 Databases Knowledge Check

To store information

To store information in an organised way

To look at information on a topic

To have the information in all one place

The whole table of information

A little piece of information like Pupil Name or Hair Colour

A collection of information on one object, like a person or a movie

Big green thing

Each value is a number

Each value is a combination of letters and numbers

Each value is unique to each record

Each value is either Yes or No

Excel

Word

Powerpoint

Access

Text

Date/Time

Number

Character

Number

Text

Boolean

Date

SELECT FROM WHERE

FROM SELECT WHERE

WHERE SELECT FROM

SELECT WHERE FROM

Selects the answers from the table

Selects the correct records

Selects the fields we want to display

Selects the table

Indicates the table we want the information from

Indicates the fields we want from the table

Indicates the records from the table

Indicates we want to find some information

The search condition, what we're searching for

Where the information is correct

What fields we want to show

Which table we are getting the information from