NEW
Font size
WorksheetsS3 Databases
Total questions: 34
Worksheet time: 50mins
The software that we would use to create a database is
Microsoft Publisher
Microsoft Excel
Microsoft Word
Microsoft Access
In a database, data is stored in
Tables
Forms
Reports
Queries
View that shows the “background” or working of a table
design view
datasheet view
form view
layout view
In a database table, rows are called __________
Fields
Records
Primary Keys
Foreign Keys
Forms, queries, and reports are created based on the data in the _________
Forms
Tables
Reports
Spreadsheets
What is a suitable data type for usage?
Text
Number
Currency
Yes/No
Which data type would be most suitable for the 'Age' field?
Currency
Date & Time
Number
Memo
What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?
Query
Form
Report
What is a database?
A physical storage space
A collection of data stored in a computer
A type of software
A method of data analysis
Once you have named the field in a database, what is the next step?
Type your information
Select an appropriate data type
Select relevant information
Type your name in the heading
What does ordering in a database help with?
Finding specific data
Visual appeal
Increasing data quantity
Reducing data size
What is the advantage of using a computer database over a paper database?
Easier to lose
Harder to access
More colorful
Less physical space needed
What can you use to find data that meets specific conditions in a database?
Query
Quiz
Finding
Copying
Which of the following can you NOT add a footer to?
Report
Query
Table
Form
In a database, data is stored in
Tables
Forms
Reports
Queries
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
The best data type to choose for date of birth would be
Number
Text
Date/Time
Currency
What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?
Query
Form
Report
Table
What is a complete row of data within a table?
Table
Field
Record
Query
To sort from the smallest to the largest (from A to Z and 0 to 9)
Ascending
Descending
Advanced Sort/Filter
What colour is the access sign?
Red
Blue
Green
Black
What is a relational database?
A singular table
Column
Table
Two tables that have been merged together to make one
what is a column in a access database?
Row
Field
Spreadsheet
Data Type
When working with a database application, what is the function of a wizard?
to complete a task for you
to guide you through the steps required to complete a task
to ensure all default settings are implemented
to suggest the most efficient way to complete a task
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
These provide data entry and lookup.
Tables
Forms
Queries
Reports
