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
Next Tests:
Blogger Comment
Facebook Comment