Font size
WorksheetsYear 10 Database Revision
Total questions: 20
Worksheet time: 28mins
In your database, information is stored in the ...
Table
Report
Query
Form
In a Table, a column is known as a ...
Record
Garden
Field
Stage
Access offers different views of objects. Which view do you use to edit data types of the fields of a table?
Datasheet View
Design View
Table View
Print View
In a Table, a row is known as a ...
File
Field
Record
Stage
There are two types of databases, choose them from the list below
relational databases
flat file databases
facebook databases
databases with tables
A "database" is...
a structured set of data held in a computer, especially one that is accessible in various ways.
a powerful presentation software.
a spreadsheet program.
In a database, a "form" allows you to ...
create a query.
enter data and edit it in a simple form that consists of the fields from a table.
You can create "reports" in an Access database in order to format data in user friendly way.
True
False
What Microsoft software do you use to make databases?
Access
Excel
PowerPoint
Word
A group of fields, such as a telephone number, address and name, which are pertinent to a particular item. These are also known as rows.
query
field
report
records
A piece of information related to a single person or thing; also known sometimes as columns.
table
query
form
field
A field or set of fields with values that are unique throughout a table.
primary key
foreign key
database
record
Why does data inside a database need to be organized?
So the data is neat and tidy
So data integrity can be maintained
So the data can be searched from the Internet
So the data can be found when needed
What is a flat-file database?
A paper version of a database
A compressed database
A database consisting of one table only
A database consisting of text only
What is the definition of a Foreign Key?
A field in a table that is written in another language
A field in a table that links to the World Wide Web
A field in a table that cannot be edited or accessed by users
A field in a table that is used as a link to a field in another table
What is the definition of a Primary Key?
The first field in a database table
A field in a table that contains a unique identifier for each record in the table
A field in a database that can only contain two values
A field in the database that has the same value for each record
How would you define a relational database?
A database consisting of data relating to families
An online database
A database linked to another database
A database consisting of multiple tables, that are linked using keys
What does a Boolean field store?
Numbers
Dates
True or False
Any data, with the database automatically choosing the appropriate data type.
