wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Access Queries and Reports

Total questions: 20

Worksheet time: 25mins

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 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.
6.
8. Sorting from A-Z is also called a descending sort. 
a)
True 
b)
False 
7.

The Query button is located on the _______ tab.

a)

Home

b)

File

c)

Create

d)

Export

8.

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

9.
____  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
10.
_________ means to put information in order. 
a)
Query
b)
Sort
c)
Filter
d)
Count
11.

Click ___________ to show the results of a query

a)

Execute

b)

Show

c)

Run

d)

Results

12.
Designed to show only one record at a time, this object is useful for editing and data input.
a)
Table
b)
Form
c)
Query
d)
Report
13.
This database object is a primary container used to hold data in MS Access
a)
Query
b)
Form
c)
Table
d)
Report
14.

A small graphical representation of an organization or theme.

a)

Theme

b)

Logo

c)

Form

15.

From which tab we can generate Reports and Queries?

a)

File Tab

b)

Home Tab

c)

Create Tab

d)

Database Tools

16.

We can generate Reports and Queries from:

a)

Tables

b)

Form

c)

Cells

17.

You can specify a criteria for a report.

a)

True

b)

False

18.

Once a Report has been generated, it cannot be customized.

a)

True

b)

False

19.

___________ is used to summarize and present data using the information in tables or queries.

a)

Query

b)

Form

c)

Report

20.

You can change the format of the report using different options present on the Design and Format tabs. Is it true or false.

a)

True

b)

False

Similar Resources on Wayground

Excel

15 questions

Excel

quiz

Worksheet

•

10th - 12th Grade

Advantages and Disadvantages of Collecting Data

20 questions

Advantages and Disadvantages of Collecting Data

quiz

Worksheet

•

10th Grade

Hosting : cPanel Share & VPS

15 questions

Hosting : cPanel Share & VPS

quiz

Worksheet

•

12th Grade

AI Checkpoint 1 Revision

16 questions

AI Checkpoint 1 Revision

quiz

Worksheet

•

9th - 12th Grade

NP IT Quiz ปริศนาไอที #4

20 questions

NP IT Quiz ปริศนาไอที #4

quiz

Worksheet

•

9th - 12th Grade

ESBWB Workbook Domain 1 Lesson 2

15 questions

ESBWB Workbook Domain 1 Lesson 2

quiz

Worksheet

•

9th - 12th Grade

Do You Know Your Keyboard?

15 questions

Do You Know Your Keyboard?

quiz

Worksheet

•

5th - 10th Grade

Cyber Security KS4

15 questions

Cyber Security KS4

quiz

Worksheet

•

8th - 12th Grade