Year 10 Access Quiz

What is a Key field?

• A data item which uniquely identifies a record in a table.

• A data item which points to another record in a related table.

• A link between two tables.

• A single collection of data.

$789.00 is an example of which data type

• Text

• Currency

• Boolean

• Decimal

A search using the criteria =A*

• Will find any word with an A in it

• Words starting with an A

• Nothing

What field type would be used to store the following data "0125-5221"

• Text

• Number

• Time/Date

What does the data values from a field need to be in order for it to be named as a Primary Key

• Values need to be number

• Values need to be even

• Values need to be unique

• Values need to be a combination of letters and numbers

Which field is the best fit to be a primary key?

• FilmName

• FilmID

• AverageRating

• Director

How is the table being sorted?

• YearReleased Ascending

• AverageRating Descending

• AverageRating Ascending

• FilmName Ascending

Film title is a suitable Primary key, true or false?

• True
• False

A field is...?

• A specific piece of information in a database.

• A category of data in a database, eg First Name or Date of Birth.

• A large, open area usually covered in grass.

• A box in a database.

Which is not an advantage for using computer based databases?

• Can easily sort data into order e.g. alphabetic

• Can easily make back-up copies

• If there is a power-cut, you can’t use it

• Can import or export data to/from other packages