WorksheetsDatabases
Total questions: 10
Worksheet time: 5mins
Which of the following is a piece of software used to create databases?
Google Chrome
Microsoft Office PowerPoint
Microsoft Office Access
What term describes a personalised letter which can be sent to customers of a supermarket?
Report
Mail merge
Macro
Which of the following is an advantage to paper-based databases?
It is easy to add or amend records.
You do not need any training on how to use the database.
Data can be sorted and re-sorted easily.
Thinking of data, information and knowledge - which of the following is an example of information?
The average men's shoe size is nine.
9
If you are to open a shoe shop, you must stock plenty of size nine shoes.
Which of the following holds a single piece of data?
Table
Record
Field
Which field would be inappropriate in a database of countries?
Continent
Population
First Name
What is the correct definition of primary key?
The first field in a table.
A field that contains unique data in each record.
The field which we will use to search with.
What database feature checks to see if data meets certain rules when entered to a table?
Table
Query
Validation
Which validation rule would you use to limit what a user can enter to only a few options, e.g. male or female?
List Check
Presence check
Range check
Which of the following is NOT true of databases?
You can store large amounts of data.
You have to use a computer.
You can search the data.
