Top MCQ Questions & Answers MS Access - Set 28 - ObjectiveBooks

Top MCQ Questions & Answers MS Access - Set 28

Practice Test: Question Set - 28

1. In table design view, which key can be used to switch between the field names and properties panels?
    (A) F3
    (B) F4
    (C) F5
    (D) F6

2. A search value can be an exact value or it can be
    (A) Logical operator
    (B) Relationship
    (C) Wild card character
    (D) Comparison operation

3. Database access levels are specified so as to define who can access what in a database. It is identified through
    (A) User id
    (B) Password
    (C) Status
    (D) None of above

4. When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.
    (A) Text
    (B) Form
    (C) Label
    (D) Field

5. You can not import data into access database from
    (A) Dbase iii database files
    (B) Excel spreadsheets
    (C) Comma delimited text files
    (D) None of the above

6. The complete picture of data stored in database is known as
    (A) Record
    (B) Scheme
    (C) System flowchart
    (D) Dbms

7. If a piece of data is stored in two places in the database, then a
    (A) Storage space is wasted
    (B) Changing the data is one spot will cause data inconsistency
    (C) It can be more easily accessed
    (D) Both ‘a’ and ‘b’

8. The filter by selection feature allows you to filter:
    (A) Those records that match an entity in a field
    (B) Records based on a criterion you specify
    (C) Records that meet any of several criteria you specify
    (D) All of above

9. A small button with three dots usually displayed at the right of field properties box
    (A) Make button
    (B) Expression button
    (C) Build button
    (D) None of above

10. Which of the following is not a field type in Access?
    (A) Memo
    (B) Hyperlink
    (C) OLE Object
    (D) Lookup Wizard

11. What is the maximum length a text field can be?
    (A) 120
    (B) 255
    (C) 265
    (D) 75

12. Which criteria return only those addresses beginning with the letter “K”?
    (A) address = “K”
    (B) address = “K*”
    (C) address = “K?”
    (D) address = “K#”

13. Which of the following is use to get data from user?
    (A) Query
    (B) Pages
    (C) Form
    (D) Report

14. A(n)_______ is a major object that can run independent of a control.
    (A) Event
    (B) Property
    (C) Procedure
    (D) Macro

15. In a query, what symbol is used to surround a parameter\’s user prompt?
    (A) [ ]
    (B) { }
    (C) ” ”
    (D) ( )

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: