Microsoft Access - Set 3

10 Questions | Total Attempts: 8591

SettingsSettingsSettings
Please wait...
Microsoft Access - Set 3

Online MCQ Quiz on Microsoft Access - Set 3 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. 
    What do you call a collection of records matching parameters of a query?
    • A. 

      Field

    • B. 

      Record

    • C. 

      Query

    • D. 

      Dynaset

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

  • 3. 
    In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
    • A. 

      Zipcode, firstname, lastname

    • B. 

      Firstname, lastname, zipcode

    • C. 

      Zipcode, lastname, firstname

    • D. 

      Can’t sort by multiple fields

  • 4. 
    What does the expression [detail] ! [product] * 1.30 do?
    • A. 

      Multiplies the contents of detail and product fields by 1.3

    • B. 

      First divides detail by product and then multiplies by 1.3

    • C. 

      Multiplies the contents of detail in the product table by 1.3

    • D. 

      Multiplies the contents of product in the detail table by 1.3

  • 5. 
    Which criteria return only those addresses beginning with the letter “K”?
    • A. 

      Address = “K”

    • B. 

      Address = “K*”

    • C. 

      Address = “K?”

    • D. 

      Address = “K#”

  • 6. 
    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”

  • 7. 
    Which query do you use to answer the question “What is the average salary of the employees”?
    • A. 

      Search query

    • B. 

      Cross tab query

    • C. 

      Select query

    • D. 

      Update query

  • 8. 
    • A. 

      Display all customers with CustID from 10 to 100

    • B. 

      Display all customers with CustID above 10

    • C. 

      Display all customers with CustID below 100

    • D. 

      Display all customers with CustID from 11 to 99

  • 9. 
    How to make a date field DOB store the dates like “2002/10/17” ?
    • 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

  • 10. 
    You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
    • A. 

      By setting required to ‘Yes’

    • B. 

      By using default value

    • C. 

      By defining validation rule

    • D. 

      By using format