Microsoft Access Practical Questions - Set 14 - ObjectiveBooks
Microsoft Access Practical Questions - Set 14

Microsoft Access Practical Questions - Set 14

Practice Test: Question Set - 14

1. Which of the following is NOT a type of Microsoft Access database object?
    (A) Table
    (B) Form
    (C) Worksheets
    (D) Modules
2. Cascade update option
    (A) Means do not change the value in the primary key field if that record has related records in another table
    (B) Means change all the related records in child tables if the record in parent table is changed
    (C) Both of above
    (D) None of above
3. A search value can be an exact value or it can be
    (A) Logical Operator
    (B) Relationship
    (C) Wild card character
    (D) Comparison operation
4. The_______ operator will cause a record to be selected only if two or more conditions are satisfied
    (A) Or
    (B) If or
    (C) Range
    (D) And
5. It is a query that when run displays its own dialog box prompting you for information, such as
    (A) Select
    (B) Crosstab
    (C) Parameter
    (D) Append
6. A part of database that stores only one type of data is
    (A) Report
    (B) Field
    (C) Query
    (D) Record
7. Which of the following can be an example of a database?
    (A) Address book of all the suppliers of a company
    (B) Salary sheet of all the employees of a company
    (C) Records of daily sales transactions of a company
    (D) All of above
8. Which of the following is not a database application?
    (A) dBase
    (B) Flash
    (C) FoxPro
    (D) Access
9. Which is the valid data type in Access?
    (A) Number
    (B) Text
    (C) Currency
    (D) All of the above
10. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
    (A) By setting required to ‘Yes’
    (B) By using default value
    (C) By defining validation rule
    (D) By using format
11. Which function cannot be used for calculated controls in a report?
    (A) SUM
    (B) AVG
    (C) MPT
    (D) COUNT
12. In MS Access “Lookup Wizard” is used to
    (A) To select from previous values
    (B) To select values from Excel Sheet
    (C) To select value from another table
    (D) Not a valid Data Type
13. Validation Rule in a field will
    (A) Checks the value entered when user leaves the field
    (B) Displays the value in specified format when user leaves the field
    (C) Defines the appearance for the text
    (D) There is no option of Validation Rule
14. A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
    (A) Properties
    (B) Procedures
    (C) Macros
    (D) Commands
15. The option button ________ identifies each button or check box in an option group.
    (A) Event
    (B) Frame
    (C) Label
    (D) Value
Show and hide multiple DIV using JavaScript View All Answers
 Next Tests: