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. Access 2007 Introduction
    1. Starting Access 00:02:07
    2. The Main Screen 00:00:57
    3. Using The Quick Access Toolbar And Ribbon 00:01:22
    4. Navigation Pane 00:01:08
    5. 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. Create A New Table Using The 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. Create 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. 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. Conclusion 00:01:32

Product Information

  • Title: Access 2007 Introduction
  • Author(s): Tim Miles
  • Release date: January 2013
  • Publisher(s): Intellezy
  • ISBN: 00006COMPUWORKS