Error

Invalid column name 'Price'.

Access 2007 - Beginner

 Jump to Course Request Form

Course Overview

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.

Course Objectives

Introducing Access 2007, Opening An Existing Database, Creating a New Table Using Datasheet View, Adding Records to a Table, Finding Data, An Overview on Queries, Forms, Reports, Create A New Table In Design View

Course Outline

1 - Introduction

  • Introduction

2 - Introducing Access 2007

  • Starting Access
  • Navigating the Main Screen
  • Using the Quick Access Toolbar and Ribbon
  • Using the Navigation Pane
  • Navigating in the Document Window

3 - Opening An Existing Database

  • Opening a Table
  • Navigating a Table
  • Using Quick Search
  • Using Quick Filter

4 - Creating a New Table Using Datasheet View

  • Adding Fields
  • Changing the Data Type
  • Adding a Lookup Field
  • Deleting a Field

5 - Create A New Table In Design View

  • Understanding The Design View
  • Setting Input Masks
  • Using The Lookup Tab
  • Indexing A Table 

6 - Adding Records to a Table

  • Adding a Record
  • Using Zoom Mode
  • Using Shortcut Keys
  • Filtering Data

7 - Finding Data

  • Using the Find Dialog Box
  • Using Replace
  • Deleting Records
  • Changing Table Appearance

8 - An Overview on Queries

  • Understanding Query Types
  • Using the Query Wizard
  • Using the Query Design View
  • Using the QBE Grid
  • Entering Criteria
  • Creating a Query Manually
  • Using Logical Operators in Criteria
  • Using Wildcards in Criteria

9 - Forms

  • Understanding Forms
  • Creating a New Form
  • Using the Form Design Window
  • Selecting, Moving, and Resizing Controls

10 - Reports

  • Understanding Report Design Steps
  • Creating a Report
  • Modifying Controls in a Report
  • Basing a Report on a Query
  • Adjusting and Printing a Report

11 - Conclusion

  • Course Recap