MS Access Quiz Questions and Answers - Set 11 - ObjectiveBooks
MS Access Quiz Questions and Answers - Set 11

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: