Font size
WorksheetsIntro to Databases in Access
Total questions: 16
Worksheet time: 6mins
A database is ..
an organised collection of data
Access software
lots of unorganised data
an Excel sheet
There are two types of databases, choose them from the list below
relational databases
flat file databases
facebook databases
databases with tables
A flat file database contains only one table
true
false
A relational database contains ..
(choose the most accurate answer)
multiple related tables
more than one table
one very large table
Relational databases are more efficient than flat file databases because .. (check all that apply)
less data is required to be stored inside the database
they are faster in retrieving data
there is more than one table
we can use both Excel and Access to create them
We can enter data in an Access database, either directly in the table or using a ...
form
table
query
report
We can retrieve data from a database to be printed using a ..
form
table
query
report
We can manipulate the data to be retrieved from a database using a ...
form
table
query
report
We can create a relational database using the software ..
MS Excel
MS Access
MS Word
All the above
In a database table, columns are called ..
fields
headers
data types
In a database table, rows are called ..
records
sets
items
objects
The table in this picture, is shown in
design view
datasheet view
access view
The table in this picture, is shown in
design view
datasheet view
access view
If we add a new record to a database table, we must add it in
datasheet view
design view
To find out, or change the data types for each field in a database table, we need to open it in ..
datasheet view
design view
A field with datatype Autonumber cannot be manually inserted or edited
true
false
