MS Access - Final Exam

1 Question | Total Attempts: 11911

SettingsSettingsSettings
Please wait...
MS Access - Final Exam

Getting some basic computer knowledge is something that most people are required to have in any business field. There are different computer applications used on a daily. How good are you when it comes to Me access? Take up the quiz below and get to increase your understanding in the use of the application before you get tested. All the best!


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

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

      Number

    • B. 

      Text

    • C. 

      Currency

    • D. 

      All of the above

  • 8. 
    How many relations may exist between tables in databases?
    • 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

  • 11. 
    What do you call a collection of records matching parameters of a query?
    • A. 

      Field

    • B. 

      Record

    • C. 

      Query

    • D. 

      Dynaset

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

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

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

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

      Address = “K”

    • B. 

      Address = “K*”

    • C. 

      Address = “K?”

    • D. 

      Address = “K#”

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

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

  • 18. 
    What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
    • 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

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

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

  • 21. 
    In an application created using the database wizard, the main menu is presented as a:  
    • A. 

      Form, called a switchboard

    • B. 

      Report, called a menu

    • C. 

      Table, called a switchboard

    • D. 

      Query, called a menu

  • 22. 
    Which leads you through the process of creating a table?
    • A. 

      Wizard

    • B. 

      Assistant

    • C. 

      Relation

    • D. 

      Coach

  • 23. 
    Which data type is better to use for storing the price of an item?
    • A. 

      Text

    • B. 

      AutoNumber

    • C. 

      Number

    • D. 

      Currency

  • 24. 
    Which do you click to display the table’s primary key and indexes in a separate window?
    • A. 

      Indexes button

    • B. 

      Primary key button

    • C. 

      View datasheet button

    • D. 

      View design button

  • 25. 
    After right click the field selector button, which do you choose to delete a field in design view?
    • A. 

      Delete field

    • B. 

      Delete rows

    • C. 

      Remove field

    • D. 

      Remove rows