FINISH: 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.

Copying Records from Another Access Database–Read and do pages AC24 to AC29–WATCH THIS VIDEO

  1. REVIEW:
    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.
  2. There are many other ways to enter records in a table, including copying and pasting records from a table into the same database or into a different database. To use this method, however, the two tables must have the same structure—that is, the tables must contain the same fields, with the same design, in the same order.
  3. Quick Quiz:
    1. To select all the records in a table, click the __________.
      1. copy button
      2. field name
      3. clipboard button
      4. datasheet selector
    2. True or False: You can open a table from the Getting Started with Microsoft Access page.
    3. True or False: To copy and paste records from one database to another, the tables must have the same structure.
  4. What two ways have you learned so far to input information into a table?
  5. Give an example of when you might want to combine the information from two databases.

Navigating a Datasheet–Read and do pages AC29 to AC30–WATCH THIS VIDEO

  1. REVIEW:
    1. To select all the records in a table, click the __________.
      1. copy button
      2. field name
      3. clipboard button
      4. datasheet selector
    2. True or False: You can open a table from the Getting Started with Microsoft Access page.
    3. True or False: To copy and paste records from one database to another, the tables must have the same structure.
  2. Be sure you know how to view fields or records not currently visible in the datasheet using the horizontal and vertical scroll bars shown in Figure 1-20 to navigate the data, as well as the navigation buttons.
  3. Figure 1-20 shows which record becomes the current record when you click each navigation button. Note the New record button, which works in the same way as the New button on the Home tab you used earlier to enter a new record in the table.
  4. Quick Quiz:
    1. True or False: You can make a field the current field by clicking anywhere within the column for that field.
    2. True or False: If the Current Record box displays “5 of 65,” the 65th record is the current record.
  5. What two methods can be used to move through records in a table? 
  6. SHOW ME WHEN YOU ARE DONE WITH PAGE 30!!