Frequently Asked MS Access Questions with Answers - Set 29 - ObjectiveBooks

Frequently Asked MS Access Questions with Answers - Set 29

Practice Test: Question Set - 29

1. Queries in Access can be used as
    (A) View, change and analyze data in different ways
    (B) A source of records for forms and reports
    (C) Only ‘a’
    (D) Both ‘a’ and ‘b’

2. In a datasheet, what does each column represent?
    (A) Record
    (B) Field
    (C) Database
    (D) Table

3. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship mean?
    (A) Referential integrity is enforced
    (B) Referential integrity isn’t enforced
    (C) An inner join is set
    (D) An outer join is set

4. Which control lets a user create multiple pages in a form?
    (A) Check box control
    (B) Combo box control
    (C) Option group control
    (D) Tab control

5. Which of the following queries modifies fields not records?
    (A) Append
    (B) Delete
    (C) Make-Table
    (D) Update

6. To apply an AutoFormat to an entire Form, what must you select first?
    (A) Form Selector
    (B) Document tab
    (C) Detail section
    (D) Any control

7. In the Relationship window, related fields from each table are connected by a(n) _________.
    (A) Default field
    (B) Linking tables
    (C) Index
    (D) Join line

8. The ________ is a wild card that represents one or more characters.
    (A) Question mark
    (B) Asterisk
    (C) Exclamation mark
    (D) Dollar sign

9. Which of the following methods CANNOT be used to delete records from a table?
    (A) Selecting records and pressing [Delete]
    (B) Pressing [Ctrl]+[\’]
    (C) Clicking the Delete Record button
    (D) From the ribbon, selecting Delete Record

10. Microsoft Access is a
    (A) Rdbms
    (B) Oodbms
    (C) Ordbms
    (D) Network database model

11. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command?
    (A) File menu
    (B) View menu
    (C) Database menu
    (D) Tools menu

12. Some rules are set in databases to check and permit only correct values. What is this feature called?
    (A) Data verification
    (B) Auditing
    (C) Data filtering
    (D) Data validation

13. Which of the following is not one of the methods available in the new query dialog box to create queries?
    (A) Design view
    (B) Crosstab query wizard
    (C) Simple query wizard
    (D) Datasheet view

14. Which control does access use to link data access page components to Access data?
    (A) Microsoft dynamic data control
    (B) Microsoft data connection control
    (C) Microsoft office data source control
    (D) None of the above

15. In access, the best types of queries to use for data analysis are:
    (A) Select queries
    (B) Parameter queries
    (C) Action queries
    (D) All of the above

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: