BGE 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

A ________ is composed of all of the columns and rows.

• 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

If you wanted to search a database, you would use...

• A query

• Datasheet view

• A form

• None of these