NEW
Font size
WorksheetsDatabases
Total questions: 25
Worksheet time: 13mins
Which of the following holds a single piece of data?
Table
Record
Field
Which of the following is a piece of software used to create databases?
Google Chrome
Microsoft Office PowerPoint
Microsoft Office Access
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.
Computer databases allow us to organise,___________, and sort data.
Measure
Search
Data
Field
What would you search for to answer this question: 'How many males under ten years old were on board the Titanic?'
Name and Age
Gender and Class
Gender or Age
Gender and Age
What is a command sent to a database?
Query
Order
Reciept
Direct Access
What is the name of the icon that you need to click on to create the database?
Create view
Datasheet View
Design View
Maths View
When creating our database, we need to create the FIELD and specify what else?
Text type
Number Type
Image Type
Data Type
TRUE or FALSE - Access is better than Excel for creating a database?
TRUE
FALSE
What do these 2 icons do in Access?
Sort
Filter
Delete
What does this icon do in Access?
Sort
Filter
Delete
What has been highlighted in this image of a database ?
A record
A table
A field
A datasheet
A database is used to
Calculate figures
Store data in a logical order
Layout pages attractively
Present material using animations
The best data type to choose for a postcode would be:
Number
Date/Time
Text
Currency
To find a particular set of data in a database you would use a:
Table
Form
Query
Report
Text, Number and Date/Time are all examples of...
Data Types
Filters
Sorts
Validations
What do you use to enter data into a database when not using a table?
Query
Form
Record
Field
What do you call the professional way of showing the results of a query?
Table
Form
Record
Report
Which view do you use when creating how your Form looks?
Design
Artist
Birds-Eye
Drawing
How many records are shown in the database file?
3
4
5
6
How many fields are shown in the database?
3
4
5
6
