Microsoft Access Questions

MCQ bookmark_border

31.

In how many views, you can create a table in Access?

A

2

B

4

C

6

D

8

Correct Answer: B

4

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

32.

Which of the following is not a field type in access?

A

Ole object

B

Hyperlink

C

Memo

D

Lookup wizard

Correct Answer: D

Lookup wizard

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

33.

To switch between to Form view from design view, press ____

A

F5

B

F8

C

F9

D

F11

Correct Answer: A

F5

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

34.

It is a query that when run displays its own dialog box prompting you for information, such as

A

Append

B

Parameter

C

Crosstab

D

Select

Correct Answer: B

Parameter

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

35.

Row in an Access table is also known as ____

A

Type

B

Data

C

Record

D

Field

Correct Answer: C

Record

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

36.

The appropriate Data Type to store Time in MS Access?

A

Time cannot be stored

B

Time

C

Time Only

D

Date/Time

Correct Answer: D

Date/Time

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

37.

Which of the following data type stores text or a combination of text and numbers?

A

Ole

B

Text

C

Currency

D

Number

Correct Answer: B

Text

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

38.

Unlike text data type, this can store up to maximum of 65,535 characters.

A

Date/time

B

Number

C

Memo

D

All of above

Correct Answer: C

Memo

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

39.

In MS Access, AutoNumber Data Type

A

Can be Sequential

B

Can be Random

C

Only A & B

D

Can be Edited

Correct Answer: C

Only A & B

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

40.

In MS Access, which data type is appropriate to store large text and numbers?

A

Large Text

B

OLE

C

Memo

D

Text

Correct Answer: C

Memo

Check Answer report_problem Report forum Discussion