MS Access MCQs

Question 1

Database access levels are specified so as to define who can access what in a database. It is identified through

Accepted Answer

User id

Answer

Password

Answer

Status

Answer

None of above

Question 2

Which of the following is not a logical database structure?

Accepted Answer

Chain

Answer

Network

Answer

Tree

Answer

Relational

Question 3

The quickest way to add a field to the selected fields list is to double-click its field name in this list.

Accepted Answer

Available fields

Answer

Find fields

Answer

Search fields

Answer

Search record

Question 4

What is the difference between 'Open' and 'Open Exclusively'?

Accepted Answer

Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed

Answer

Open statement opens access database files and Open Exclusively opens database files of other program like Oracle

Answer

Both Open and Open Exclusively are same

Answer

Open Exclusive command does not exist in MS Access

Question 5

in MS Access, OLE Object Data type can store

Accepted Answer

All of the Above

Answer

Microsoft Word documents

Answer

Microsoft Excel spreadsheets

Answer

Sounds

Question 6

A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?

Accepted Answer

Answer

1

Answer

?

Answer

r

Question 7

A relationship is created between how many tables?

Accepted Answer

Two

Answer

One

Answer

Three

Answer

Any number

Question 8

A form defines

Accepted Answer

Both (A) and (B)

Answer

Where data is placed on the screen

Answer

The width of each field

Answer

All of the above

Question 9

Which of the following statements about criteria in a query is NOT true?

Accepted Answer

Criteria cannot be specified as an expression.

Answer

Criteria can contain wildcard characters.

Answer

Criteria in a query selects or excludes certain records.

Answer

Multiple criteria can be specified using AND, OR, and relational operators.