MS Access MCQ Questions and Answers - Set 04 - ObjectiveBooks

MS Access MCQ Questions and Answers - Set 04

Practice Test: Question Set - 04

1. _________ are documents that when filled in create records.
    (A) Forms
    (B) Reports
    (C) Tables
    (D) Queries

2. To print information from a table, the _________ tool is the best choice.
    (A) Form
    (B) Report
    (C) Query
    (D) Macro

3. Which of the following creates a drop down list of values to choose from?
    (A) Ole object
    (B) Hyperlink
    (C) Memo
    (D) Lookup wizard

4. Following is not a database model
    (A) Network database model
    (B) Relational database model
    (C) Object oriented database model
    (D) None

5. Which of the following is not a database object?
    (A) Tables
    (B) Queries
    (C) Relationships
    (D) Reports

6. What is the difference between ‘open’ and ‘open exclusively’
    (A) Open statement opens access database files and open exclusively opens database files of other program like oracle
    (B) Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed
    (C) Both open and open exclusively are same
    (D) Open exclusive command does not exist in MS Access

7. Which field type can store photos?
    (A) Hyperlink
    (B) Ole
    (C) Both of these can be used
    (D) Access tables can’t store photos

8. To create queries in access
    (A) You can drag and drop fields on query builders
    (B) You can type the sql command in sql view
    (C) You can use query wizard or design view
    (D) All of above

9. What do you mean by one-to-many relationship between student and class table?
    (A) One student can have many classes
    (B) One class may have many students
    (C) Many classes may have many students
    (D) Many students may have many classes

10. To achieve and effect when you are entering criteria in a query design window
    (A) Write criteria values vertically one in a row
    (B) Write criteria values horizontally
    (C) Write criteria values in same field separated with and
    (D) None of these

11. You can set a controls border type to make the border invisible.
    (A) Transparent
    (B) Invisible
    (C) Do not display
    (D) No border

12. It is most common type of query. It retrieves records from one or more tables and then displays the
    (A) Parameter
    (B) Select
    (C) Crosstab
    (D) All of above

13. The operation of checking input data against specified criteria is known as?
    (A) Data verification
    (B) Data validation
    (C) Cross check
    (D) Data control

14. The ascending order of data hierarchy is?
    (A) Bit – byte – field – record – file – database
    (B) Bit – byte – record – field – file – database
    (C) Byte – bit – field – record – file – database
    (D) Bit – byte – field – record – database – file

15. In the form wizard dialog box, the fields from the selected table are displayed in this list box.
    (A) All fields
    (B) All records
    (C) Available records
    (D) Available fields

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: