Theory Exam Test Microsoft Access - Set 21 - ObjectiveBooks
Theory Exam Test Microsoft Access - Set 21

Theory Exam Test Microsoft Access - Set 21

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
Show and hide multiple DIV using JavaScript View All Answers
 Next Tests: