Creating a Table in Datasheet View–Read and do pages AC11 to AC22–WATCH THIS VIDEO

  1. REVIEW
    1. When you are viewing the Backstage view, which of the following is not one of the options?
      1. opening database templates
      2. creating a new database
      3. opening an existing database
      4. modifying content from Microsoft Office Online
    2. A(n) ________ is a predesigned database that includes professionally designed tables, reports, and other database objects that can make it quick and easy for you to create a database.
    3. The new blank table that Access creates is displayed in ___________ view.
  2. You enter data into the table in Datasheet view. In a later module, they will learn how to add records in other ways. As you enter records, they will be placed in the table in the order in which they were entered. However, when you close the table and open it again, the records will be ordered according to the primary key order. The navigation bar at the bottom of Datasheet view will indicate how many records are in the table and what the current record is (i.e., the record on which the insertion point currently rests).
  3. Access 2016 allows you to save using the Sky Drive to store the database. To use it you must have an account and log in to save and retrieve files.
  4. Quick Quiz
    1. The _____ data type allows values that contain digits, a decimal point, commas, a plus sign, and a minus sign.
      1. Currency
      2. AutoNumber
      3. Number
      4. Yes/No
    2. The field name can consist of up to ____________ characters.
    3. True or False: After you add fields and records to a table, Access automatically saves the table’s design.
  5. Look at the projects you created today. Notice how important the database name is.

Closing a Table and Exiting Access–Read and do pages AC22 to AC23–WATCH THIS VIDEO

  1. REVIEW:
    1. The _____ data type allows values that contain digits, a decimal point, commas, a plus sign, and a minus sign.
      1. Currency
      2. AutoNumber
      3. Number
      4. Yes/No
    2. The field name can consist of up to ____________ characters.
    3. True or False: After you add fields and records to a table, Access automatically saves the table’s design.
  2. It is easy to make the mistake of changing data in open tables without realizing it. This short section explains why you should close tables to avoid unintended changes.
  3. Quick Quiz
    1. Closing a table before exiting Access is a good practice because:
      1. The changes will not be saved if you exit Access first
      2. It prevents unintended changes being made in the table
      3. You cannot exit Access with open tables
      4. All of the above
    2. The Close button is located on the _____________.
    3. True or False: Exiting Access will automatically close all open tables first.