Practice Test: Question Set - 08
1. Using the keyword _________ will return records in which the field value equals a defined text.
- (A) Between
- (B) Is Null
- (C) Like
- (D) Not
2. Referential integrity can be enforced if both _________ belong to the same Microsoft Access database.
- (A) Queries
- (B) Fields
- (C) Records
- (D) Tables
3. Which of the following field properties enforces the use of parentheses when keying an area code?
- (A) Field Size
- (B) Format
- (C) Input Mask
- (D) Validation
Rule
4. Database properties do NOT include _________.
- (A) Title
- (B) Author
- (C) Company
- (D) Size
5. The Search tool is best used when searching for _________ data.
- (A) Simple
- (B) Multiple
- (C) Unique
- (D) Formatted
6. Print options can be changed in the Print _________.
- (A) Tab
- (B) Layout mode
- (C) Setup
routine
- (D) Dialog box
7. In Datasheet View, new records are added to a table _________.
- (A) In
alphabetical order
- (B) At the end
of the table
- (C) At the beginning
of the table
- (D) In numerical
order
8. A(n) ________ in the Record Selector indicates a new record.
- (A) Check mark
- (B) Pencil
- (C) Asterisk
- (D) Arrow
9. The ability of a database to grow as the data tracking needs grow is its _________.
- (A) Scalability
- (B) Expandability
- (C) Maintainability
- (D) Platform-independence
10. This database has only one table.
- (A) Relational
- (B) Large
- (C) Flat-file
- (D) DBMS
11. The ________ is used to access one record at a time.
- (A) Query
- (B) Filter
- (C) Form
- (D) Report
12. Which of the field has width 8 bytes?
- (A) Memo
- (B) Number
- (C) Date/time
- (D) Hyperlink
13. A __________ enables you to view data from a table based on a specific criterion
- (A) Form
- (B) Query
- (C) Macro
- (D) Report
14. Which of the following is a method to create a new table in MS Access?
- (A) Create table
in design view
- (B) Create table
using wizard
- (C) Create table
by entering data
- (D) All of above
15. 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
Next Tests: