Microsoft Access Objective Questions & Answers - ObjectiveBooks

Microsoft Access Objective Questions & Answers

Practice Test: Question Set - 33

1. What is a form in MS Access?
    (A) It is a printed page where users will write their data to fill it up
    (B) It is an input screen designed to make the viewing and entering data easier
    (C) This is an important part of database used by analysts to draw conclusions
    (D) All of above

2. What determines a table’s sort order?
    (A) AutoNumber field
    (B) Index field
    (C) Field order
    (D) Primary key

3. Which data type is better to use for storing the price of an item?
    (A) Text
    (B) AutoNumber
    (C) Number
    (D) Currency

4. Which of the following Format supports for Data Type Yes/No?
    (A) Yes/No
    (B) True/False
    (C) On/Off
    (D) All of Above

5. The ________ Builder is an Access tool for selecting colors from a palette or creating custom colors.
    (A) Color
    (B) Expression
    (C) Palette
    (D) Property

6. Which function evaluates a “true/false” expression and then performs one of two actions?
    (A) Case
    (B) IF
    (C) IIF
    (D) Is True

7. ________ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the
    (A) Design View
    (B) Layout View
    (C) Print Preview
    (D) Report View

8. Which of the following statements about criteria in a query is NOT true?
    (A) Criteria can contain wildcard characters
    (B) Criteria in a query selects or excludes certain records
    (C) Criteria cannot be specified as an expression
    (D) Multiple criteria can be specified using AND, OR, and relational operators

9. The Table _________ Wizard analyzes a database and recommends changes for normalization.
    (A) Analyzer
    (B) Documenter
    (C) Cleanup
    (D) Normalization

10. Which major database object stores all data?
    (A) Field
    (B) Query
    (C) Record
    (D) Table

11. The _________ field is used to hold a yes or no answer.
    (A) Object
    (B) Number
    (C) Text
    (D) Logical

12. In a database table, the category of information is called __________
    (A) Tuple
    (B) Field
    (C) Record
    (D) All of above

13. If you write criteria values vertically (one in a row) it will mean
    (A) Or conditions
    (B) And conditions
    (C) Not condition
    (D) None of above

14. It is a database object to view, change, and analyze data in different ways
    (A) Query
    (B) Form
    (C) Report
    (D) None of the above

15. In access, this operation copies a backup file from the storage medium back onto the computer
    (A) Recreate
    (B) Restore
    (C) Copy
    (D) Structure

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: