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