MS Access - Final Exam 1

50 Questions | Total Attempts: 240

SettingsSettingsSettings
Please wait...
MS Access - Final Exam 1

MS Access - Final Exam created by Mr. Mike Laguisma


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

      Tables and Queries

    • B. 

      Tables only

    • C. 

      Tables and reports

    • D. 

      Queries and reports

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

      AutoNumber field

    • B. 

      Index field

    • C. 

      Field order

    • D. 

      Primary key

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

      Form

    • B. 

      Cursor

    • C. 

      Cell

    • D. 

      Record

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

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

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

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

      Number

    • B. 

      Text

    • C. 

      Currency

    • D. 

      All of the above

  • 9. 
    How many relations may exist between tables in databases?
    • A. 

      4

    • B. 

      3

    • C. 

      2

    • D. 

      1

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

      Sophisticated Question List

    • B. 

      Structured Question List

    • C. 

      Structured Query Language

    • D. 

      Small Query Length

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

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

      Field

    • B. 

      Record

    • C. 

      Query

    • D. 

      Dynaset

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

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

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

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

      Address = “K”

    • B. 

      Address = “K*”

    • C. 

      Address = “K?”

    • D. 

      Address = “K#”

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

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

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

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

  • 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

Back to Top Back to top