Microsoft Access Multiple Choice Questions and Answers pdf - Set 07 - ObjectiveBooks

Microsoft Access Multiple Choice Questions and Answers pdf - Set 07

Practice Test: Question Set - 07

1. Which of the following is the DBMS type?
    (A) Flat File System
    (B) Hierarchical DBMS
    (C) Relational DMBS
    (D) All of the Above

2. Macros can recover from _______ in a controlled manner.
    (A) Events
    (B) Modules
    (C) Arguments
    (D) Errors

3. To assign a macro to an event, users need to open the form in Design View.
    (A) Event
    (B) Property
    (C) Title
    (D) Macro

4. A(n) ________ is the default control for a Yes/No field.
    (A) Check box
    (B) Option button
    (C) Toggle button
    (D) List box

5. Which of the following options is NOT a part of an option group?
    (A) Option button label
    (B) Option group frame
    (C) Option group label
    (D) Option group button

6. In Access 2007, to set a table to open as a document tab, you need to go to the __________.
    (A) Microsoft Office button
    (B) Navigation Pane
    (C) Quick Access toolbar
    (D) Database Tools command tab

7. The ________ function returns a string that has been converted to uppercase text.
    (A) AllCap
    (B) UCase
    (C) UpCase
    (D) Upper

8. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
    (A) txt
    (B) txb
    (C) tbc
    (D) tex

9. The ________ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.
    (A) MSN Money
    (B) Portfolio
    (C) Financial
    (D) Stock

10. Which of the following queries prompts users for input data by displaying dialog boxes?
    (A) Append
    (B) Delete
    (C) Parameter
    (D) Update

11. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records the second has 8. With using a right outer join, how many records will the resulting recordset have?
    (A) 5
    (B) 8
    (C) 24
    (D) Not enough information to tell

12. In a query\’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
    (A) The join line but not the relationship between the two tables
    (B) The relationship between the two tables locally
    (C) The relationship between the two tables globally
    (D) The primary key of the first table

13. The page count of a report can be determined by clicking the ________ button.
    (A) First Page
    (B) Previous
    (C) Next
    (D) Last Page

14. Which of the following database objects can have more than one Group Header/Footer section?
    (A) Forms
    (B) Queries
    (C) Reports
    (D) Tables

15. Which of the following is NOT possible when printing Forms?
    (A) Print page 1, 3, and 5
    (B) Print pages 1 through 5
    (C) Print selected records
    (D) Print only the third record

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:

    Blogger Comment
    Facebook Comment