MS Access Questions and Answers pdf - Set 09 - ObjectiveBooks

MS Access Questions and Answers pdf - Set 09

Practice Test: Question Set - 09

1. Cascade update option
    (A) Means do not change the value in the primary key field if that record has related records in another table
    (B) Means change all the related records in child tables if the record in parent table is changed
    (C) Both of above
    (D) None of above

2. You can automatically include all of the field in a table in a query by________ a strike that appear list box in query design view
    (A) Clicking
    (B) Right clicking
    (C) Double clicking
    (D) None of the above

3. The key uniquely identifies each record in a table.
    (A) Primary key
    (B) Key word
    (C) Filed name
    (D) All of above

4. This type of database contains multiple tables that are connected to produce combined output from all tables.
    (A) Bound
    (B) Linked
    (C) Relational
    (D) Joined

5. A collection of related records in database is known as a
    (A) Table
    (B) Database
    (C) File
    (D) None of above

6. When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from a-z
    (A) ?
    (B) !
    (C) #
    (D) \

7. This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.
    (A) Columnar
    (B) Justified
    (C) Datasheet
    (D) Tabular

8. This type of query summarizes large amounts of data in easy-to-read, row-and-column format.
    (A) Crosstab
    (B) Columnar
    (C) Select
    (D) Action

9. The result of a query is displayed in a
    (A) Record
    (B) Query datasheet
    (C) Query table
    (D) Form

10. To set a password for the database, select __________ in the Microsoft Access open window.
    (A) Open read only
    (B) Open write only
    (C) Open explicit
    (D) Open exclusive

11. Which of the following query type is best suitable to analyze data?
    (A) Cross tab queries
    (B) Parameter queries
    (C) Action queries
    (D) None of above

12. What type of control in a form can display data from database table?
    (A) Bound control
    (B) Unbound control
    (C) Both of above
    (D) None of above

13. Which program do you use to edit code for data access pages?
    (A) Microsoft script editor
    (B) Microsoft code editor
    (C) Microsoft data access pages editor
    (D) None of above

14. When a picture or other graphic image is placed in the report header section it will appear_________
    (A) Once in the beginning of the report
    (B) At the top of every page
    (C) Every after record break
    (D) On the 1st and last pages of the report

15. To create a new table, in which method you don’t need to specify the field type and size?
    (A) Create table in Design View
    (B) Create Table using wizard
    (C) Create Table by Entering data
    (D) All of above

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: