Microsoft Access Questions & Answers - Page 2

6.

Which criteria do not return the position "Officer" as a match in MS Access?

A.

position = "*ff*"

B.

position = "O??icer"

C.

position = " ?ff*"

D.

position = "O#r"

Correct answer is D

No explanation has been provided for this answer.

7.

Which of the following is not a type of relationship that can be applied in Access database

A.

One to One

B.

One to Many

C.

Many to Many

D.

All of above can be applied

Correct answer is D

No explanation has been provided for this answer.

8.

Cascade delete option in MS Access

A.

is used to delete all the records of all tables in a database

B.

will repeat the recent delete operation to all the records of current table

C.

is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted

D.

None of the above

Correct answer is C

No explanation has been provided for this answer.

9.

(IF [Age]>65, "Senior","Adult"). In Ms Access, this expression is an example of:

A.

A conditional expression

B.

Algebraic expression

C.

A financial expression

D.

None of the above

Correct answer is A

No explanation has been provided for this answer.

10.

In MS Access, how can you make a date field DOB store the dates like "2002/10/17" ?

A.

By setting the input mask property to "yyyy/mm/dd"

B.

By setting the format property to "yyyy/mm/dd"

C.

By entering dates in yyyy, mm, dd order

D.

None of the above

Correct answer is B

No explanation has been provided for this answer.