Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

USING TABLES IN MS ACCESS

Total questions: 11

Worksheet time: 6mins

Name
Class
Date
1.

A table is also called a ___________ .

a)

Object

b)

Relation

c)

Records

2.

____________ help you to perform routine tasks by automating them into a single command.

a)

Report

b)

Modules

c)

Macros

3.

It is a collection of information about one person or thing, such as the name, phone number and address of one student.

a)

Record

b)

Table

c)

Field

4.

A ____________ is a field with values that are unique for each record throughout a table.

a)

foreign key

b)

primary key

c)

candidate key

5.

____________ is a label to identify a field in a database.

a)

Record

b)

Field

c)

Field Name

6.

It is a string of characters used to store alphanumeric data.

a)

Short text

b)

Long text

c)

Autonumber

d)

Number

7.

We use the___________ property to customize how the number, date, time and text are to be displayed and printed.

a)

Visual

b)

Format

c)

Caption

8.

The file extension for database in MS Access 2007/2010 is

a)

.acddb

b)

.acdbb

c)

.accdb

9.

________________ is used to define the fields, data types and description of the field.

a)

Datasheet view

b)

Design View

c)

Table view

10.

_____________data lets you hide unimportant data and focus only on the data you're interested in.

a)

Filtering

b)

Sorting

c)

Validation

11.

We use the ____________ Property to provide helpful information to the user through the labels telling about the object

a)

Format

b)

Validation

c)

Caption