wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Access Database

Total questions: 65

Worksheet time: 34mins

Name
Class
Date
1.

What is a Key field?

a)

A data item which uniquely identifies a record in a table.

b)

A data item which points to another record in a related table.

c)

A link between two tables.

d)

A single collection of data.

2.

What is a Foreign Key?

a)

A link between two tables.

b)

A data type indicating a whole number.

c)

A data item which points to another record in a related table.

d)

A single collection of data.

3.

$789.00 is an example of which data type

a)

Text

b)

Currency

c)

Boolean

d)

Decimal

4.

Validation makes sure data is...

a)

Accurate

b)

Reliable

5.

An example of verification is...

a)

Proof reading

b)

Look up lists

c)

Length checks

d)

Check digit

6.

A search using the criteria =A*

a)

Will find any word with an A in it

b)

Words starting with an A

c)

Nothing

7.

What field type would be used to store the following data "0125-5221"

a)

Text

b)

Number

c)

Time/Date

8.

What does the data values from a field need to be in order for it to be named as a Primary Key

a)

Values need to be number

b)

Values need to be even

c)

Values need to be unique

d)

Values need to be a combination of letters and numbers

9.

Which field is the best fit to be a primary key?

a)

FilmName

b)

FilmID

c)

AverageRating

d)

Director

10.

How is the table being sorted?

a)

YearReleased Ascending

b)

AverageRating Descending

c)

AverageRating Ascending

d)

FilmName Ascending

11.

What is referential integrity?

a)

When the primary key is different from the foreign key and no changes are applied to either

b)

When the foreign key is similar to the primary key any changes are just applied to the foreign key

c)

When the primary key and the foreign key are the same and any changes are applied to both keys

12.
Which type of relationship best describes the following?

Head teacher who runs a School
a)
One to one
b)
Many to many
c)
One to many
13.
Film title is a suitable Primary key, true or false?
a)
True
b)
False
14.
Flat file database is a database where tables are linked, true or false?
a)
True
b)
False
15.

A field is...?

a)

A specific piece of information in a database.

b)

A category of data in a database, eg First Name or Date of Birth.

c)

A large, open area usually covered in grass.

d)

A box in a database.

16.

Which is not an advantage for using computer based databases?

a)

Can easily sort data into order e.g. alphabetic

b)

Can easily make back-up copies

c)

If there is a power-cut, you can’t use it

d)

Can import or export data to/from other packages

17.

When looking at a database how can you easily spot fields and records?

a)

Fields are the rows of the database and records are the headings.

b)

Fields are the headings of a database and records are the rows.

18.

What is a 'database'?

a)

A database is a collection of data or information which is stored in a logical and structured way.

b)

A database is a place where all of the data in the world is stored.

c)

A database is something that does not store data.

d)

A database is a collection of data but not information.

19.
A sports club needs to store information about each member.  The individual information about each member is called a:
a)
Field
b)
File
c)
Table
d)
Record
20.

The HD field is using the data type Boolean

a)

True

b)

False

21.

What am I? I am a way of searching for data or information in a database.

a)

Table

b)

Record

c)

Query

d)

Field

22.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
23.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
24.

A database is a large collection of related data and computerised ones are used because....

a)

Paper filing cabinets are outdated and take up too much room

b)

Computerised databases are much better then paper ones

c)

Computerised databases take up less space, can be easily edited and are faster at searching and sorting information

d)

Computerised databases are much more efficient than paper ones, there are fewer errors and its faster to find all the data you need

25.

Which best explains the differences between a flat file and a relational database?

a)

Flat files only have one table

b)

Flat files only have one table and are prone to data inconsistencies unlike relational databases

c)

Relational databases have multiple tables to avoid data anomalies which are commonplace in flat file databases

26.

A foreign key

a)

is a primary key in its own table and used in a second table to create a link between them

b)

is a field in both tables used to create a link between them

c)

is a primary key used in two tables to create a link between them

d)

is where the primary key is made up of two or more fields

27.

What is an example of a computerised database?

a)

Website

b)

Library system

c)

Powerpoint

d)

Word

28.
DBMS stands for
a)
Database Management Source
b)
Database Mining System
c)
Database Managment System
d)
Doing Boring Medial Stuff
29.

Databases have a structure that has

a)

A file which is made up of records and each record has a number of fields

b)

A table which is the file. It has records and fields in the table.

c)

Multiple tables each with their own file, records and fields

30.
Which of these is an advantage of the flat-field database?
a)
It is cheap
b)
It is flexible
c)
It only shows relevant information
d)
It is easier to find the information you want
31.
Which of these is an advantage of relational databases?
a)
Only relevant data is displayed
b)
It is cheaper
c)
It is faster
d)
Data may be displayed multiple times so it is harder to miss
32.
The four main objects of a relational database consist of:
a)
form, table, query, report
b)
form, table, database, query, report
c)
form, sort, table, query
d)
form, column, row, report
33.
Which of these is not an advantage of using an electronic database?
a)
Faster to find information
b)
Easy to move information - portable
c)
Could be hacked
d)
Can keep a back-up copy
34.
Which of these is an advantage of a paper database?
a)
Easily damaged or lost
b)
Hard to update information
c)
Can share from one computer to another
d)
They are cheap to use
35.

What is the name of the following image

a)

Data Dictionary

b)

Table

c)

Query

d)

Report

36.
A telephone book is a good example of a database.
a)
True
b)
False
37.
I control data entry. I am also used for data entry.
a)
table
b)
query
c)
form
d)
report
38.
I give one the ability to present information in an easy-to-read format. I summarize and print information from the  query search.
a)
form
b)
table
c)
query
d)
report
39.
I can perform an advanced search. I am very similar to asking a detailed question. 
a)
report
b)
query
c)
table
d)
form
40.
way of limiting records being searched
a)
query
b)
filter
c)
table
d)
record query
41.
the way a databse is organized
a)
data structure
b)
data query
c)
data tables
d)
data log
42.
maximum number of characters in a text field
a)
155
b)
255
c)
55
d)
355
43.
Name of fields who can only get one of two possible values
a)
integer
b)
boolean
c)
rushed
d)
exact
44.
when data in a database is updated in groups of information
a)
lik}nking processing
b)
OLTP
c)
transactional processing
d)
batch processing
45.
The validation test that confirms a number is between two values.
a)
Length
b)
Data Type
c)
Check Digit
d)
Range
46.
The validation that tests a sequence of numbers (e.g. a bar code) has no errors by calculating a number.
a)
Length
b)
Data Type
c)
Check Digit
d)
Range
47.
Before the used of database, organizations and individuals used....
a)
File Cabinets
b)
File Systems
c)
Printed Forms 
d)
Filing Systems
48.
Which one of the following is not a popular database package:
a)
Microsoft Word
b)
Microsoft Excel
c)
MySQL
d)
Microsoft Access
49.
Search engines like Google or Bing are essentially databases.
a)
true
b)
FALSE
50.
Paper-based databases make it difficult to search data for more than one criteria.
a)
true
b)
FALSE
51.
Which of these words doesn't belong?
a)
installing
b)
criteria
c)
sorting
d)
relationship
52.
AND, OR allow users to combine multiple ________ in querying a database:
a)
criteria
b)
tables
c)
records
53.
Automatically incremented primary keys are usually numeric
a)
true
b)
FALSE
54.
To decrease the number of mistakes when inputting data into a database, we use two techniques:
a)
Verification and validation.
b)
Validation and virus checking.
c)
Backup and virus checking.
d)
Searching for duplicates and erasing empty rows.
55.
Validates ensures that data is fit for purpose which means the data is:
a)
sensible and reasonable
b)
accurate and fact-checked
c)
spelled correctly
56.
The following is true about validation:
a)
It is performed by software
b)
It is performed by a human
c)
It requires everything to be typed twice, e.g. a new password.
57.

What is the correct data type:


17th January

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

58.

What is the correct data type:


2008

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

59.

What is the correct data type:


£1.25

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

60.

What is the correct data type:


Jodie

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

61.

What is the correct data type:


hot/cold

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

62.

What is the correct data type:


14/05/07

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

63.
_________ are used to select information meeting specified conditions.
a)
Text
b)
Numbers
c)
Queries
64.
__________ are used to provide a neat way of printing your data in many different ways.
a)
File
b)
Reports
c)
Computers
65.
_________ are on-screen windows that help you get data into your database and edit it on the way in
a)
forms
b)
guide
c)
tables

Similar Resources on Wayground

Nghề 2022- 2023

60 questions

Nghề 2022- 2023

quiz

Worksheet

•

9th Grade

SOFTWARE Engineering Second Intermediate

63 questions

SOFTWARE Engineering Second Intermediate

quiz

Worksheet

•

University

LATIHAN SOAL KKA 2025

70 questions

LATIHAN SOAL KKA 2025

quiz

Worksheet

•

10th Grade

Comunicacions i Internet (3r ESO)

65 questions

Comunicacions i Internet (3r ESO)

quiz

Worksheet

•

11th Grade

La carcasa y la fuente de alimentación

64 questions

La carcasa y la fuente de alimentación

quiz

Worksheet

•

6th - 12th Grade

Final Examination of Intro to Computing

65 questions

Final Examination of Intro to Computing

quiz

Worksheet

•

University

Programación

60 questions

Programación

quiz

Worksheet

•

10th Grade

EOC May Test IED

64 questions

EOC May Test IED

quiz

Worksheet

•

9th - 12th Grade