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

Microsoft Access (MS Access) → Page 9

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. The small button with three dots displayed at the right of field properties box is called :

A.
Make Button
B.
Expression Button

C.
Build Button
D.
None Of Above


Show Answer
Q.

2. Which of the following shows the final result in a presentable way ?

A.
Forms
B.
Reports

C.
Queries
D.
Tables


Show Answer
Q.

3. In MS Access, how can we create relationship between two tables in the GUI ?

A.
Drag the foreign key of a table into the primary key of another table
B.
Drag any field from parent table and drop on child table

C.
Drag the primary key of a table into foreign key of another table
D.
Any of these can be done to create relationship


Show Answer
Q.

4. Which of the following storecommandto gather data from database?

A.
Forms
B.
Reports

C.
Queries
D.
Tables


Show Answer
Q.

5. A search value in SQL query can be a specific value or it can be ________

A.
Logical Operator
B.
Relationship

C.
Wild card character
D.
Comparison operation


Show Answer




eXTReMe Tracker