Aptitude Tests, Mental Ability, Objective MCQ Sets, Questions and Answers, PDF, Shortcut Tips

Microsoft Access (MS Access) → Page 5

Microsoft Access (MS Access) solved MCQ sets : MS Access Database Multiple Choice MCQ Question & Answer : Microsoft Access is part of Microsoft Office package. It is a desktop database management system (DBMS) which was first released in 1992. MS Access provides a great database development tool through simple user-friendly graphical user interface. It has many advantages over MS Excel or othe...READ MORE


TEST INSTRUCTION: CLICK OPTION (A, B, C, D) TO SEE ANSWER.




Q.

1. Which of the following is not a field type in Microsoft Access ?

A.
Memo
B.
Hyperlink

C.
Ole Object
D.
Lookup Wizard


Show Answer
Q.

2. The upper part of the query design window in MS Access has two parts shows ____________

A.
Fields name with field size
B.
Fields name with relationships

C.
Fields and Criteria
D.
Sorting Options


Show Answer
Q.

3. To define AND condition while entering criteria in a query design window we write _______

A.
Criteria values vertically one in a row
B.
Criteria values horizontally

C.
Write criteria values separated by AND
D.
Write criteria values using & ( anchor and ) sign


Show Answer
Q.

4. Which feature is used to duplicate a control's formatting ?

A.
Manager
B.
Wizard

C.
Painter
D.
Control


Show Answer
Q.

5. Which of the following is not a type of relationship that can be applied inAccess database?

A.
One to One
B.
One to Many

C.
Many to Many
D.
All of above


Show Answer




eXTReMe Tracker