Microsoft Access Questions

MCQ bookmark_border

41.

Which is the valid data type in Access?

A

Currency

B

Text

C

Number

D

All of the above

Correct Answer: D

All of the above

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

42.

Which type of terminal is entirely dependent for all its capabilities in the computer system to which it is connected?

A

Intelligent terminal

B

CRT Display

C

Smart terminal

D

Dumb terminal

Correct Answer: D

Dumb terminal

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

43.

The default data type for a field is

A

Varchar

B

AutoNumber

C

Number

D

Text

Correct Answer: D

Text

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

44.

This data type allows alphanumeric characters and special symbols.

A

Auto number

B

Memo

C

Text

D

All of the above

Correct Answer: C

Text

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

45.

Access is a

A

RDBMS (Relational DBMS)

B

DDBMS (Distributed DBMS)

C

OODBMS (object Oriented DBMS)

D

All of the above

Correct Answer: A

RDBMS (Relational DBMS)

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

46.

To open a new database, press

A

Ctrl + O

B

Ctrl + N

C

Ctrl + M

D

Ctrl + S

Correct Answer: B

Ctrl + N

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

47.

A ______ is the collection of data items of all the fields pertaining to one entity.

A

Field

B

Form

C

Record

D

Report

Correct Answer: C

Record

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

48.

It is used to calculate and restructure data for easier analysis of your data. It calculates the sum

A

Append

B

Crosstab

C

Parameter

D

Select

Correct Answer: B

Crosstab

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

49.

Which is not a view to create a table in Access?

A

Pivot Table and Pivot Chart view

B

Database view

C

Design view

D

All of the above

Correct Answer: A

Pivot Table and Pivot Chart view

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

50.

Which of the following creates a drop down list of values to choose from?

A

ID

B

Hyperlink

C

Lookup wizard

D

Clip object

Correct Answer: C

Lookup wizard

Check Answer report_problem Report forum Discussion