WorksheetsAccess
Total questions: 15
Worksheet time: 9mins
$789.00 is an example of which data type
Text
Currency
Boolean
Decimal
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.
What is a Foreign Key?
A link between two tables.
A data type indicating a whole number.
A data item which points to another record in a related table.
A single collection of data.
An example of verification is...
Proof reading
Look up lists
Length checks
Check digit
What field type would be used to store the following data "0125-5221"
Text
Number
Time/Date
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
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.
The HD field is using the data type Boolean
True
False
Databases have a structure that has
A file which is made up of records and each record has a number of fields
A table which is the file. It has records and fields in the table.
Multiple tables each with their own file, records and fields
