Microsoft Access Interview Questions - Set 16 - ObjectiveBooks

Microsoft Access Interview Questions - Set 16

Practice Test: Question Set - 16


1. This is the stage in database design where one gathers and list all the necessary fields for the database project.
    (A) Data definition
    (B) Data refinement
    (C) Establishing relationship
    (D) None of the above

2. Which of the following is not a type of Microsoft Access database object?
    (A) Table
    (B) Form
    (C) Worksheets
    (D) Modules

3. Which of the following is not a field type in access?
    (A) Memo
    (B) Hyperlink
    (C) Ole object
    (D) Lookup wizard

4. Referential integrity means
    (A) Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
    (B) Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
    (C) Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
    (D) All of above

5. The________ button on the tool box display data from a related table
    (A) Sub form sub report
    (B) Relationships
    (C) Select objects
    (D) More controls

6. Which of the following database object is created first before any other created?
    (A) Table
    (B) Form
    (C) Report
    (D) Query

7. In access, this displays the results of a calculation in a query
    (A) Lookup field
    (B) Calculated field
    (C) Source field
    (D) Child field

8. Queries are based on this, allowing you to use a query as the source for forms and reports
    (A) Filters
    (B) Tables
    (C) Records
    (D) Fields

9. To enter the input mask wizard
    (A) Click on the three dots to the right of the caption entry field
    (B) Click on the three dots to the right of the format entry field
    (C) Click on the input mask toolbar
    (D) Click on the three dots to the right of the input mask entry field

10. Which of the following is a database management system?
    (A) Ms word
    (B) Ms excel
    (C) Oracle
    (D) Lotus 1-2-3

11. To display value from table for a label control
    (A) Set the control source and record source prom property panel
    (B) Choose the database, table, field and select data value to display
    (C) Look at the table and type value in the caption
    (D) Set the record source property and then control source

12. What is the name of the visual basic editor utility that allows you to view the Microsoft Access type library’s available objects and members?
    (A) Object viewer
    (B) Object browser
    (C) Type library spy
    (D) None of above

13. This data type allows alphanumeric characters and special symbols.
    (A) Text
    (B) Memo
    (C) Auto number
    (D) None of the above

14. To create relationship between two tables
    (A) Drag the primary key of a table into foreign key of another table
    (B) Drag the foreign key of a table into the primary key of another table
    (C) Drag any field from parent table and drop on child table
    (D) Any of above can be done to create relationship

15. The expression builder is an access tool that controls an expression________ for entering an expression
    (A) Table
    (B) Box
    (C) Cell
    (D) Palette

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:


    Blogger Comment
    Facebook Comment