wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

advanced ms access

Total questions: 11

Worksheet time: 7mins

Name
Class
Date
1.

DBMS stands for-

a)

Data basic maintenance system

b)

Data base maintenance system

c)

Data base management system

d)

Data base managed system

2.

Ms-Access is a ___________ database

a)

Flat File

b)

Relational

c)

Object Oriented

d)

Flat

3.

Fields in database are similar to _________ in tables.

a)

Rows

b)

Columns

c)

Cells

d)

Values

4.

What you understand by data redundancy?

a)

Assurance of the accuracy of data

b)

Duplicate values in database

c)

Security of Data

d)

None of these

5.

What you understand by data redundancy?

a)

Assurance of the accuracy of data

b)

Duplicate values in database

c)

Security of Data

d)

None of these

6.

Which view of table is used to insert a field name in table.

a)

Date sheet

b)

Design

c)

Database

d)

all of the above

7.

Which data type would be most suitable for the 'Age' field?

a)

Currency

b)

Date & Time

c)

Number

d)

Yes/No

e)

Memo

8.

What is a filter?

a)

It removes particular items from your table.

b)

It protects goldfish from yuckky things.

c)

It is a piece of alien hardware.

d)

A unique type of microwave.

9.
A ______ is a question you ask about data stored in a database.
a)
report
b)
filter
c)
search
d)
query
10.

Database object that asks a table a question

a)

Record

b)

Field

c)

Query

d)

Form

11.

Column in a database table

a)

Record

b)

Field

c)

Query

d)

Form