Questions and Answers on Microsoft Access - Set 08 - ObjectiveBooks

Questions and Answers on Microsoft Access - Set 08

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

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: