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

Microsoft Access (MS Access) → Page 6

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. While creating relationship, what happens when you releasemousepointer after you drop the primary key of a table into foreign key of another table?

A.
A relationship is created
B.
Edit relationship dialog boxappears

C.
A connector symbol is created
D.
A connecting Line is visible


Show Answer
Q.

2. What is the role of Cascade Update option ?

A.
It says do not change the value in the primary key field if that record has related records in another table
B.
It means change all the related records in child tables if the record in parent table is changed

C.
Both A and B
D.
None of these


Show Answer
Q.

3. Which of the following is a method tocreatea new table inMS Access?

A.
Using Design View
B.
CreateTable Wizard

C.
Directly Entering Data
D.
All of Above


Show Answer
Q.

4. If you write criteria values one in a row in query design window, that means you are specifying _____

A.
OR conditions
B.
AND conditions

C.
NOT condition
D.
ALL conditions


Show Answer
Q.

5. How can we create a query in Microsoft Access ?

A.
Drag and drop fields
B.
Type the SQL

C.
Use query wizard
D.
All of above


Show Answer




eXTReMe Tracker