NEW
Font size
WorksheetsS2 Databases
Total questions: 15
Worksheet time: 8mins
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
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
To put data in order in a database, you would
Search
Sort
use a form
design a table.
Netflix is an example of an online computerised database
True
False
Which of the following is an example of a Number field?
44
Fourty Four
Four Four
£0.44
I can create a database using:
Microsoft Word
Microsoft Excel
Microsoft Access
Microsoft Outlook
Searching a computerised database is faster than a manual database:
True
False
Which of the following is an example of Short Text?
12/18/2019
Databases
£2.99
0
A school has a database, and they want to add an e-mail address to all pupils. They should:
Add a new field
Add a new record
Add a new file
Add a new database
