Microsoft Access MCQ Exam Questions - Set 17 - ObjectiveBooks

Microsoft Access MCQ Exam Questions - Set 17

Practice Test: Question Set - 17

1. When entering field name, how many characters you can type in maximum?
    (A) 60
    (B) 64
    (C) 68
    (D) Any number of characters

2. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
    (A) A doctor’s sign
    (B) Thin + sign
    (C) Outline rectangle
    (D) None of above

3. If you write criteria values vertically (one in a row) it will mean
    (A) OR conditions
    (B) AND conditions
    (C) NOT condition
    (D) None of above

4. Which of the following is not a database object in MS Access?
    (A) Tables
    (B) Query
    (C) Report
    (D) Relationship

5. A primary key in any table has the properties
    (A) Not Null
    (B) No Duplicates
    (C) Both of above
    (D) None of above

6. A ________ is a unit of information in a ________
    (A) Record, field
    (B) Field, record
    (C) Data source, field
    (D) Record, data source

7. Which of the following is not a view for interacting with a form object?
    (A) Datasheet view
    (B) Design view
    (C) Form view
    (D) Layout view

8. Which criteria do not return the position “Officer” as a match?
    (A) position = “*ff*”
    (B) position = “O??icer”
    (C) position = ” ?ff*”
    (D) position = “O#r”

9. The basic elements of a form or a report are called:
    (A) Controls
    (B) Objects
    (C) Windows
    (D) Properties

10. Which is not a command that is selectable from right click menu of a field column?
    (A) Hide columns
    (B) Rename columns
    (C) Freeze columns
    (D) Sort descending

11. The appropriate Data Type to store Time in MS Access?
    (A) Date/Time
    (B) Time Only
    (C) Time
    (D) Time cannot be stored

12. Primary key is
    (A) Uniquely identifies each record
    (B) Cannot be repeated
    (C) AutoNumber is example of Primary key
    (D) All of the above

13. A collection of related tables is called
    (A) Row
    (B) Record
    (C) Database
    (D) File

14. A(n) _________ is major object that completes an action or a set of actions.
    (A) Event
    (B) Property
    (C) Procedure
    (D) Macro

15. The option group ________ describes the contents of the entire option group.
    (A) Event
    (B) Frame
    (C) Label
    (D) Value

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: