Access Training at The Learning Center

Currently Not Logged In (Click here to login to E-Learning)

The Learning Center of Las Vegas, Nevada offers Computer Professional and Certification training and testing for Microsoft, MCSE, MCAD, MCDBA, MCSD, .Net, CISCO, A+, Network+, and many applications including Microsoft Office.


Serving Your Training Needs Since 1985
Click on the links for the course you need information for: Access XP / 2003 Beginning Access XP / 2003 Intermediate Access XP / 2003 Advanced Access 2000 Beginning Access 2000 Intermediate Access 2000 Advanced Access 2000 Upgrade Access 97 Beginning Access 97 Intermediate Access 97 Advanced Access Module If a link doesn’t contain the information you require now, please check back soon or call 702-320-8885 for more details.

Access XP / 2003 Beginning

Length of Course:	1 day
Prerequisites:	Excel XP Beginning and Intermediate
Course Objective:	This course teaches students how to manage databases, create tables with and without the wizard, customize the tables fields and properties; filter and search for specific data; create relationships. You will learn the ins and outs of Queries along with simple Reports and Printing.

Course Outline:

Exploring Access

Opening a Database

Using Database Objects

Opening a Database Object

Using a Task Pane

Creating Tables

Using the Database Wizard

Creating a New Database

Designing Tables

Creating a Table in Design View

Using Design View

Adding Field Names

Assigning Data Types

Adding a Field Description

Setting a Primary Key

Saving a New Table

Using the Table Wizard

Setting Field Properties

Using Field Properties

Limiting Field Size

Setting Number Formats

Setting Date/Time Formats

Setting Yes/No Formats

Setting Default Values and Validation Rules

Typing a Lookup List

Modifying Lookup Properties

Working With Tables

Using Datasheet View

Navigating Fields in Tables

Adding Records

Moving through Records

Selecting Records

Editing Records

Saving Records

Deleting Records

Modifying Tables

Selecting a Column

Changing the Column Width

Changing the Row Height

Moving a Column

Inserting a Column Into a Table

Changing a Column Name

Deleting a Column

Hiding and Unhiding a Column

Freezing a Column

Changing a Font Attribute

Changing a Cell Effect

Inserting a Lookup or a Hyperlink Column

Finding and Filtering Data

Sorting and Finding Specific Records

Finding Records using Wildcards

Using Replace and Filter by Selection

Applying/Removing a Filter

Using Filter Excluding Selection

Using Filter For and Filter by Form

Creating Relationships

Using Related Tables

Creating a Relationship between Tables

Setting Referential Integrity

Viewing Subdatasheets

Deleting a Join Line

Creating a Many-to-Many Relationship

Using Simple Queries

Using Queries and Recordsets

Using the Simple Query Record

Creating a Query in Design View

Opening a Query

Adding a Table to a Query

Joining Tables in a Query

Running a Query

Modifying Query Results

Sorting a Query

Adding Criteria to a Query

Hiding a Field in a Query

Adding a Record Using a Query

Printing a Query

Creating Basic Forms

Using Forms and the Form Wizard

Viewing and Printing Records in a Form

Basing a Form in a Query

Using AutoForm

Adding a Record Using a Form

Creating Basic Reports

Using Reports and the Report Wizard

Using Print Preview – Reports

Printing Pages of a Report

Grouping and Summarizing Report Data

Basing a Report on a Query

Using AutoReport

Printing Data

Printing Table Data

Changing Page Setup

Using Print Preview

Printing Selected Records

Return to the top of the Page

Access XP / 2003 Intermediate

Length of Course:	1 day
Prerequisites:	Excel XP Beginning and Intermediate
Course Objective:	This course teaches students how to create different types of Queries with and without the wizard. You will learn how to created and use Forms and Reports with all the customizable features.

Course Outline:

Table Properties – Input Masks

Creating an Input Mask - Wizard

Creating an Input Mask Manually

Creating a Custom Input Mask

Using Operators in Queries

Using Comparison Operators

Using an And Condition

Using an Or Condition

Using the Between and Operator

Using the Expression Builder

Using a Wildcard Character

Designing Advanced Queries

Setting Top Values in a Query

Creating and Formatting a Calculated Field

Creating a Function and a Parameter Query

Creating a Concentration in a Query

Filtering a Query

Creating Action Queries

Creating a Make-table Query

Creating an Update and an Append Query

Creating a Delete Query

Using Advanced Query Wizards

Using the Crosstab Query Wizard

Using the Find Duplicates Query Wizard

Using the Find Unmatched Query Wizard

Manipulating Control

Using Controls

Selecting Non-adjacent and Adjacent Controls

Deleting Controls

Sizing a Control by Dragging

Moving Controls

Sizing Controls Automatically

Viewing the Properties of an Object

Changing a Control Property

Using Advanced Form Design

Using Forms in Design View

Creating a Combo and a List Box

Creating an Option Group

Adding a Logic Control

Setting the Tab Order Automatically and Manually

Adding a Form Header and Footer

Creating a Blank Form

Using Advanced Report Design

Adding Report Sections in Design View

Creating a Calculated Control

Grouping Data in a Report

Creating Group Headers and Footers

Creating a Running Summary

Inserting a Date/Time Control

Inserting a Page Break

Changing the Report Margins

Using the Label Wizard

Creating a Report without Using a Wizard

Using Editing Tools

Selecting Objects with the Toolbar

Changing the Font and the Font Size

Changing the Character Format

Changing the Font Color

Changing Fill and Background Colors

Formatting Lines and Borders

Applying Special Effects

Using the Format Painter and AutoFormat

Running the Spell Checker

Using Advanced Database Features

Importing Data

Linking Data to an Access Table

Using the Linked Table Manager

Exporting Data and Converting Files

Printing a Relationship Document

Creating a Data Access Page – Page Wizard

Compacting a Database

Using Name AutoCorrect

Backing Up a Database

Setting AutoCorrect Options and Entries

Return to the top of the Page

Access XP / 2003 Advanced

Length of Course:

2 day

Prerequisites:

Access XP / 2003 Beginning and Intermediate

Course Objective: This course teaches students how to master Access by using macros and switchboards, subforms and ActiveX Controls. You will learn to customize by creating custom toolbars and setting up passwords.

Course Outline:

Charts

Creating a Chart

Adding a Chart to a Form or Report

Activating Microsoft Graph to Edit

Changing the Chart Type and Chart Title

Formatting the Chart Title

Adding Data Tables to a Chart

Subforms/Subreports

Working with Subforms/Subreports

Creating a Subform/Subreport

Editing the Layout of a Subform

Displaying a Subform in a Datasheet

Displaying a Subform Total

Other Form Techniques

Adding a Command Button

Saving a Form as a Report

Creating a PivotTable or PivotChart View

ActiveX Controls

Working with ActiveX Controls

Registering an ActiveX Control

Attaching an ActiveX Control

Working with Indexes

Viewing Indexes

Creating a Single and a Multiple Field Index

Deleting an Index

Creating a Multiple Field Primary Key

Replicating Databases

Replicating a Database

Synchronizing Database Replicas

Resolving Replication Conflicts

Access and the Internet

Working with Hyperlinks

Creating and Inserting a Hyperlink Field

Editing and Deleting a Hyperlink Field

Hiding/Displaying the Web Toolbar

Creating a Data Access Page

Grouping and Sorting Data Access Pages

Creating a PivotTable in a Data Access Page

Encrypting a Database

Assigning and Removing a Database Password

Creating Macros

Working with Macros

Opening the MacroDesign Window

Creating a Macro

Assigning an Argument to an Action

Saving a Macro

Single Step Mode for Testing

Running a Macro

Editing an Existing Macro

Running a Macro Using the Tools Menu

Creating a Macro using the Macro Builder

Macros

Properties

Assigning a Macro to a Control

Creating a Command Button

Adding a Condition to a Macro

Creating a Group Macro

Creating an Autoexec Macro

Switchboards

Opening and Using a Switchboard

Creating a Switchboard Form

Adding a Command Button to a Switchboard

Setting Startup Options

Creating Custom Toolbars

Adding a Built-in Menu Item

Creating a Custom Menu Item

Adding a Command to a Menu Item

Adding Custom Commands

Docking a Floating Toolbar

Linking a Toolbar to a Report

Adding a Separator Bar

Creating a Shortcut Menu

Linking a Custom Shortcut Menu

Adding Buttons to a Custom Toolbar

Changing a Button Image

Deleting a Custom Toolbar

Exporting Data to Excel and Word

Exporting Data to an Excel Workbook

Dragging and Dropping Data into Excel

Creating Excel Workbooks – Office Links

Creating Word Documents – Office Links

Return to the top of the Page

Access 2000 Beginning

Length of Course:	1 day
Prerequisites:	Excel 2000 Beginning and Intermediate
Course Objective:	This course teaches students how to manage databases, create tables with and without the wizard; customize the tables fields and properties; filter and search for specific data; create relationships. You will learn the ins and outs of Queries along with simple Reports and Printing.

Course Outline:

Getting Started

Opening a Database

Navigation through Access

Closing, Exiting

Creating Tables

Creating a Blank Database

Designing Tables

Customizing Fields

Setting Primary Keys

Setting Field Properties

Using Field Properties

Setting Validation Rules

Working With Tables

Navigating Fields

Navigating through Records

Modifying Tables

Inserting Columns and Rows

Deleting Columns and Rows

Inserting a Lookup Column

Inserting a Hyperlink Column

Finding and Filtering Data

Sorting Records

Find and Replace

Using Filters

Creating Relationships

Using Related Tables

Working with Relationships

Setting Referential Integrity

Using Simple Queries

Working with queries

Creating, Opening, Saving Queries

Joining Tables in a Query

Running a Query

Modifying Query Results

Sorting a Query

Adding Criteria

Hiding a Field

Printing a Query

Using Operators in Queries

Using Comparison Operators

Using And and Or Conditions

Using the Between Operator

Using a Wildcard Character

Creating Basic Reports

Using Reports

Working with Report Wizard

Printing a Report

Using Auto Report

Printing

Printing Table Data

Changing Page Setup

Printing Selected Records

Return to the top of the Page

Access 2000 Intermediate

Length of Course:	1 day
Prerequisites:	Access 2000 Beginning
Course Objective:	This course teaches students how to create different types of Queries with and without the wizard. You will learn how to created and use Forms and Reports with all the customizable features.

Course Outline:

Designing Advanced Queries

Setting Top Values

Creating a Calculated Field

Creating a Function Query

Creating a Parameter Query

Creating Action Queries

Creating Make-table Query

Creating an Update Query

Creating an Append Query

Creating a Delete Query

Using Advanced Query Wizard

Using Crosstab Query Wizard

Working with Finding Duplicates

Working with Finding Unmatched

Creating Basic Forms

Using Forms

Using the Form Wizard

Viewing, Printing Records

Basing a From on a Query

Using AutoForm

Manipulating Controls

Using Controls

Deleting Controls

Sizing and Moving Controls

Using Design View

Hiding the Ruler

Displaying the Field List

Adding a Field

Aligning and Spacing Controls

Using Toolbox

Adding Lables

Adding Images, Lines and Objects

Editing an Unbound Control

Using Advanced Form Design

Using Forms in Design View

Creating Combo and List Boxes

Creating an Option Group

Setting Tab Order

Adding Headers and Footers

Using Editing Tools

Selecting a Font Name

Selecting a Font Size and Style

Using the Format Painter

Using AutoFormat

Spell Check

Using AutoCorrect

Using Advanced Report Design

Using Reports in Design View

Creating Calculated Controls

Grouping Data in a Report

Creating Headers and Footers

Inserting Date/Time Controls

Inserting a Page Break

Changing the Report Margins

Using the Label Wizard

Return to the top of the Page

Access 2000 Advanced

Length of Course:	2 days
Prerequisites:	Access 2000 Intermediate
Course Objective:	This course teaches students how to master Access by using macros and switchboards, subforms and ActiveX Controls. You will learn to customize by creating custom toolbars and setting up passwords.

Course Outline:

Using Advanced Database Features

Printing a Relationship Document

Linking Data to an Access Table

Setting a Database Password

Compacting a Database

Exporting Data to Excel and Word

Exporting Data to an Excel Workbook

Dragging and Dropping Data into Excel

Office Links

Working with Indexes

Viewing Indexes

Creating a Single Field Index

Deleting an Index

Analyzing Tables

Using Relationships in Splits

Using the Table Analyzer Wizard

Using Subforms

Working with Subforms

Creating a Subform

Adding a Form Header/Footer

Displaying a Subform Total

Using Other Form Techniques

Viewing Properties of an Object

Changing a Control Property

Adding a Logic Control

Adding a Command Button

Saving a Form as a Report

Using ActiveX Controls

Working with ActiveX Controls

Registering an ActiveX Control

Adding an ActiveX Control

Attaching an ActiveX Control

Using Switchboards

Opening and Using a Switchboard

Creating a Switchboard Form

Adding a Button to a Switchboard

Setting Startup Options

Using Charts

Creating a Chart

Adding a Chart to a Report

Changing the Chart Type

Using AutoFormat

Formatting the Chart Title

Adding Data Labels to a Chart

Creating Macros

Creating a Macro

Assigning an Argument to an Action

Saving and Running a Macro

Using Macros

Using Properties

Assigning a Macro to a Control

Creating a Command Button

Adding a Condition to a Macro

Creating a Group Macro

Creating an Autoexec Macro

Replicating Databases

Synchronizing Database Replicas

Resolving Replication Conflicts

Creating Custom Toolbars

Adding a Built-in Menu Item

Creating a Custom Menu Item

Linking a Toolbar to a Report

Creating a Shortcut Menu

Using Access and the Internet

Working with Hyperlinks

Creating a Hyperlink Field

Hiding/Displaying the Web Toolbar

Return to the top of the Page

ACCESS 2000 Upgrade

Length of Course:

45 Minutes

Course Outline:

ACCESS NEW FEATURES

Working with Hyperlinks

Creating a Hyperlink Field

Inserting a Hyperlink Field

Editing a Hyperlink Field

Deleting a Hyperlink Field

Creating a Data Access Page

Grouping and Sorting Data Access Pages

Return to the top of the Page

Microsoft Access Module

Length of Course: 5 Days (4 Hours Per Day)

Prerequisites: Word and Excel Proficient

Course Objective: To understand how to create a database using Microsoft Access. You will also learn to generate Queries, Forms and Reports.

Course Outline:

Getting Started

Creating Tables

Working With Tables

Setting Field Properties

Editing Tables

Finding and Filtering Data

Printing Data

Creating Relationships

Using Simple Queries

Modifying Query Results

Using the Table Analyzer Wizard

Creating Basic Forms

Creating Basic Reports

Modifying Tables

Using Operators in Queries

Designing Advanced Queries

Creating Action Queries

Using Advanced Query Wizards

Using Database Utilities

Manipulating Controls

Using the Design View

Using Advanced Form Design

Using Advanced Report Design

Using Editing Tools

Using Charts

Return to the top of the Page

Access 97 Beginning

Length of Course:	1 day
Prerequisites:	Excel 97 Beginning and Intermediate
Course Objective:	This course teaches students how to manage databases, create tables with and without the wizard; customize the tables fields and properties; filter and search for specific data; create relationships. You will learn the ins and outs of Queries along with simple Reports and Printing.

Course Outline:

Getting Started

Opening a Database

Navigation through Access

Closing, Exiting

Creating Tables

Creating a Blank Database

Designing Tables

Customizing Fields

Setting Primary Keys

Setting Field Properties

Using Field Properties

Setting Validation Rules

Working With Tables

Navigating Fields

Navigating through Records

Modifying Tables

Inserting Columns and Rows

Deleting Columns and Rows

Inserting a Lookup Column

Inserting a Hyperlink Column

Finding and Filtering Data

Sorting Records

Find and Replace

Using Filters

Creating Relationships

Using Related Tables

Working with Relationships

Setting Referential Integrity

Using Simple Queries

Working with queries

Creating, Opening, Saving Queries

Joining Tables in a Query

Running a Query

Modifying Query Results

Sorting a Query

Adding Criteria

Hiding a Field

Printing a Query

Using Operators in Queries

Using Comparison Operators

Using And and Or Conditions

Using the Between Operator

Using a Wildcard Character

Creating Basic Reports

Using Reports

Working with Report Wizard

Printing a Report

Using Auto Report

Printing

Printing Table Data

Changing Page Setup

Printing Selected Records

Return to the top of the Page

Access 97 Intermediate

Length of Course:	1 day
Prerequisites:	Access 97 Beginning
Course Objective:	This course teaches students how to create different types of Queries with and without the wizard. You will learn how to created and use Forms and Reports with all the customizable features.

Course Outline:

Designing Advanced Queries

Setting Top Values

Creating a Calculated Field

Creating a Function Query

Creating a Parameter Query

Creating Action Queries

Creating Make-table Query

Creating an Update Query

Creating an Append Query

Creating a Delete Query

Using Advanced Query Wizard

Using Crosstab Query Wizard

Working with Finding Duplicates

Working with Finding Unmatched

Creating Basic Forms

Using Forms

Using the Form Wizard

Viewing, Printing Records

Basing a From on a Query

Using AutoForm

Manipulating Controls

Using Controls

Deleting Controls

Sizing and Moving Controls

Using Design View

Hiding the Ruler

Displaying the Field List

Adding a Field

Aligning and Spacing Controls

Using Toolbox

Adding Labels

Adding Images, Lines and Objects

Editing an Unbound Control

Using Advanced Form Design

Using Forms in Design View

Creating Combo and List Boxes

Creating an Option Group

Setting Tab Order

Adding Headers and Footers

Using Editing Tools

Selecting a Font Name

Selecting a Font Size and Style

Using the Format Painter

Using AutoFormat

Spell Check

Using AutoCorrect

Using Advanced Report Design

Using Reports in Design View

Creating Calculated Controls

Grouping Data in a Report

Creating Headers and Footers

Inserting Date/Time Controls

Inserting a Page Break

Changing the Report Margins

Using the Label Wizard

Return to the top of the Page

Access 97 Advanced

Length of Course:

2 days

Prerequisites:

Access 97 Intermediate

Course Objective: This course teaches students how to master Access by using macros and switchboards, subforms and ActiveX Controls. You will learn to customize by creating custom toolbars and setting up passwords.

Course Outline:

Using the Table Analyzer Wizard

Analyzing a Table

Using Relationships in Splits

Using the Table Analyzer Wizard

Using Database Utilities

Changing Database Properties

Linking Data to an Access Table

Importing Data

Setting a Database Password

Compacting a Database

Working with Indexes

Viewing Indexes

Creating a Single Field Index

Deleting an Index

Using Subforms

Working with Subforms

Creating a Subform

Adding a Form Header/Footer

Displaying a Subform Total

Using Other Form Techniques

Viewing Properties of an Object

Changing a Control Property

Adding a Logic Control

Adding a Command Button

Saving a Form as a Report

Using ActiveX Controls

Working with ActiveX Controls

Registering an ActiveX Control

Adding an ActiveX Control

Attaching an ActiveX Control

Using Switchboards

Opening and Using a Switchboard

Creating a Switchboard Form

Adding a Button to a Switchboard

Setting Startup Options

Using Charts

Creating a Chart

Adding a Chart to a Report

Changing the Chart Type

Using AutoFormat

Formatting the Chart Title

Adding Data Labels to a Chart

Creating Macros

Creating a Macro

Assigning an Argument to an Action

Saving and Running a Macro

Using Macros

Using Properties

Assigning a Macro to a Control

Creating a Command Button

Adding a Condition to a Macro

Creating a Group Macro

Creating an Autoexec Macro

Replicating Databases

Synchronizing Database Replicas

Resolving Replication Conflicts

Creating Custom Toolbars

Adding a Built-in Menu Item

Creating a Custom Menu Item

Linking a Toolbar to a Report

Creating a Shortcut Menu

Using Access and the Internet

Working with Hyperlinks

Creating a Hyperlink Field

Hiding/Displaying the Web Toolbar

Return to the top of the Page

E-mail us now or contact us at 702-320-8885

Legal Terms and Conditions