1-866-245-5224 sales@keystonelearning.com

Access 2007: Access 2007 Course Overview (All Levels)

Access 2007: Access 2007 Course Overview (All Levels)

The Access 2007 Course contains three levels: Beginner, Intermediate and Advanced. You can view the topics by level by clicking the links below:

Level 1: Beginner

Level 2: Intermediate

Level 3: Advanced

Access 2007 Beginner Course Overview

Part of the Microsoft Office 2007 suite, Access 2007 is Microsoft’s powerful database management program whose primary purpose is to help  you track and manage large amounts of data. And, Access 2007 is better than ever. This beginner-level course will help familiarize you with the fundamentals of Access 2007 to help you get started using the commanding program quickly.



Specific topics include:



Getting Started

    About Relational Databases and Access 2007

    Launching Access 2007

    Touring the Access Environment

    Using the Office Menu

    Database Components

    Using the Navigation Pane

    Getting Help

    Opening & Closing Access Databases

    Creating an Access Database Using a Preloaded Template



Working with an Existing Table

    Exploring Datasheet View

    Editing & Selecting Table Data

    Adding & Deleting Records

    Find & Replace

    Undo & Redo



Working with an Existing Form



    Exploring Form View

    Editing & Selecting Form Data

    Adding & Deleting Records

    Find & Replace

    Sorting & Filtering

    Sorting a Table and a Form



About Filters

    Common Filters

    Filter by Selection

    Filter by Form

    Advanced Filter



Designing Select Queries

    Using the Query Wizard

    Using Query Design View

    Using Criteria

    Sorting and Showing Query Fields

    Adding Tables to a Query



Form Basics

    Using the Forms Wizard

    Using the Form Tool

    Working with Form Design View

    Working with Form Layout View

    Working with Form Controls



Report Basics

    Using the Reports Wizard

    Using the Report Tool

    Working with Report Design View

    Working with Report  Layout View

    Working with Report Controls



Printing Database Objects

    Printing Tables or Queries

    Printing Forms

    Printing Reports



Return to Top



Access 2007 Intermediate Course Overview

Part of the Microsoft Office 2007 suite, Access 2007 is Microsoft’s powerful database management program whose primary purpose is to help  you track and manage large amounts of data. And, Access 2007 is better than ever. This intermediate-level course will help familiarize you with some of the more advanced features of Access 2007 to help you continue your database building with Access 2007.



Specific topics include:



Planning & Designing a Database

    Database Design Process

    Creating a Database Using a Wizard

    Creating a Database from Scratch



Building & Modifying Tables

    Creating a Table Using a Table Template

    About Data Types

    Creating a Table in Datasheet View

    Creating a Table in Design View

    Using Field Templates

    Setting Primary Keys



Working with Relationships

    Types of Relationships

    Referential Integrity

    Cascading Updates and Deletes

    Multi-Valued Fields

    Printing Relationships



Sharing Your Data

    Export Your Access Report to Word

    Export Your Access Table to Excel

    Import Your Excel Spreadsheet into Access

    Copying the Table Structure and Data



Enhancing Your Forms

    Using the Field List Task Pane

    Using the Forms Controls Group

    Adding & Formatting Labels

    Adding Graphics

    Adding Command Buttons



Enhancing Your Reports

    Using the Reports Control Group

    Adding Graphic Details

    Working with White Space and Report Width



Return to Top



Access 2007 Advanced Course Overview

Part of the Microsoft Office 2007 suite, Access 2007 is Microsoft’s powerful database management program whose primary purpose is to help  you track and manage large amounts of data. And, Access 2007 is better than ever. This advanced-level course will help familiarize you with advanced features of Access 2007 to help you continue your database building with Access 2007.



Specific topics include:



Preventing Data Entry Errors

    Using the Lookup Wizard

    Data Validation

    Working with Combo Boxes

    Working with List Boxes



Advanced Table Design

    Field Properties

    Using Input Masks

    Using the Datasheet Total Row

    Using Rich Text in the Memo Field



Advanced Query Design

    Creating a Calculated Field

    Creating a Crosstab Query



Advanced Form Design

    Split Forms

    Working with the Property Sheet

    Changing Control Tab Order

    Conditional Formatting

    Adding Tab Pages



Advanced Report Design

    Creating Groups & Total Reports

    Working with Total Fields

    Adding Calculated Controls to a Report



Managing Databases

    Identify Object Dependencies

    Database Documenter



Return to Top



Access 2007 Expert Course Overview



Part of the Microsoft Office 2007 suite, Access 2007 is Microsoft’s powerful database management program whose primary purpose is to help  you track and manage large amounts of data. And, Access 2007 is better than ever. This expert-level course will help familiarize you with more advanced features of Access 2007 to help you continue your database building with Access 2007.



Specific topics include:



Expertly Designed Select Queries

    Single Parameter Queries

    Multiple Parameter Queries

    Query Joins



Action Queries

    Types of Action Queries

    Update Queries

    Append Queries

    Make Take Queries

    Delete Queries



Expertly Designed Forms

    Creating a Lookup Field

    Using a Bitmap as a Form Background

    Adding Calculated Controls to a Form



Expertly Designed Reports

    Setting Section Properties

    Adding Graphics

    Arranging Report Data Into Columns



Macros

    Create a Macro

    Edit a Macro

    Attach a Macro to a Command Button



Database Security

    About Database Security

    Using a Database Password



Return to Top