S2 Databases

What is the best definition for a database?

• A table

• A place to store information

• An organised collection of information

• A collection of fields

A ________ holds a single item of data.

• Field

• File

• Table

• Record

A ________ is composed of all the data items about one person or thing.

• Field

• File

• Table

• Record

Which view do you use to set up your tables?

• Query view

• Design view

• SQL view

• Datasheet view

Which view would you use to enter data into your database table?

• Design view

• Query view

• Datasheet view

• SQL view

Which data type would be the best for a post code?

• Text

• Autonumber

• Number

• None of these

Which data type would be the best for a phone number?

• Text

• Autonumber

• Number

• None of these

Which data type would be the best for a price?

• Currency

• Autonumber

• Number

• None of these

To put data in order in a database, you would

• Search

• Sort

• use a form

• design a table.

Netflix is an example of an online computerised database

• True

• False