wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Access

Total questions: 15

Worksheet time: 16mins

Name
Class
Date
1.

is a relational database management system (RDBMS) that's part of the Microsoft Office suite, designed for creating and managing databases, especially for smaller-scale projects.

a)
Microsoft PowerPoint
b)
Microsoft Excel
c)
Microsoft Word
d)
Microsoft Access
2.

MS Access allows users to organize, store, and manipulate data efficiently, without extensive programming knowledge.

a)

TRUE

b)

FALSE

3.

One main task of MS Access is to set up rules and restrictions over the type of data that can

be entered into the database.

a)

TRUE

b)

FALSE

4.

One main task of MS Access is not to create forms to allow non-technical users to enter data,

search the database, and perform other tasks.

a)

TRUE

b)

FALSE

5.

What are the four (4) steps in using Microsoft Access?
Pick four below.

a)

Database Creation

b)

Data Manipulation

c)

Data Input

d)

Query

e)

Report

6.

Which of the following step of Microsoft Access will this fall - After your database is created, the data of

every business day can be entered into the Access database.

a)

Database Creation

b)

Data Input

c)

Report

d)

Query

7.

Which of the following step of Microsoft Access will this fall - This is a fancy term to basically describe the

process of retrieving information from the database.

a)

Database Creation

b)

Query

c)

Report

d)

Data Input

8.

This type of data in Ms Access refers to date and time values for the years 100

through 9999.

a)

Currency

b)

Short Text

c)

Date/Time

d)

Date

9.

This type of data of Ms Access refers to text or combinations of text and numbers,

including numbers that do not require calculating (e.g. phone numbers).

a)

Numbers

b)

Currency

c)

Short Text

d)

Auto Number

10.

This type of data of Ms Access refers to lengthy text or combinations of text and

numbers.

a)

Short Text

b)

Auto Number

c)

Long Text

d)

Currency

11.

This type of data of Ms Access refers to a unique sequential (incremented by 1) number or

random number assigned by Microsoft Access whenever a new record is added to a table.

a)

Auto Number

b)

Short Text

c)

ID Number

d)

Number

12.

In Ms Access, it helps you combine data from two different tables. Each __________ consists of fields in two tables with corresponding data.

a)

Query

b)

Report

c)

Connection

d)

Relationship

13.

MS Access uses table relationships to join tables when you need to use

them in a database object.

a)

TRUE

b)

FALSE

14.

It is a request for data results, and for action on data. You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data.

a)

Report

b)

Data

c)

Query

d)

Relationship

15.

This type of data in Ms Access refers to numeric data used in mathematical

calculations.

a)

Number

b)

Short Text

c)

Long Text

d)

Currency