Microsoft Access Questions

MCQ bookmark_border

71.

To sort records in a table

A

Open table, click on the field on which the sorting is to be done, then click sort button on database toolbar

B

Click the field heading to sort it ascending or descending

C

Open table, click sort button on database toolbar, choose field based on which to sort, click ok

D

All of the above

Correct Answer: A

Open table, click on the field on which the sorting is to be done, then click sort button on database toolbar

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

72.

In MS Access “Lookup Wizard” is used to

A

to select value from another table

B

to select values from Excel Sheet

C

to select from previous values

D

not a valid data type

Correct Answer: A

to select value from another table

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

73.

The command center of access file that appears when you create or open the ms access database file.

A

Switchboard

B

Design view Window

C

Database Window

D

Query Window

Correct Answer: C

Database Window

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

74.

In MS Access, Text data type may contain maximum character of

A

255 character

B

256 character

C

1064 character

D

No limit

Correct Answer: A

255 character

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

75.

To rename a selected object, press

A

F2

B

F3

C

F4

D

F5

Correct Answer: A

F2

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

76.

_____ key is uniquely identifies each record.

A

Field Name

B

Unique key

C

Primary key

D

Key record

Correct Answer: C

Primary key

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

77.

Which of the following is a method to create a new table in MS access?

A

Create table by entering data

B

Create table using wizard

C

Create table in design view

D

All of above

Correct Answer: D

All of above

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

78.

The expression builder is an access tool that controls an expression _____ for entering an expression.

A

Palette

B

Box

C

Cell

D

Table

Correct Answer: D

Table

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

79.

Which of the following is a method to create a new table in MS-Access?

A

Create table using wizard

B

Create table in design view

C

Create table in data sheet view

D

All of the above

Correct Answer: B

Create table in design view

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

80.

Which of the following database objects asks a question of information in a database and then displays the result?

A

Forms

B

Reports

C

Tables

D

Queries

Correct Answer: D

Queries

Check Answer report_problem Report forum Discussion