WorksheetsYear 9 Database Quiz
Total questions: 38
Worksheet time: 19mins
What do we mean by a Simple Query?
One that is really easy to answer.
Where you sort the data into alphabetical order.
Where you match two criteria.
Where it matches only one criteria.
Date, time, currency, text are all ...
Data Types.
Databases.
Data Loggers.
Data formats.
A database is ...
... a collection of data which is stored in a logical or structured way.
... just one piece of information about a person or a thing.
... all of the data about a person or thing; it is a collection of fields.
Which one of the following is characteristic of a high-quality user interface?
Places all functions in menus.
Uses a range of attractive fonts and colors.
Has all items grouped as closely together as possible.
Has consistent labeling, button placement, and navigation.
The database software program we use is called -
Microsoft Access.
Microsoft Excel.
Microsoft PowerPoint.
Microsoft Word.
To make every record in a database unique (different), a ______ is used.
Lock and key.
Membership key.
Secondary key.
Primary key.
Why should you use short field names in a database? (Tick all that apply)
It stops inaccurate data being entered.
It makes the information easier to see.
It allows more columns to appear on the screen.
It allows the user to read all the data in the database.
To edit a query in Access, which of these views must you use?
Edit view.
Design view.
Table view.
Grid view.
The columns in tables are called ______.
Fields.
Databases.
Records.
Files.
What is special about the information in a primary key?
The information is unique to a single record of information.
It always appears before the secondary key.
It must always appear first in a query.
It is the same for several different records in a database.
Which of the following are disadvantages of Manual Databases? (Tick all the correct answers.)
Manual databases are cheap to set up.
Sorting the data is very time-consuming.
Paper records take up a lot of space.
It is very difficult to make changes to the data.
A database stores data in a....
Table.
Form.
Query.
Data type.
An input form is better than using a ..... to enter data into a database.
Table.
Query.
Record.
Field.
In a Database, if you wanted one of your fields to use a drop-down list for data entry, you would use what?
The lookup wizard.
A yes/no data type.
A field size of 15.
A primary key.
In which data type would you store a POSTCODE?
Numeric.
Alphanumeric.
Date.
Numbers.
Which of the following is NOT a data type in Access?
Word.
Number.
Currency.
Date/Time.
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
View that shows the “background” or working of a table
design view
datasheet view
form view
layout view
Which data type would be most suitable for the 'Age' field?
Currency
Date & Time
Number
Memo
Data organized and formatted for printing.
form
table
report
query
The command for "not equal to" is...
<>
<=
>=
><
What is a query?
Table
Question
Spreadsheet
Report
A query is used to
Sort the database in alphabetical order
Search the database
Delete records
Create a form
>
<
=
>=
<=
