Font size
WorksheetsDatabase Retrieval
Total questions: 20
Worksheet time: 22mins
What are databases mainly used for?
To store archived data
To store and organise data
To analyse data
Which of the following statements best defines the word 'database'?
A database is a collection of data or information which is stored in a logical and structured way
A database is a collection of statistics stored only for computers.
A database does not collect data or information.
Why would you create a primary key?
To make each record in a database unique
To make each field in a database unique
To make each query in a database unique
Which of the following defines the term 'field' in relation to databases?
A field is all of the information about one person or one thing
A field is the collection of all the database records on one topic or subject
A field is one type or piece of information
Which of the following defines the term 'table/file' in relation to databases?
A table is all of the information about one person or one thing
A table is one type or piece of information
A table is the collection of all the database records on one topic or subject
Why would you use a database?
To store information
To retrieve information
To sort through information
All of the above
The process of arranging query results in a specified order such as alphabetical order is what?
Query
Sort
Filter
Database search
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
In a database, all the information about one person or thing is called a
Worksheet
Presentation
Record
File
In a database, data is stored in
Queries
Forms
Reports
Tables
The software that we use to create a database is
Microsoft Publisher
Microsoft Word
Microsoft Excel
Microsoft Access
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
Records in a table can be updated any time.
True
False
Which object would you create to share the data from your database with others?
Form
Report
Query
Table
Access offers different views of objects. Which view do you use to edit a table?
Datasheet View
Design View
Table View
Print View
These sort, filter, and summarize data.
Tables
Forms
Queries
Reports
What is ascending order?
Moving down the alphabet from Z to A.
To find a specific item in the table.
Moving up the alphabet from A to Z
sorting
