You are previewing Access 2007 Introduction.
O'Reilly logo
Access 2007 Introduction

Video Description

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

Table of Contents

  1. Introduction
    1. Introduction 00:00:53
  2. Introducing Access 2007
    1. Starting Access 00:02:07
    2. Navigating the Main Screen 00:00:57
    3. Using the Quick Access Toolbar and Ribbon 00:01:22
    4. Using the Navigation Pane 00:01:08
    5. Navigating in the Document Window 00:02:17
  3. Opening An Existing Database
    1. Opening a Table 00:02:40
    2. Navigating a Table 00:02:27
    3. Using Quick Search 00:00:42
    4. Using Quick Filter 00:04:57
  4. Creating a New Table Using Datasheet View
    1. Adding Fields 00:02:39
    2. Changing the Data Type 00:04:53
    3. Adding a Lookup Field 00:02:38
    4. Deleting a Field 00:01:01
  5. Creating a New Table in Design View
    1. Understanding the Design View 00:07:23
    2. Setting Input Masks 00:02:21
    3. Using the Lookup Tab 00:01:19
    4. Indexing a Table 00:05:04
  6. Adding Records to a Table
    1. Adding a Record 00:03:04
    2. Using Zoom Mode 00:01:45
    3. Using Shortcut Keys 00:04:25
    4. Filtering Data 00:02:36
  7. Finding Data
    1. Using the Find Dialog Box 00:02:21
    2. Using Replace 00:01:05
    3. Deleting Records 00:02:01
    4. Changing the Table Appearance 00:05:13
  8. An Overview on Queries
    1. Understanding Query Types 00:00:57
    2. Using the Query Wizard 00:05:21
    3. Using the Query Design View 00:05:00
    4. Using the QBE Grid 00:03:29
    5. Entering Criteria 00:06:46
    6. Creating a Query Manually 00:04:43
    7. Using Logical Operators in Criteria 00:04:21
    8. Using Wildcards in Criteria 00:08:04
  9. Forms
    1. Understanding Forms 00:01:13
    2. Creating a New Form 00:07:32
    3. Using the Form Design Window 00:03:33
    4. Selecting, Moving, and Resizing Controls 00:17:00
  10. Reports
    1. Understanding Report Design Steps 00:01:20
    2. Creating a Report 00:05:38
    3. Modifying Controls in a Report 00:08:28
    4. Basing a Report on a Query 00:03:31
    5. Adjusting and Printing a Report 00:02:09
  11. Conclusion
    1. Course Recap 00:01:32