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

Product information

  • Title: Access 2007 Introduction
  • Author(s): Tim Miles
  • Release date: September 2016
  • Publisher(s): Intellezy
  • ISBN: 001071CWORKS