Microsoft access MCQ with Answers - Set 02 - ObjectiveBooks

Microsoft access MCQ with Answers - Set 02

Practice Test: Question Set - 02


1. Which of the following is not an action query?
    (A) Add
    (B) Delete
    (C) Make-table
    (D) Update

2. Which of the following Data Type is used to store picture in MS Access?
    (A) Picture
    (B) OLE Object
    (C) Memo
    (D) Picture cannot be stored

3. To create a table in Access
    (A) Database should be created before create table
    (B) Table can be created using Table Templates
    (C) There must be at least one Primary key in a table
    (D) All of the above

4. In MS Access, Field Value may contain
    (A) Text
    (B) Date & Time
    (C) Picture
    (D) All of the Above

5. What is the use of Cascade Delete Option in MS Access?
    (A) It makes sure that all the records from the parent table and child table is deleted from selected database
    (B) It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted
    (C) It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted
    (D) None of above

6. By default, what is the name of a new module in the Modules folder of the Project pane called?
    (A) Bas1
    (B) Module
    (C) New Module
    (D) Module1

7. Which of the following statements about a tab control in a form is incorrect?
    (A) It can contain only one object
    (B) It defines a layered space
    (C) It is a control object
    (D) It is created in multipage forms

8. Which of the following statements regarding charts is incorrect?
    (A) It can be inserted into a form only
    (B) It can be designed as a standalone-object
    (C) It can be linked to the object in which it is placed
    (D) It is a control linked to a data source

9. Which of the following is the file extension for an Extensible Markup Language?
    (A) EML
    (B) HTML
    (C) XML
    (D) XSD

10. Which part of the IIF expression is the action performed if the true condition exists?
    (A) Inner
    (B) First
    (C) Second
    (D) Third

11. The three parts of an IIF function are separated by ________.
    (A) Dashes
    (B) Asterisks
    (C) Semicolons
    (D) Commas

12. The Allow ________ property controls whether new records can be added through the form.
    (A) Additions
    (B) Edits
    (C) Deletions
    (D) Data Entry

13. Which of the following is NOT true about background images?
    (A) They are similar to watermarks in Word
    (B) They are displayed behind the controls in a form
    (C) They do not print when a form or a report is printed
    (D) They can be inserted on a form or a report

14. A(n) _________ query makes changes to or moves records in a dynaset, in a single operation.
    (A) Select
    (B) Summary
    (C) Parameter
    (D) Action

15. In a query, which row do you need to place wildcards to affect a parameter?
    (A) Arguments
    (B) Criteria
    (C) Fields
    (D) Tables

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:


    Blogger Comment
    Facebook Comment