wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

The Weald - Databases

Total questions: 25

Worksheet time: 24mins

Name
Class
Date
1.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
2.
Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
3.
A method for checking data entered e.g. Proof Reading or Double Entry.
a)
Verification
b)
Filter
c)
Data Types
d)
Query
4.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
5.
 What data type is your name? 
a)
text
b)
number
c)
date
d)
time
6.
A Primary Key is a code that uniquely identifies a _____________ in a Database.
a)
Record 
b)
Field 
c)
Text 
d)
Number
7.
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
a)
Query
b)
Report
c)
Database 
d)
Spreadsheet
8.
In a database table, rows are called __________
a)
Field
b)
Record
c)
Primary Key
9.
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
a)
Cell
b)
Field
c)
Column
d)
Record
10.
Forms, queries, and reports are created based on the information in the _________
a)
Form
b)
Table
c)
Report
11.
In a database form, the blanks in which information is entered are called ________.
a)
Fields
b)
Record
c)
Query
d)
 Database
12.
The _________ is used to identify each record in the table with a number.Correct answer: 
a)
Field
b)
Primary key
13.

What software do you use to make databases?

a)

Access

b)

Excel

c)

PowerPoint

d)

Word

14.

Which of the following is an old method of a database?

a)

Address Book

b)

Filing Cabinet

c)

Fax Machine

d)

Typewriter

15.

Missing Word: " A Data Base is a collection of data stored in __________way.

a)

a random

b)

an organized

c)

a haphazard

d)

a numerical

16.

A Data Base is split into:

a)

cells

b)

slides

c)

tables

d)

pages

17.

In a Database table, Records appear as ______________

a)

a row

b)

a column

c)

a form

d)

a cell

18.

A ______________ is part of a record and contains a single piece of data

a)

row

b)

cell

c)

field

d)

table

19.

Forms don't help with :

a)

creating new fields in a database table

b)

Editing existing records in a database table

c)

Entering data in a database table

d)

Updating existing data in a database table

20.

A query finds records in a database according to _________________ you give.

a)

table

b)

data

c)

criteria

d)

column

21.

The following are example of what?

a)

Field name

b)

Query criteria

c)

Data types

d)

cells

22.

What do we use to ensure that at least one aspect of a record is unique?

a)

Forms

b)

Field names

c)

Data types

d)

Primary key

23.

You can import data to your database table

a)

True

b)

False

24.

In LibreOffice, query criterion are Case Sensitive, it means that it makes difference between Upper and Lower case.

a)

True

b)

False

25.

Select the right result:

a)
b)
c)
d)