WorksheetsLesson 1 Database Basics
Total questions: 18
Worksheet time: 11mins
What is a database?
A piece of software to do calculations
A device to load information onto the computer.
A structured collection of records
A calculator
A sports club needs to store information about each individual member. The information about each member is called a:
Field
File
Table
Record
A school needs to store information about each individual student. The information about each student is called a:
Field
File
Table
Record
A car showroom store information about each car they sell. The individual items of data about each car is called a:
Field
File
Table
Record
A health club wants to find all the members who use the club 3 days or more a week. What will they put in the query in the 'days' query criteria?
>3
<3
<=3
>=3
3
An estate agent wants to search for all houses with 2 bedrooms. What will they put in the query in the 'bedrooms' query criteria?
>2
<2
<=2
>=2
2
A scout company have a database with records of all the scouts. They want a list of all scouts who are under 15 and their achievements. What would they use to search the data?
Report
Table
Query
Sort
What data type would be used to store the following item code: 0024
Text
Numeric
Calculated
Boolean
What data type would be used to store the following postcode: IM1 4HP
Text
Numeric
Calculated
Boolean
The school wants to sort the data in alphabetical order by staff Surname. How will they sort it?
Ascending order
Descending order
Text, Integer, Currency, Boolean and Date/Time are all examples of...
Data Types
Filters
Sorts
Validations
Text, Integer, Currency, Boolean and Date/Time are all examples of...
(a)
A unique identifying field is known as a (a)
The four main objects of a database consist of:
form, table, query, report
filter, table, database, query
form, data type, record, query
form, record, field, report
In a database, a collection of related records is typically referred to as a:
Field
File
Table
Record
What is the most suitable primary key in this database?
(a)
