IC3 Lesson 22 SG

Document Sample
IC3 Lesson 22 SG Powered By Docstoc
					IC3 Lesson 22 Study Guide

Indicate whether the statement is true or false.

____    1. Access is a database program.
____    2. The Access screen is similar to other Office 2007 applications.
____    3. You can open multiple databases at a time in an Access window.
____    4. Objects are organized into categories in the Navigation Pane.
____    5. When you create a new database, the first step is to name the database file.
____    6. You cannot use the Save As command to name and save objects in the database.
____    7. You can create as many tables as you need to store the information for a database.
____    8. You can only add fields in Design view.
____    9. Unlike Word and Excel, Access does not have a standard document view.
____ 10. Once you have deleted a record, you can use the Undo command to restore it.

Modified True/False
Indicate whether the statement is true or false. If false, change the identified word or phrase to make the statement true.

____ 11. A query is an object that organizes data in a specific layout. ____________________
____ 12. You can use the Save As command to save the entire database under a new name. ____________________
____ 13. At least one table must be created before any additional objects can be created. ____________________
____ 14. Datasheet view shows details about the structure of the object, including the data type and the field properties.
____ 15. The default Field Size property for the Text data type is 50 characters. ____________________

Complete each statement.

       16. A table is often referred to as a(n) ____________________.
       17. A(n) ____________________ is a collection of related information.
       18. The intersection of a row and a column is called a(n) ____________________, just as in an Excel worksheet.
       19. When you enter data into a cell, it is called a(n) ____________________.
       20. If you make a mistake adding or editing data in a record, you can choose the ____________________
           command to reverse your last action.


            Identify the letter of the choice that best matches the phrase or definition.
             a.   table
             b.   field
             c.   field name
             d.   record
             e.   primary key
____   21.   A single piece of database information.
____   22.   A unique identifier for each record in the table.
____   23.   A group of related fields in a database.
____   24.   The primary object in the database.
____   25.   A label that helps identify the field.
IC3 Lesson 22 Study Guide
Answer Section


      1.   ANS:   T         PTS:   1
      2.   ANS:   T         PTS:   1
      3.   ANS:   F         PTS:   1
      4.   ANS:   T         PTS:   1
      5.   ANS:   T         PTS:   1
      6.   ANS:   F         PTS:   1
      7.   ANS:   T         PTS:   1
      8.   ANS:   F         PTS:   1
      9.   ANS:   T         PTS:   1
     10.   ANS:   F         PTS:   1


     11. ANS: F, report

         PTS: 1
     12. ANS: F
         can not

         PTS: 1
     13. ANS: T                        PTS: 1
     14. ANS: F, Design

         PTS: 1
     15. ANS: F, 255

           PTS: 1


     16. ANS: datasheet

         PTS: 1
     17. ANS: database

         PTS: 1
     18. ANS: cell

           PTS: 1
   19. ANS: entry

       PTS: 1
   20. ANS: Undo

         PTS: 1


   21.   ANS:   B   PTS:   1
   22.   ANS:   E   PTS:   1
   23.   ANS:   D   PTS:   1
   24.   ANS:   A   PTS:   1
   25.   ANS:   C   PTS:   1

Shared By: