Exam Tiger
APTITUDE TESTS - MENTAL ABILITY - SOLVED OBJECTIVE MCQ SETS - QUESTION ANSWER - PDF STUDY MATERIALS - SHORTCUT TIPS

Microsoft Access Database → Page 3

Microsoft Access Database solved MCQ sets : MS Access Database 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 develo...READ MORE



INSTRUCTION: CLICK ON THE OPTION (A, B, C, D) TO SELECT IT AS YOUR ANSWER.


Q. Which kind of query that displays its own dialog box prompting you for entering information before executing ?
A.
Select Query
B.
Crosstab Query

C.
Parameter Query
D.
Dialog Query


Show Answer
Q. What is a form that we can create in MS Access ?
A.
It is used to take printout of a form from Access Tables.
B.
It is an input screen for viewing and entering data.

C.
It is used for storing special data other than text (e.g photo)
D.
It is optional. We can use Report instead of Form


Show Answer
Q. What Cascade Delete option is used for ?
A.
It is used to delete all the records of all tables in a database
B.
It repeats the recent delete operation to all the records of current table

C.
It ensures that all the related records will be deleted automatically when the record from parent table is deleted.
D.
It is used to delete all the records of related tables in a database


Show Answer
Q. Which operator is used to filter and display rows when all (two or more) conditions are satiesfied ?
A.
RANGE
B.
IN

C.
ALL
D.
AND


Show Answer
Q. The_____________ button on the tool box display data from a related table
A.
Sub form sub report
B.
Relationships

C.
Select objects
D.
More controls


Show Answer



Advertisement


eXTReMe Tracker