Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Chapter 11 & 18 Review

Total questions: 119

Worksheet time: 2hrs 38mins

Name
Class
Date
1.

A collection of field in a database is:

a)

Row

b)

Record

c)

Data

d)

None of the above

2.

The name of the a field that identifies each record in a relational database.

a)

Foreign Key

b)

Primary Key

c)

Keyless

d)

None of the above

3.

Datatype to use for an "AMOUNT" field.

a)

Numeric

b)

Boolean

c)

Currency

d)

Alphanumeric

4.

Datatype to use for "Are you present?"

a)

Numeric

b)

Boolean

c)

Currency

d)

Alphanumeric

5.

A database with only one table is:

a)

Database Management System

b)

Flat file database

c)

Spreadsheet

d)

None of the above

6.

Tick all the views in Microsoft Access database.

a)

Datasheet view

b)

Design view

c)

Form view

d)

Teleview

7.

It is a method of retrieving data from several tables and come up with a new table of the extracted fields.

a)

Query

b)

Table

c)

Report

d)

Forms

8.

In Microsoft Access, It is to present data from the database

a)

Form

b)

Query

c)

Report

d)

Table

9.

In Microsoft Access, it is made up of collection of data in rows and columns.

a)

Form

b)

Query

c)

Report

d)

Table

10.

In Microsoft Access, you can use ______ to add, modify, or delete data from the database in a attractive way.

a)

Forms

b)

Query

c)

Report

d)

Table

11.

__________ are built-in predefined process to make data entry forms quickly and easily done.

a)

Wizards

b)

Formulae

c)

Datatypes

d)

None of the above

12.

In a query, we use _____________ to get or filter the data from the database.

a)

Criteria

b)

Crickets

c)

Datatypes

d)

None of the above

13.

(a)   is the process put data in a query in order.

14.

To search a database

a)

Report

b)

Query

c)

Label

d)

Table

15.

A database is an

a)

interesting collection of facts

b)

a computer-based data storage technology

c)

organised collection of data

d)

a large disorganised bucket of data

16.

A foreign key is a normal field in one table which is used as a (a)   in another table

17.

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

a)

Datatypes

b)

Primary Key

c)

Field Names

d)

Reports

18.
a)

Query criteria

b)

Wildcards

c)

Datatypes

d)

Field names

19.

It is the name of the field to points to another table.

(a)  

20.

A database is made up of a collection of records or rows organized in to a (a)   .

21.

Datatype to use for a phone number field.

a)

Numeric

b)

Boolean

c)

Currency

d)

Alphanumeric (short text)

22.

How many records are there in this database?

a)

1 record

b)

5 records

c)

7 records

d)

9 records

23.

How many records are there in this database?

a)

1 record

b)

5 records

c)

7 records

d)

9 records

24.

How many Fields are there in this database?

a)

6 Fields

b)

3 Fields

c)

5 Fields

d)

2 Fields

25.

Which fields sorted in Descending Order?

a)

Title

b)

Rating

c)

Genre

d)

Price

26.

Give a name of a field that contains Numeric Integer Data

a)

Genre

b)

Title

c)

Rating

d)

Product Id Number

27.

Identify the data type of the Genre Field

a)

Numeric (Integer)

b)

Text

c)

Boolean

d)

Alphanumeric

28.

Which field would be the Primary Key Field?

a)

Title

b)

Product Id Number

c)

Genre

d)

Rating

29.

What are databases mainly used for?

a)

To store archived data

b)

To store and organise data

c)

To analyse data

30.

Which of the following statements best defines the word '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 collection of statistics stored only for computers.

c)

A database does not collect data or information.

31.

Which of the following uses paper-based databases?

a)

Phonebook

b)

Smart Phone

c)

Computer

32.

What is open data?

a)

Open data is data that only certain people have access to

b)

Open data is data that is freely available and shared

c)

Open data is data that is very secure

33.

What is the difference between an entity and an attribute?

a)

An attribute is a table in a database and an entity is a field

b)

An attribute is a record in a database and an entity is a table

c)

An attribute is a field in a database and an entity is a table

34.

Why would you create a primary key?

a)

To make each record in a database unique

b)

To make each field in a database unique

c)

To make each query in a database unique

35.

Select one 'school/student based' database term.

a)

Allergies

b)

Type of pet

c)

Social media accounts

36.

Which of the following defines the term 'field' in relation to databases?

a)

A field is all of the information about one person or one thing

b)

A field is the collection of all the database records on one topic or subject

c)

A field is one type or piece of information

37.

Which of the following defines the term 'file' in relation to databases?

a)

A file is all of the information about one person or one thing

b)

A file is one type or piece of information

c)

A file is the collection of all the database records on one topic or subject

38.

Select the computer-based database

a)

Phonebook

b)

Chalkboard

c)

Google search engine

39.
This kind of referential integrity should be avoided as it leads to duplicated data.
a)
many-to-many
b)
one-to-many
c)
one-to-one
40.
This kind of referential integrity should be avoided as it leads to duplicated data.
a)
many-to-many
b)
one-to-many
c)
one-to-one
41.
Telephone number fields should have this data type.
a)
alphanumeric
b)
number
c)
currency
d)
Boolean
42.
This kind of wildcard query will find all records beginning with an 'a'.
a)
a*
b)
*a
c)
*a*
43.
This kind of wildcard query will find all records that end with an 'a'.
a)
*a
b)
a*
c)
*a*
44.
This kind of wildcard query will find all records that contain an 'a'.
a)
*a*
b)
a*
c)
*a
45.
This query string will find all records of thirty or more.
a)
>=30
b)
>30
c)
<30
d)
>="30"
46.

This query string will find all values from 5 to 10 inclusive.

a)

BETWEEN 5 AND 10

b)

>5 AND <10

c)

=5 OR 10

d)

5-10

47.
This query string will find all values that contain the word 'happy'.
a)
Like "*happy*"
b)
Like happy
c)
Like "*happy"
d)
Like "happy*"
48.
In a car database, searching for make: Mitsubishi, model: Evo, colour: blue would be what kind of query?
a)
complex
b)
simple
c)
parameter value
d)
wildcard
49.
In a flights database, searching for flights that depart on January 1st would be what kind of query?
a)
simple
b)
complex
c)
parameter value
d)
wildcard
50.
In a music database, searching for all subcategories of pop music (including K-pop, J-pop and pop rock) would be what kind of query?
a)
wildcard
b)
simple
c)
complex
d)
parameter value
51.
In a school database, what kind of query loads a window for the user to type in a student surname?
a)
parameter value
b)
simple
c)
complex
d)
wildcard
52.
When the primary key from a table appears as a field in another table, it is called a...
a)
foreign key
b)
secondary key
c)
linked key
d)
related key
53.
Forcing a field to contain an email address formatted *@*.* (email@address.com) would need which form of validation?
a)
input mask
b)
lookup
c)
presence check
d)
type check
54.
A runtime query calculates a value when the query is run with the format Field:[Calculation]. How would you calculate profit?
a)
Profit:[Sale]-[Cost]
b)
Profit = Sale - Cost
c)
Proft = [Sale] - [Cost]
d)
[Sale]-[Cost]:Profit
55.
A runtime query calculates a value when the query is run with the format Field:[Calculation]. Which syntax would calculate sales tax at 20%?
a)
Sales tax:[Total]*0.2
b)
[Total]*20 = "Sales tax"
c)
Sales tax = total * 20%
d)
"Sales tax":"total"*"0.2"
56.
What is the best way to display a field containing weekdays (Mon, Tue, Wed, Thu, Fri) where only one option should be chosen on a data entry form?
a)
a drop down list
b)
a checkbox list
c)
a text box
d)
a button
57.
What is the best way to display a field containing weekdays (Mon, Tue, Wed, Thu, Fri) where more than one option can be chosen on a data entry form?
a)
a checkbox list
b)
a drop down list
c)
a text box
d)
a button
58.

This query string will find all records that aren't zero.

a)

NOT 0

b)

=0

c)

=!0

d)

0

59.

This query string will find all records that aren't zero.

a)

<>0

b)

=!0

c)

="0"

d)

=^0

60.

A database is an

a)

interesting collection of facts

b)

a computer-based data storage technology

c)

organised collection of data

d)

a large disorganised bucket of data

61.

To search a database

a)

Report

b)

Query

c)

Label

d)

Table

62.

A foreign key is a normal field in one table which is used as a (a)   in another table

63.

When would MS Access be used instead of MS Excel?

a)

When using one large worksheet with mostly numeric data

b)

Creating complex graphs or charts

c)

Creating essays with included data

d)

For multiple tables, lots of data & using external databases

64.

What table has been used in the design of this query?

a)

Query1

b)

Shapes

c)

Access

d)

ID

65.

How many fields will appear in this query results?

a)

ONE

b)

TWO

c)

THREE

d)

ZERO

66.

There are 30 records in the database. How many will be found with this query?

a)

30

b)

0

c)

ERROR

d)

20

67.

What query type is shown below?

a)

AND

b)

OR

c)

EQUALS

d)

NOT

68.

What query would get you the same results as the one below?

a)

NOT White

b)

EQUALS White

c)

Black AND White

d)

Black OR White

69.

What symbol means GREATER THAN or EQUALS to?

a)

<=

b)

>=

c)

>

d)

<

70.

The process of checking data as it is input to ensure that it is reasonable is known as...

a)

DATA VERIFICATION

b)

DATA VALIDATION

c)

CONDITIONAL FORMATTING

d)

NONE OF THESE

71.

What does the following calculation do?

a)

Anything bigger than 500, smaller than 1000

b)

Smaller than 500, bigger than 1000

c)

Equal to or bigger than 500, equal to or smaller than 1000

d)

Equal to or smaller than 500, equal to or bigger than 1000

72.

What does the following report calculation do?

a)

Avg is spelt wrong so there is an error

b)

Grade is spelt wrong so there is an error

c)

nothing will display in report

d)

Gives the average grade from the whole database

73.

Which icon do you click to change to Design View?

a)

A

b)

B

74.

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

a)

Datatypes

b)

Primary Key

c)

Field Names

d)

Reports

75.

What does adding an asterisk ( * ) either side of a search criteria do? I.E. *Adventure*

a)

Only return any field that is exactly "Adventure"

b)

Discards anything that is exactly "Adventure"

c)

Discards anything that contains "Adventure"

d)

Allows you to search for anything containing "Adventure"

76.
a)

Query criteria

b)

Wildcards

c)

Datatypes

d)

Field names

77.

Which of these fields is the primary key

a)

Student_Fname

b)

Student_Sname

c)

Student_ID

d)

None of these

78.

To hide a field from the query result

a)

Delete Field from the Query Grid

b)

Remove Show Box Checkmark

c)

Add Show Box Checkmark

d)

Put IS Null in the Criteria Cell

79.

Like R* will display

a)

All Records that end in "R"

b)

No Records

c)

All Records Greater Than R

d)

All records that Begin with "R"

80.
A PowerPoint Presentation will have which file extension
a)
.ppt
b)
.power
c)
.doc
d)
.xls
81.
An Image or a photograph will use the following extension..
a)
.html
b)
.jpg
c)
.doc
d)
.xls
82.
A Microsoft Word document will have which file extension?
a)
.doc
b)
.ppt
c)
.xls
d)
.png
83.
A video file will have which of the following the extension..
a)
.mpeg
b)
.doc
c)
.fla
d)
.xls
84.

If I cut and paste a file from the downloads to the desktop, the file will stay in both places.

a)

True

b)

False

85.

If I delete a file from the desktop, is it permanently deleted?

a)

Yes, it is gone forever

b)

No, it goes to the recycle bin which empties it

c)

No, it goes to the recycle bin and you have to empty the recycle bin

86.

If you put a file in the recycle bin, can you retrieve it?

a)

No, it is deleted forever

b)

Yes, as long as the recycle bin hasn't been emptied

c)

Yes, it stays in the recycle bin forever

87.

If I download a file from Google Drive, where does it go?

a)

Desktop

b)

Documents

c)

Downloads

d)

This PC

88.

Would you use cut or copy to duplicate a file or folder somewhere else?

a)

Cut

b)

Copy

89.

What is Microsoft Excel used for?

a)

Making documents

b)

Presentations

c)

Spreadsheets

d)

Emails

90.

What is the difference between a file and a folder?

a)

A folder is a document and a file where the documents are stored

b)

A folder is where the documents are stored and a file is a document

91.

Which is the biggest file size?

a)

980 kb

b)

300 gb

c)

124 mb

92.

If you "drag and drop", what does it mean?

a)

To copy a file from the computer to Google Drive

b)

To cut and paste a file from the computer to Google Drive

c)

To delete a file from the computer

d)

To delete a file from the Google Drive

93.
The shortcut combination to copy is.. 
a)
CTRL-V
b)
CTRL-C
94.
The shortcut combination to paste is.. 
a)
CTRL-C
b)
CTRL-V
95.
The shortcut combination to save is.. 
a)
CTRL-S
b)
CTRL-V
96.
The shortcut combination to UNDO is.. 
a)
CTRL-Z
b)
CTRL-X
97.
Backing up your files is important because....
a)
Computer drives could fail
b)
A virus could corrupt your work
c)

You could accidentally delete a file

d)
ALL ARE IMPORTANT!
98.
To rename a file you have to...
a)
Right-click the mouse and press rename
b)
Quickly double click the file with the mouse
99.
The shortcut combination to cut is...
a)
CTRL-X
b)
CTRL-C
100.
Which is not a feature of graphics software?
a)
Layers
b)
Gradient Fill
c)
Cropping
d)
Sorting
101.
Which is not a typical feature of a Web Browser?
a)
History
b)
Tabs
c)
Bookmarks
d)
Indentation
102.
Which is not a common feature of email software?
a)
Contacts
b)
Attachments
c)
Spam Filter
d)
Favourites
103.
What are the two main categories of software?
a)
Applications & Systems
b)
Systems & Utilities
c)
Utilities & Applications
d)
Applications & Operations
104.
Which of these is not applications software?
a)
Spreadsheet
b)
Database
c)
Word Processor
d)
Anti-Virus
105.
Which is not a task performed by the operating systems?
a)
Managing RAM
b)
Sending Error Messages
c)
Saving files to the Hard Drive
d)
Sending Emails
106.
Which is not a task performed by the operating system?
a)
CPU Scheduling
b)
Handling Data from Input Devices
c)
File Management
d)
Modelling Data
107.

The _____ is a point-of-use menu displayed

by right-clicking.

a)

Single-click it

b)

Ctrl X

c)

Shortcut Menu

d)

recycle bin

108.

What should be entered to search for

all image files with the .jpg file name extension?

a)

*.jpg

b)

folders

c)

window explorer

d)

drive

109.

Make copies of files in case of loss.

a)

backup

b)

subfolder

c)

rename

d)

copy

110.

What does the term file management mean?

a)

How your manager is able to find your file.

b)

The way in which we organize our files and documents on the computer.

c)

How you organize the rough edges of your nails

111.

What is a folder?

a)

an object that contains data or information

b)

a container that can store food

c)

a container that can store hardware components

d)

a container that can store files or folders

112.

What is a folder inside another folder called?

a)

Infolder

b)

Super folder

c)

Sub folder

d)

Small folder

113.

Fill in the blank


C:\\Users\_____\stories\The Blue Rose

a)

Sara

b)

Adam

c)

Tea Time

d)

drawings

114.

Fill in the blank


C:\\Users\Adam\_____\pencil and paper

a)

jokes

b)

drawings

c)

stories

d)

my cat

115.

Fill in the blank.


C:\\_____\Adam\stories\Alien Tap Dancing

a)

Computer hard drive

b)

(C:)

c)

Users

d)

Sara

116.

Fill in the blank.


C:\\Users\Adam\drawings\____

a)

my cat

b)

pencil and paper

c)

elephant

d)

Alien Tap Dancing

117.

Fill in the blank


C:\\Users\Sara\_____\trees

a)

drawings

b)

flower

c)

stories

d)

Sara

118.

Fill in the blank.


C:\\User\Sara\_____\Tea Time

a)

drawings

b)

jokes

c)

stories

d)

The Blue Rose

119.

Which icon is for a word document?

a)
b)
c)
d)

Similar Resources on Wayground

1.2 - Memory & Storage - E.O.U

123 questions

1.2 - Memory & Storage - E.O.U

quiz

Worksheet

•

9th - 10th Grade

Tin Học 12_JZ

115 questions

Tin Học 12_JZ

quiz

Worksheet

•

1st - 10th Grade

Test topshiriqlari

123 questions

Test topshiriqlari

quiz

Worksheet

•

9th Grade

SISTEM KOMPUTER

117 questions

SISTEM KOMPUTER

quiz

Worksheet

•

9th Grade

IC3 CF

120 questions

IC3 CF

quiz

Worksheet

•

6th - 9th Grade