MS Access Quiz Questions and Answers - Set 11 - ObjectiveBooks
Hello everybody! You can translate the content of this page by selecting a language in the select box.

MS Access Quiz Questions and Answers - Set 11

Practice Test: Question Set - 11


1. Which of the following is not a legitimate section for form objects?
    (A) Form detail
    (B) Group header
    (C) Form header
    (D) Page footer

2. What do you call the process of restricting the display of records in a table to those matching a particular criterion?
    (A) Filtering
    (B) Restricting
    (C) Sorting
    (D) Sifting

3. In MS Access “Hyperlink” Data Type can store
    (A) Web Address
    (B) Email Address
    (C) Path of a File
    (D) All of Above

4. Which of the following is invalid field name?
    (A) Student.Address
    (B) Student\’sAddress
    (C) Student_Address
    (D) Student Address

5. What is the use of Referential Integrity in MS Access?
    (A) It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
    (B) It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
    (C) It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table
    (D) None of above

6. 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

7. Which of the following statements about option group is incorrect?
    (A) It is a control object
    (B) It is bound to two fields
    (C) It is a control to identify a choice
    (D) It contains a set of controls representing choices

8. For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.
    (A) Standardized
    (B) Fixed
    (C) Delimited
    (D) Shared

9. Which colors are used to define a custom color?
    (A) Red, Blue, Yellow
    (B) Red, Green, Blue
    (C) Blue, Green, Orange
    (D) Green, Orange, Violet

10. A(n) __________ is a control that, when clicked, executes an action or series of actions.
    (A) Combo box control
    (B) AutoFormat
    (C) Conditional Format
    (D) Command button

11. A(n) ________ query locates data from one or more tables.
    (A) Select
    (B) Summary
    (C) Parameter
    (D) Action

12. Which of the following is the default join between two recordsets?
    (A) Inner join
    (B) Left outer join
    (C) Right outer join
    (D) Self join

13. A ________ often display summary data such as totals or counts.
    (A) Group Header
    (B) Group Footer
    (C) Report Header
    (D) Page Footer

14. What type of controls are text boxes when data from the recordset is visible?
    (A) Align
    (B) Bound
    (C) Calculated
    (D) Unbound

15. Which of the following statements about calculated fields is NOT true?
    (A) A calculated field does not store data in a recordset
    (B) Calculated fields use an expression or formula as its data source
    (C) Data contained in a calculated field is created the first time a query is run
    (D) A calculated field can be created using the Expression Builder dialog box

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:

    Blogger Comment
    Facebook Comment