wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Microsoft Access Introduction

Total questions: 30

Worksheet time: 15mins

Name
Class
Date
1.
What is the name of the a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools?
a)
MS Access
b)
MS Word
c)
MS Excel
d)
MS PowerPoint
2.
a)
Tool Bar
b)
Object Bar
c)
Ribbon
d)
None of the Above
3.
a)
Navigation Pane
b)
Title Bar
c)
Control Box
d)
None of the Above
4.
a)
Option Pane
b)
Control Box
c)
Windows Control
d)
Navigational Pane
5.
a)
Control Box & Quick Access Tool Bar
b)
Windows Control
c)
Ribbon
d)
Tool Bar
6.
a)
Quick Access Tool Bar
b)
Control Box
c)
Object Pane
d)
Ribbon
7.
a)
Ready Bar
b)
Status Bar
c)
Optional Bar
d)
Ribbon Bar
8.
This is the Object Pane
a)
True
b)
False
c)
Maybe
d)
None
9.

Where do we create our OWN Database?

a)

Blank Database

b)

Blank Desktop Database

c)

Blank Private Database

d)

Blank Template Database

10.
What company created MS Access?
a)
Microsoft
b)
Apple
c)
Black Berry
d)
Samsung
11.

A "database" is...

a)

a structured set of data held in a computer, especially one that is accessible in various ways.

b)

a powerful presentation software.

c)

a spreadsheet program.

12.

Keisha wants only Beyoncé songs from her database. What should she use to see and save them?

a)

Filter

b)

Form

c)

Query

13.

In a database, a "form" allows you to ...

a)

create a query.

b)

enter data and edit it in a simple form that consists of the fields from a table.

14.

In a database, a "field" is ...

a)

a unique identifier.

b)

a user friendly report.

c)

a data structure for a single piece of data composed of records and fields.

15.

In your database, information is stored in ...

a)

tables.

b)

reports.

c)

queries.

d)

forms.

16.

In a Table, a column is known as a ...

a)

record.

b)

garden.

c)

field.

d)

area.

17.

In a Table, a row is known as a ...

a)

record.

b)

garden.

c)

field.

d)

area.

18.

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

a)

Address Book

b)

Filing Cabinet

c)

Fax Machine

d)

Typewriter

19.

In your database, information is stored in the ...

a)

Table

b)

Report

c)

Query

d)

Form

20.

When working with a database application, what is the function of a wizard?

a)

to complete a task for you

b)

to guide you through the steps required to complete a task

c)

to ensure all default settings are implemented

d)

to suggest the most efficient way to complete a task

21.

Which object would you create to share the data from your database with others?

a)

Form

b)

Report

c)

Query

d)

Table

22.

One example of a database would be ...

a)

grocery list

b)

stamp collection

c)

movie collection

d)

cell phone contact list

23.

Access offers different views of objects. Which view do you use to edit a table?

a)

Datasheet View

b)

Design View

c)

Table View

d)

Print View

24.

The best way to edit and update your data is in a ...

a)

Report

b)

Form

c)

Query

d)

Table

25.

An organized collection of information about a subject is a ...

a)

database

b)

table

c)

file

d)

record

26.

The most common way to look at a table in Access is ...

a)

Datasheet View

b)

Design View

c)

Table View

d)

Print View

27.

What Query view is shown in this image?

a)

Datasheet View

b)

Design View

c)

Report View

d)

Form View

28.

What is design view?

a)

The function we use to set up a table in a database.

b)

The place where we type in all the information.

c)

The fungction of show di data

d)

The place where create of database

29.

What is a report in MS Access

a)

A) It is a printed page where users can display data

b)

B) It is an input screen designed to make the viewing and entering data easier

c)

C) This is an important part of database used by analysts to draw conclusions

d)

D) All of above

30.

Which one is not database object

a)

Table

b)

Forms

c)

Reports

d)

Add Queue