Practice Test: Question Set - 21
1. The insertion point looks like a(n) _________.
- (A) H-pointer
- (B) I-pointer
- (C) H-beam
- (D) I-beam
2. An application that executes on separate PCs like this is called a(n) ________ application.
- (A) Enterprise
- (B) Distributed
- (C) Tier
- (D) Global
3. To delete records or perform calculations on a table, the best tool to use is a _________.
- (A) Query
- (B) Filter
- (C) Form
- (D) Report
4. Which of the following statement is true?
- (A) Foreign key
fields don\’t allow duplicate values
- (B) In primary
key field you can enter duplicate value
- (C) In an
indexed field you may or may not enter duplicate value depending upon setting
- (D) All
statements are true
5. Which of the following store command to retrieve data from database?
- (A) Forms
- (B) Reports
- (C) Queries
- (D) Tables
6. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
- (A) A doctor’s
sign
- (B) Thin + sign
- (C) Outline
rectangle
- (D) None of
above
7. A ________ name must be unique within a database
- (A) Table
- (B) Field
- (C) Record
- (D) Character
8. It is a sign or symbol that specifies, operator, and values that produce a result
- (A) Operator
- (B) Query
- (C) Expression
- (D) None of the
above
9. To create this, you enter an expression in the design grid that instructs access to perform a calculation using the current field values.
- (A) Formulated
field
- (B) Numeric
field
- (C) Formula
field
- (D) Calculated
field
10. The quickest way to add a field to the selected fields list is to double-click its field name in this list.
- (A) Find fields
- (B) Search
fields
- (C) Search
record
- (D) Available
fields
11. Saving a database in access is done
- (A) At the
beginning of the database
- (B) The first
time you save data
- (C) When closing
the application
- (D) During auto
save
12. Which of the following columns does not exist in macro design window?
- (A) Arguments
- (B) Comments
- (C) Conditions
- (D) Actions
13. The way a particular application views the data from the database that the application uses is a
- (A) Module
- (B) Relational
model
- (C) Schema
- (D) Subschema
14. Which of the following is not a type of Microsoft Access database object?
- (A) Queries
- (B) Workbooks
- (C) Forms
- (D) Tables
15. How do you update pivot table report data after changes are made to the source data?
- (A) Save your changes,
close the workbook, and then reopen it
- (B) Select the
pivot table worksheet and press f9 on the keyboard
- (C) Click the
report, and on the pivot table toolbar, click the refresh data button
- (D) All of the
above
Next Tests:
Blogger Comment
Facebook Comment