MCQ Sets

MS Access & DBMS MCQ Questions Set 09

Updated:    

Test yourself with our MS Access & Database MCQ Questions!

Here is the ninth MCQ set from MS Access and Database Management System.

Attempt following questions and click on ‘Show Result’ button to submit your answers.

Microsoft Access MCQ Questions

 

MS Access & DBMS MCQ Set 09

MS Access Multiple Choice Questions

1. A(n) _____ is an image control that displays in the background of a page on a form or report.
 
 
 
 
2. Which of the following can a Report Wizard NOT do?
 
 
 
 
3. In relational database schema each tuple is divided into fields known as?
 
 
 
 
4. Which of the following statements about the Label Wizard is NOT true?
 
 
 
 
5. Query design window has two parts. The upper part shows
 
 
 
 
6. To set a password for the database, select ____________ in the Microsoft Access open window.
 
 
 
 
7. The __________ is used to access one record at a time.
 
 
 
 
8. What is the result of ?Select * from customer where CustID>10 and CustID<100? query?
 
 
 
 
9. To remove all Sorts in a table you can click the ______ command.
 
 
 
 
10. A search value can be an exact value or it can be
 
 
 
 
11. We can remove a relationship defined between two tables by
 
 
 
 
12. What does the expression [detail] ! [product] * 1.30 do?
 
 
 
 
13. Which is NOT a method of creating a table?
 
 
 
 
14. In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.
 
 
 
 
15. A __ name must be unique within a database
 
 
 
 
16. A ____ is a major database object used to display information in an attractive, easy-to-read screen format.
 
 
 
 
17. Which control does access use to link data access page components to Access data?
 
 
 
 
18. In a module, the VB Name used to display a warning query icon is _______.
 
 
 
 
19. What is the use of description field in table design window?
 
 
 
 
20. Which of the following is the file extension for an Extensible Markup Language?
 
 
 
 

 

Comments

  1. Dear MCQ Sets
    Relationship can be establish between two tables by

    a. Drag Primary key of a table into Foreign key of another table
    b. Drag Foreign key of a table into Primary key of another table
    c. Drag any key of a table into any key of another table
    d. All of the above
    (Problem: Why Option A is only true while other option also create relationship between two tables?)

    Reply

    • Chandra,
      You can’t drag any key and drop into any key of another table to create relationship. In between option a and b, the correct method is to drag primary key into foreign key.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments