Take this
course

Office Productivity / Microsoft

Access 2007 Introduction

Learn the basic functionality and interface of Access 2007.

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.


Instructor: Timothy Miles


Full details

Curriculum

  • Introduction
    Introduction
    0:53
    Course Exercise Files
  • Introducing Access 2007
    Starting Access
    2:08
    Navigating the Main Screen
    0:58
    Using The Quick Access Toolbar And Ribbon
    1:23
    Using the Navigation Pane
    1:09
    Navigating in the Document Window
    2:18
  • Opening an Existing Database
    Opening A Table
    2:41
    Navigating A Table
    2:28
    Using Quick Search
    0:43
    Using Quick Filter
    4:57
  • Creating a New Table Using Datasheet View
    Adding Fields
    2:40
    Changing The Data Type
    4:54
    Adding a Lookup Field
    2:39
    Deleting A Field
    1:01
  • Adding Records to a Table
    Adding a Record
    3:04
    Using Zoom Mode
    1:46
    Using Shortcut Keys
    3:33
    Filtering Data
    2:36
  • Finding Data
    Using the Find Dialog Box
    2:22
    Using Replace
    1:06
    Deleting Records
    2:02
    Changing The Table Appearance
    4:30
  • An Ovevriew on Queries
    Understanding Query Types
    0:58
    Using the Query Wizard
    5:22
    Using the Query Design View
    5:01
    Using the QBE Grid
    3:30
    Entering Criteria
    6:47
    Creating a Query Manually
    4:44
    Using Logical Operators in Criteria
    4:22
    Using Wildcards in Criteria
    8:04
  • Forms
    Understanding Forms
    1:14
    Creating A New Form
    7:33
    Using the Form Design Window
    3:34
    Selecting, Moving and Resizing Controls
    17:01
  • Reports
    Undersatnding Report Design Steps
    1:21
    Creating a Report
    5:39
    Modifying Controls in a Report
    8:29
    Basing a Report On a Query
    3:32
    Adjusting and Printing A Report
    2:10
  • Conclusion
    Course Recap
    1:33

Skills

  • Microsoft Access

Similar Courses

More Courses by this Instructor