Microsoft Access Questions

MCQ bookmark_border

21.

In a database table, the category of information is called ____

A

Tuple

B

Field

C

Record

D

All of above

Correct Answer: B

Field

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

22.

The columns in a Microsoft Access table are called as ____

A

Fields

B

Macro

C

Columns

D

Records

Correct Answer: A

Fields

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

23.

In Access table, column is also known as ____

A

Type

B

Data

C

Record

D

Field

Correct Answer: D

Field

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

24.

Which of the following is not a valid Data Type in MS Access?

A

AutoNumber

B

Currency

C

Picture

D

Memo

Correct Answer: C

Picture

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

25.

In MS Access, OLE objects Data type can store

A

Microsoft Excel Spreadsheets

B

Microsoft Word documents

C

Sounds

D

All of the above

Correct Answer: D

All of the above

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

26.

A part of database that stores complete information about an entity such as employee, sales, orders etc.

A

Record

B

File

C

Field

D

Query

Correct Answer: A

Record

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

27.

In table design view, which key can be used to switch between the field names and properties panels?

A

F1

B

F6

C

F10

D

F12

Correct Answer: B

F6

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

28.

To create queries in Access

A

You can drag and drop fields on query builders

B

You can type the SQL command in SQL view

C

You can use query wizard or design view

D

All of the above

Correct Answer: D

All of the above

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

29.

Which of the following is not a selection technique?

A

To select a row, click the record selector box to the left of the row

B

To select a column, double click anywhere in the column

C

To select a word, double click the word

D

To select an entire table click the empty box to the left of the field names

Correct Answer: B

To select a column, double click anywhere in the column

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

30.

Which program do you use to edit code for data access pages?

A

Microsoft script editor

B

Microsoft data access pages editor

C

Microsoft code editor

D

All of these

Correct Answer: A

Microsoft script editor

Check Answer report_problem Report forum Discussion