Understanding Access (And Additional MS Office Questions)

10 Questions | Total Attempts: 128

SettingsSettingsSettings
Please wait...
Microsoft Office Quizzes & Trivia

The objective portion of this test will assess your conceptual understanding of a relational database, and additional features and functions of other MS Office applications.


Questions and Answers
  • 1. 
    Tables are set up to contain columns and rows of information. In a database table, the columns are called ____.
    • A. 

      Fields

    • B. 

      Records

    • C. 

      Data points

    • D. 

      Categories

  • 2. 
    A database and table are one in the same.
    • A. 

      True

    • B. 

      False

  • 3. 
    In a database form, the blanks in which information is entered are called _________. When the blanks are filled in, the form represents a _______.  (Note: There are two (2) correct answers, please select both in order for your answer to be scored correctly.)
    • A. 

      Fields

    • B. 

      Query

    • C. 

      Record

    • D. 

      Database

  • 4. 
    A macro in Access performs a function comparable to a conditional statement in Excel
    • A. 

      True

    • B. 

      False

  • 5. 
    Examples of objects associated with a database include: ________________.  Please check all the apply.
    • A. 

      Table

    • B. 

      Query

    • C. 

      Report

    • D. 

      Form

  • 6. 
    The unique identifier associated with each record is called a ______________
    • A. 

      Connector

    • B. 

      Primary key

    • C. 

      Conjoiner

    • D. 

      Id number

  • 7. 
    You want to create a new query that pulls fields from a table and an existing query within the same database. In order to pull data from these objects, you must first build a ________ between them. First, you should drag the table's _______ to the related field in the query.   (Check the two(2) answers that best complete these sentences.)
    • A. 

      Connector

    • B. 

      Relationship

    • C. 

      Foreign link

    • D. 

      Primary key

  • 8. 
    You decide to create a chart depicting your Excel data.  You notice that "Chart Tools" now appear in the Title bar, and there are _________ tabs with functions that are available only when the chart is selected
    • A. 

      Easy access

    • B. 

      Graphic interface

    • C. 

      Contextual

    • D. 

      Extraneous

  • 9. 
    In PowerPoint 2007, it's important to remember that audio and video files are ________ .
    • A. 

      Imbedded not linked

    • B. 

      Linked not imbedded

    • C. 

      Imbedded and linked

  • 10. 
    As a result of my active participation in this class, I can now ______________, ________________, and __________________.  (Note:  Your answer should reference three (3) specific features and functions of an application you learned or perhaps skills you developed or refined.)
Back to Top Back to top