Microsoft Access - Set 2

10 Questions | Total Attempts: 9614

Settings
Please wait...
Microsoft Access - Set 2

Online MCQ Quiz on Microsoft Access - Set 2 No. Of Questions:- 10 Time:- 10 Minutes Full Mark:- 100 Pass Mark:- 70 This Quiz is for those user who wants to test their knowledge in Microsoft Access. For more MCQ Questions and Online Quizzes please visit https://www. McqQuestions. Com  


Questions and Answers
  • 1. 
    Which object is used to create a form?
    • A. 

      Tables and Queries

    • B. 

      Tables only

    • C. 

      Tables and reports

    • D. 

      Queries and reports

  • 2. 
    What determines a table’s sort order?
    • A. 

      AutoNumber field

    • B. 

      Index field

    • C. 

      Field order

    • D. 

      Primary key

  • 3. 
    What is an intersection of a row and a column?
    • A. 

      Form

    • B. 

      Cursor

    • C. 

      Cell

    • D. 

      Record

  • 4. 
    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

  • 5. 
    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

  • 6. 
    What is the purpose of indexing?
    • A. 

      To reduce table size

    • B. 

      To speedup data search

    • C. 

      Both A and B

    • D. 

      None of the all

  • 7. 
    Which is the valid data type in Access?
    • A. 

      Number

    • B. 

      Text

    • C. 

      Currency

    • D. 

      All of the above

  • 8. 
    • A. 

      4

    • B. 

      3

    • C. 

      2

    • D. 

      1

  • 9. 
    What is the full form of SQL?
    • A. 

      Sophisticated Question List

    • B. 

      Structured Question List

    • C. 

      Structured Query Language

    • D. 

      Small Query Length

  • 10. 
    Which data type is better to use for storing phone number in the following format “977-1-1234567”?
    • A. 

      Text

    • B. 

      AutoNumber

    • C. 

      Number

    • D. 

      Currency