Microsoft Access Questions

MCQ bookmark_border

61.

Which of the following database object hold data?

A

Forms

B

Reports

C

Tables

D

Queries

Correct Answer: C

Tables

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

62.

This is the stage in database design where one gathers and lists all the necessary fields for the database project.

A

Data Definition

B

Data Refinement

C

Establishing Relationship

D

All of these

Correct Answer: A

Data Definition

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

63.

Which action will optimize your database performance?

A

Set the record set type of Snapshot

B

Use the compact and repair database tool

C

Create a replica of the database

D

All of the above

Correct Answer: B

Use the compact and repair database tool

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

64.

To toggle the Navigation Pane, press

A

F1

B

F2

C

F6

D

F11

Correct Answer: D

F11

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

65.

In Access, this operation copies a backup file from the storage medium back onto the computer

A

Restore

B

Recreate

C

Copy

D

Structure

Correct Answer: A

Restore

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

66.

Which of the following Data Type is used to store picture in MS Access?

A

Picture cannot be stored

B

Memo

C

OLE object

D

Picture

Correct Answer: C

OLE object

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

67.

A _____ name must be unique within a database.

A

Character

B

Table

C

Record

D

Field

Correct Answer: B

Table

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

68.

Which control does access use to link data access page components to access data?

A

Microsoft Default Connection Control

B

Microsoft Data Connection Control

C

Microsoft Dynamic Data Control

D

Microsoft Office Data Source Control

Correct Answer: D

Microsoft Office Data Source Control

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

69.

Which of the following database object is created first before any other created?

A

Query

B

Table

C

Report

D

Form

Correct Answer: B

Table

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

70.

Press _____ to cyle between open windows.

A

Ctrl + F4

B

Ctrl + F6

C

Ctrl + F7

D

Ctrl + F12

Correct Answer: B

Ctrl + F6

Check Answer report_problem Report forum Discussion