wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Play with MS Access - 1

Total questions: 25

Worksheet time: 27mins

Name
Class
Date
1.

The software that we would use to create a database is

a)

Microsoft Publisher

b)

Microsoft Excel

c)

Microsoft Word

d)

Microsoft Access

2.

In a database, data is stored in

a)

Tables

b)

Forms

c)

Reports

d)

Queries

3.

Which of the following would be used to uniquely identify a record?

a)

Validation

b)

Data type

c)

Primary key

d)

Field size

4.

A ‘required field’ is a form of

a)

Validation

b)

Verification

c)

Data Entry

d)

Data Output

5.

The best data type to choose for date of birth would be

a)

Number

b)

Text

c)

Date/Time

d)

Currency

6.

The best data type to choose for a phone number would be

a)

Number

b)

Text

c)

Date/Time

d)

Currency

7.

To find a particular set of data in a database you would use a

a)

Table

b)

Form

c)

Query

d)

Report

8.

Besides entering data directly into the table, you could use a

a)

Field

b)

Form

c)

Query

d)

Report

9.

To display the data from a query in a professional format you could use a

a)

Table

b)

Form

c)

Query

d)

Report

10.

Nick wants Access to assign an ID number to each record. What is this called?

a)

Data Type

b)

auto numbering

c)

Properties

d)

Text

11.

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

a)

Query

b)

Form

c)

Report

d)

Table

12.

What is a complete row of data within a table?

a)

Table

b)

Field

c)

Record

d)

Query

13.

To sort from the smallest to the largest (from A to Z and 0 to 9)

a)

Ascending

b)

Descending

c)

Advanced Sort/Filter

14.

A Primary Key is a code that uniquely identifies a _____________ in a Database.

a)

Record

b)

Field

c)

Text

d)

Number

15.

This field can contain any characters with maximum of 255 letters

a)

Memo

b)

Short Text

c)

Database

d)

Texting

16.

This field can only contain monetary data.

a)

Short Text

b)

Long Text

c)

Currency

d)

Yes/No

17.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
18.

Where do you configure the field properties of a Table?

a)

Design View

b)

Datasheet View

c)

Access View

19.
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
20.

File extension for MS Access is ______________.

a)

.accdb

b)

.acdb

c)

.accd

d)

.access

21.

What are the 4 main objects in a database?

a)

Tables, Forms, Reports, Keys

b)

Spell Check, Grammar, Ruler, Tools

c)

Tables, Queries, Forms, Reports

d)

Cells, Columns, Rows, Sheet

22.

Where are the previous, first, next and last record buttons are located?

a)

Title bar

b)

Menu Bar

c)

Navigation Bar

23.

Which button allows us to select an attractive layout from many readymade available layouts?

a)

Design

b)

Auto Format

c)

Navigation

24.

You can specify a criteria for a report.

a)

True

b)

False

25.

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

a)

True

b)

False