RESOURCES : MICROSOFT ACCESS QUIZ
 
    Please click in the text fields below and enter the information requested.
  • First Name:   


  • Last name:l   


  • Email: l      l    

    Answer the questions below. 
    For each item, select an option. When finished, click the "Check Score" button.
    1. Which software program can be used to store data points?
      A.  Microsoft Word
      B.  Microsoft Excel
      C.  Microsoft Access
      D.  All of the above
    2. Which software program is best suited to storing and then searching for data that meet specific criteria?
      A.  Microsoft Word
      B.  Microsoft Excel
      C.  Microsoft Access
      D.  All of the above
    3. Which of the following best describes the following four Objects: Tables, Queries, Forms, Reports?
      A.  Info grids, Extraction questions, Inputting assistance, Printed summaries
      B.  Printed summaries, Extraction questions, Info grids, Info grids
      C.  Info grids, Extraction questions, Printed summaries, Inputting assistance
      D.  Extraction questions, Inputting assistance, Printed summaries, Info grids
    4. Microsoft Access employs many “wizards” to help you get things done. What are these “wizards”?
      A.  Wizards are the little characters that appear in the corner of your screen in Microsoft
                   programs and make helpful suggestions as you work
      B.  Wizards are mini-programs that guide you through a specific process, like creating a Table
                    in Microsoft Access
      C.  Wizards are synonymous with macros
      D.  Wizards are synonymous with the toolbar icons
    5. When you input data into a Form, where does it end up?
      A.  In the Queries Object
      B.  In the Reports Object
      C.  With the wizard
      D.  In the Tables Object
    6. Which of the following fields would make the best selection as Primary Key (assuming that the database is restricted to US citizens)?
      A.  Social Security Number
      B.  Birth date
      C.  Last name
      D.  Mother’s maiden name
    7. What’s the biggest difference between the Datasheet view of a Table and the Design view of a Table?
      A.  Design view of a Table displays the actual data and Datasheet view doesn’t
      B.  Datasheet view of a Table displays the actual data and Design view doesn’t
      C.  A data record can only be deleted in Datasheet view
      D.  A data record can only be added in Design view
    8. If you want to program a specific column in your Table to accept telephone numbers and to automatically format them such that the 3-digit area code is in parentheses and there is a dash after the next three digits, you should use the:
      A.  Input Mask function
      B.  Validation Rule function
      C.  Index function
      D.  Caption function
    9. It is better to use a Query rather than a Filter, if
      A.  You search your database for records that meet specific criteria but you are unlikely to carry
                    out this same search again
      B.  You often search your database for records that meet varying criteria
      C.  You often search your database for records that meet specific criteria
      D.  You often search your database for fields that meet varying criteria
    10. How do you create the best-looking, printed version of your data?
      A.  Go to the Datasheet view of your table, click FILE and then click PRINT
      B.  Go to the Design view of your table, click FILE and then click PRINT
      C.  Go to the Forms object, click on the name of the form you wish to print, click FILE and then
                    click PRINT
      D.  Go to the Reports object, click on the name of the report you wish to print, click FILE and
                    then click PRINT