Microsoft Access MCQ - Set 01 - ObjectiveBooks

Microsoft Access MCQ - Set 01

Practice Test: Question Set - 01

1. Which of the following store command to retrieve data from database?
    (A) Forms
    (B) Reports
    (C) Queries
    (D) Tables

2. 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 student
    (C) Many classes may have many students
    (D) Many students may have many classes

3. Which of the following term is least related to database?
    (A) Attributes
    (B) Tuples
    (C) Relationship
    (D) Columns

4. A database object in MS Access that stores a question about the data in database?
    (A) Table
    (B) Form
    (C) Query
    (D) Report

5. Which of the following expresses correct order?
    (A) Characters, Fields, Records, Tables, Files, Databases
    (B) Characters, Fields, Records, Tables, Database, Files
    (C) Databases, Tables, Files, Records, Field, Character
    (D) Files, Databases, Tables, Records, Fields, Characters

6. To create primary key for a table when in design view
    (A) Type PRIMARY in field type box when creating required field
    (B) Mark the Primary check box in field name of required field
    (C) Click the Primary Key button in Design ribbon when the cursor is in required field
    (D) None of the above

7. Which of the following is not a logical database structure?
    (A) Chain
    (B) Network
    (C) Tree
    (D) Relational

8. Which type of field is incremented automatically?
    (A) Auto Elevate
    (B) AutoNumber
    (C) Auto Increment
    (D) Auto Value

9. Which tool do you use to create a query object?
    (A) Database wizard
    (B) Simple filter wizard
    (C) Simple query wizard
    (D) Table query wizard

10. How many relations may exist between tables in databases?
    (A) 4
    (B) 3
    (C) 2
    (D) 1

11. Which query do you use to answer the question “Which employees earn more than $5000 a month”?
    (A) Search query
    (B) Cross tab query
    (C) Select query
    (D) Update query

12. How to make a date field DOB store the dates like “2020/12/31”?
    (A) By setting the input mask property to “yyyy/mm/dd”
    (B) By setting the format property to “yyyy/mm/dd”
    (C) By entering dates in yyyy, mm, dd order
    (D) None of the above

13. Which leads you through the process of creating a table?
    (A) Wizard
    (B) Assistant
    (C) Relation
    (D) Coach

14. Which control types is most often associated with a bound control?
    (A) Command button
    (B) Label
    (C) Text box
    (D) List box

15. Which is not an option for customizing a datasheet window?
    (A) Change one row\’s height
    (B) Hide one column
    (C) Change one column\’s width
    (D) Freeze one column

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: