wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DBMS QUERY LONG QUIZ

Total questions: 35

Worksheet time: 32mins

Name
Class
Date
1.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
2.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
3.
What is letter "A" showing?
a)
Where to configure the Join properties
b)
Where to Run the query
c)
Where to configure which fields and criteria are used for the Query
4.
What is letter "C" showing?
a)
Where to click to Run the Query
b)
Where to Click to Save the Query
c)
Where to configure the Fields returned and the criteria to be used
d)
Where to configure the Join properties
5.
A _______ query displays a dialog box that prompts the user to enter criteria when the query is run.
a)
Top Values
b)
Pattern Match
c)
List of Values
d)
Parameter
6.
A query can get its data from
a)
a. one or more tables.
b)
b. existing queries.
c)
c. a combination of a and b.
d)
d. all of the above.
7.
8. Sorting from A-Z is also called a descending sort. 
a)
True 
b)
False 
8.

The Query button is located on the _______ tab.

a)

Home

b)

File

c)

Create

d)

Export

9.

What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?

a)

Form

b)

Query

c)

Report

d)

Table

10.
____  Is a database object that lets you ask the database about the information that you want to see displayed.
a)
Query
b)
Datasheet
c)
Sort
d)
Filter
11.
An easy way to create a query is to use the ____________.
a)
Design View
b)
Datasheet View
c)
Simple Query Wizard
12.
_________ means to put information in order. 
a)
Query
b)
Sort
c)
Filter
d)
Count
13.
A to Z is sorting in ________ order. 
a)
Ascending
b)
Descending
14.
Z to A is sorting in ________ order. 
a)
Ascending
b)
Descending
15.
What is this operator?
<>
a)
Equal to
b)
Not equal
c)
Less than and greater than
16.

Click ___________ to show the results of a query

a)

Execute

b)

Show

c)

Run

d)

Results

17.

It is the name for any database manipulation operation.

a)

form

b)

report

c)

table

d)

query

18.
Queries that you use to retrieve data from a table or to make calculations
a)
select queries
b)
action queries
c)
update queries
d)
delete queries
19.
What are the two ways to create a query in MS Access
a)
query design
b)
query wizard
c)
query report
d)
create query
20.
Queries that add, change, or delete data
a)
select queries
b)
action queries
c)
update queries
d)
delete queries
21.

This allows you to create queries using a step by step procedures.

a)

query design

b)

query wizard

c)

query report

d)

create query

22.
This lets you see how your query is put together.
a)
query design
b)
query wizard
c)
query report
d)
create query
23.
To view the actions performed in your query, you must click __________.
a)
show
b)
view
c)
run
d)
play
24.
This will help you to retrieve specific items from an Access database.
a)
query design
b)
query wizard
c)
query report
d)
query criteria
25.

If you want to add criteria that meet in any of the cells will be returned or displayed, just add the criteria in ____________

a)

AND field

b)

OR field

c)

Show field

d)

Criteria field

26.
Which of the following is a text format?
a)
"John"
b)
Jake'
c)
$Gina$
d)
#Faith#
27.

Which of the following is a number format?

a)

1995

b)

#444

c)

$3

d)

P8329

28.
Which of the following is a date format?
a)

122122

b)

45281

c)

Jul-05-1994

d)

#01/27/2021#

29.

If we run a query that uses data from multiple related tables, it essentially creates the ________ of those tables and selects records from that.

a)

OR

b)

Like

c)

JOIN

d)

RELATIONSHIP

30.

Queries like this that involve combining data from several related records are called _______________.

a)

OR

b)

JOIN

c)

PARAMETER

d)

TOTAL

31.

It is a logical operator that is used to determine whether a specific character string matches a specified pattern or is simply used to compare two strings.

a)

OR

b)

Like

c)

IN

d)

Between AND

32.

What are the four types of Query?

a)

SELECT

b)

ACTION

c)

PARAMETER

d)

CROSSTAB

e)

DELETE

33.

This query displays one or more predefined dialog boxes that prompt you for the parameter value (criteria).

a)

parameter

b)

crosstab

c)

action

d)

select

34.
What Query view is shown in this image?
a)

Design View

b)

Design Grid

35.

In what Tab can you find the picture shown in this image?

a)

Create Tab

b)

Database Tools Tabs

Similar Resources on Wayground

Block chain

35 questions

Block chain

quiz

Worksheet

•

University - Professi...

Konkurs "BEZPIECZNY INTERNET"

30 questions

Konkurs "BEZPIECZNY INTERNET"

quiz

Worksheet

•

Professional Development

Seleksi Pelatihan Computer Operator Assistant

30 questions

Seleksi Pelatihan Computer Operator Assistant

quiz

Worksheet

•

Professional Development

MS office 2016

40 questions

MS office 2016

quiz

Worksheet

•

1st Grade - Professio...

Fortnite

33 questions

Fortnite

quiz

Worksheet

•

1st Grade - Professio...

Đề tham khảo Tin học - 6

30 questions

Đề tham khảo Tin học - 6

quiz

Worksheet

•

Professional Development

Introduction to Computer Technology

30 questions

Introduction to Computer Technology

quiz

Worksheet

•

9th Grade - Professio...

Orange Test

30 questions

Orange Test

quiz

Worksheet

•

Professional Development