Microsoft Office TrainingCourses > Microsoft Office Training

Microsoft Access 2003 Level 2

 

 

 Duration

 

1 day

 

 

Course Overview

 

As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

 

Course Objectives

 

You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft Office Access 2003 with other applications.


Target Audience

 

Microsoft Access 2003: Level 2 is designed for the student who wishes to learn intermediate-level operations of the Microsoft Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft Word or Excel. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

 

 

Course Contents

 

Reports

Purpose of a Report

Creating a Report

Creating an Autoreport

Amending Report Design

 

Subforms

Using the Subform Wizard

Using an Existing Form as a Subform

Using the Form Wizard

 

Enhancing Form Presentation

Adding and Deleting Controls

Adding Text Labels

Changing Properties

Tab Order

Adding Command Buttons

 

Action Queries

Make Table Query

Calculated Fields in Queries

Using the Expression Builder

 

Parameter Queries

Microsoft Access 2003 VBA

 

 

Duration

 

2 days

 

 

Prerequisites

 

Delegates should have attended the appropriate introductory and advanced courses plus have several weeks of practice. No programming experience is required.This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

 

Course Content

 

Module 1

•           Getting Started

•           Introduction to Programming in Access

•           Why Program in Access?

•           Understanding the Development Environment

•           Using Visual Basic Help

 

Module 2

•           Working with Procedures and Functions

•           Understanding Modules

•           Creating a Standard Module

•           Understanding Procedures

•           Creating a Sub Procedure

•           Calling Procedures

•           Using the Immediate Window to Call Procedures

•           Creating a Function Procedure

•           Naming Procedures

•           Organizing Code and Procedures

•           Working with the Code Editor

 

Module 3

•           Understanding Objects

•           Understanding Classes and Objects

•           Navigating the Access Object Hierarchy

•           Understanding Collections

•           Using the Object Browser

•           Working with the Application Object

•           Understanding the Form Object

•           Working with Properties

•           Using the With Statement

•           Working with Methods

•           Understanding the DoCmd Object

•           Working with Events

•           Understanding the Order of Events

 

Module 4

•           Using Expressions, Variables, and Intrinsic Functions

•           Understanding Expressions and Statements

•           Declaring Variables

•           Understanding Data Types

•           Working with Variable Scope

•           Working with Variable Lifetime

•           Considering Variable Scope and Lifetime Together

•           Using Intrinsic Functions

•           Understanding Constants

•           Using Intrinsic Constants

•           Using Message Boxes

•           Using Input Boxes

 

Module 5

•           Controlling Program Execution

•           Understanding Control-of-Flow Structures

•           Working with Boolean Expressions

•           Using the If...End If Decision Structures

•           Using the Select Case...End Select Structure

•           Using the For...Next Structure

•           Using the For Each...Next Structure

•           Using the Do...Loop Structure

•           Guidelines for use of Branching Structures

 

Module 6

•           Working with Recordsets

•           Declaring and Creating Object Variables

•           Working with the ADODB Recordset Object

•           Specifying a Recordset Cursor Type

•           Locking Records for Updating

•           Specifying a Recordset Cursor Location - Optional

•           Using the CacheSize Property - Optional

•           Understanding Recordset Cursor Properties - Optional

 

Module 7

•           Debugging Code

•           Understanding Errors

•           Using Debugging Tools

•           Setting Breakpoints

•           Setting Break Expressions

•           Using Break Mode during Run Mode

•           Stepping through Code

•           Determining the Value of Expressions

 

Module 8

•           Handling Errors

•           Understanding Error Handling

•           Understanding VBA's Error Trapping Options

•           Trapping Errors with the On Error Statement

•           Understanding the Err Object

•           Writing an Error-Handling Routine

·            Working with Inline Error Handling

Microsoft Excel 2003 Level 1

 

 

Duration

 

1 day

 

 

Course Overview

 

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Office Excel 2003 to manage, edit, and print data.This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

 

Target Audience

 

This course is designed for delegates who wish to gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2003 worksheets.

Course Objectives

 

Upon successful completion of this course, students will be able to:

·                Create a basic worksheet.

·                Modify a worksheet.

·                Perform calculations.

·                Format a worksheet.

·                Develop a workbook.

·                Print the contents of a workbook.

·                Customize the layout of the Excel window.

 

 

Course Contents

 

The Excel Screen

The Concepts of Excel

 

Moving and Selecting Cells

Entering and Deleting Data

Changing Widths of Columns & Rows

Saving and Closing Workbooks

Creating and Opening Workbooks

 

Editing Data

Using Number Styles

Moving and Copying Data

Inserting Cells, Rows and Columns

 

Understanding Data Series

Creating a Data Series

Dates, Days and Months

Custom Lists

Fill Handle, Cross Hair

Menu Methods

 

Basic Formula

Add, Subtract, Multiply and Divide

Equal to – Not Equal To

Greater Than – Less Than

Mouse Methods

Keyboard Methods

AutoSum

 

Percentages

Microsoft Excel 2003 Level 3

 

 

Duration

 

1 day

 

 

Course Overview

 

You have used Microsoft Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

Target Audience

 

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Prerequisites

 

To ensure your success, we recommend you first take the following Indicia Training courses or have equivalent knowledge:

·                Microsoft Office Excel 2003 Level 1

·                Microsoft Office Excel 2003 Level 2

 

 

Course Objectives

 

Upon successful completion of this course, students will be able to:

·                Customize workbooks.

·                Collaborate with others using workbooks.

·                Audit worksheets.

·                Analyze data.

·                Work with multiple workbooks.

·                Import and export data.

·                Structure workbooks with XML.

 

Course Contents

 

Revision of Basic Excel Techniques

 

Using Logical Functions

Using IF Functions

Using ISERROR Functions

Using Multiple IF statements

Using Conditional Formatting

Using And Or Functions

 

Using the Date and Time

Creating Formula with dates

 

Working with Multiple Sheets

Moving between Sheets

Selecting single and Multiple Sheets

Renaming, Copying & Moving Sheets

Inserting and Deleting Sheets

Linking to Other Sheets

Three Dimensional Referencing

 

Pivot Tables

Create Pivot Tables

Using the Pivot Table Wizard

Updating a Pivot Table

Changing the Layout of Pivot Tables

 

Round Function

Round to Two Decimal Places

Round to a Whole Number

Round to Whole Hundreds

Round Up to Next Whole Number

Round Down to Next Whole Number