Microsoft
Access

The courses as outlined are designed by modules, 
two modules equal a level. 
Each level is taught in a 4 hour training course for $175.00
plus the cost of the Training Manual $22.50 (optional)
Basic - Intermediate - Advanced
 

BASIC ACCESS

PARTICIPANTS
Introduction to Microsoft Access 2002 is designed for those who need a basic introduction to Access 2002 database management tools.

PREREQUISITES
Students must have completed Introduction to Microsoft Windows 98 or XP. Those with significant experience using Access or similar database managers should consider the Intermediate or Advanced course.

OBJECTIVES
Students will learn the basics of the Access interface. This introductory course will deal with single-table examples only. The course teaches students sorting, filtering, and querying, along with customizing forms and reports. Specific objectives are listed at the beginning of each chapter of the workbook. Hands-on exercises test the studentsí mastery of the topics at the end of each chapter.

STRUCTURE
The course is presented through a combination of instructor-led lectures and hands-on exercises, aided by a step-by-step workbook and an exercise disk. Sample data files are provided on the exercise disk so students spend less time typing and more time learning.

OUTLINE

Introduction to Databases
- Understanding Basic Database Concepts
- Elements of the Relational Database
- The Database Window and its Features
- Field Types and Functions
- Planning a New Database
Getting Started with Access
- Starting Windows and Access
- Features of the Access Application Window
- The Desktop Environment
- Using Menus, Commands, and Dialog Boxes
- Using Toolbars and Buttons
- Exiting Access
Working With Databases and Tables
- Understanding Naming Conventions
- Creating a Database File
- Creating a Table Using the Table Wizard
- Modifying Field Properties
- Creating a Table Manually
Working with Records
- Adding Records to a Table
- Understanding Record Selector Symbols
- Editing and Navigating Fields and Records
- Deleting Records from a Table
- Making a Backup Copy of a Table
Working with Forms
- Creating a Form Using AutoForm
- Working in Form View and Design View
- Using the Formatting and Form View Toolbars
- Modifying a Form in Design View
- Adding Graphics and Saving a Form
- Creating a Form Using the Form Wizard
Working with Data
- Finding Data in a Database
- Using Wildcards
- Filtering by Form
- Using Advanced Filtering
- Sorting the Dynaset
- Printing Your Data
Working with Queries
- Understanding Query Types
- Creating Select Queries
- Sorting a Dynaset
- Saving a Query
- Using Comparison Operators
Working with Reports
- Creating a Form Using the Report Wizard
- Customizing and Formatting a Report
- Adding and Formatting Graphics
- Previewing and Printing a Report
Finding and Using Help

INTERMEDIATE ACCESS

PARTICIPANTS
Intermediate Microsoft Access 2002 is designed for those who understand the basics of Access 2002 database management and want to use the program more efficiently and productively.

PREREQUISITES
Students must have completed Introduction to Microsoft Access 2002.

OBJECTIVES
Students will learn how to use the Database Wizard and Lookup functions, use controls on forms and reports, create relationships among tables, and analyze tables. More advanced queries, such as relational queries, will be covered. Students will be shown how to create and use the highly functional and interactive
Data Access Pages and use Access 2002 in conjunction with the Internet and intranets. Specific objectives are listed at the beginning of each chapter of the workbook. Hands-on exercises test the studentsí mastery of the topics at the end of each chapter.

STRUCTURE
The course is presented through a combination of instructor-led lectures and hands-on exercises, aided by a step-by-step workbook and an exercise disk. Sample data files are provided on the exercise disk so students spend less time typing and more time learning.

OUTLINE

Working with Databases
- Using the Database Wizard
- Using and Modifying the Main Switchboard
- Examining and Creating Relationships
- Using a Contact Management Database
- Using the Performance Analyzer
Working with Tables
- Setting and Removing Primary Keys
- Indexing Fields
- Setting and Using Input Masks
- Using Default Fields and Required Fields
- Creating and Using Lookup Lists and Fields
Working with Forms
- Understanding Controls
- Creating a Navigational Control
- Creating a Combo Box Control
- Using Grouping to Modify a Form
- Creating Subforms on Forms
- Creating Multiple-Page Forms
- Creating Form Headers and Footers
Working with Queries
- Using Parameter Queries
- Using a Multiple Parameter Query
- Using Functions in Queries
- Using Calculated Fields in Queries
- Creating and Running Relational Queries
Working with Action Queries
- Using a Make Table Query
- Using an Update Query
- Using an Append Query
- Using a Delete Query
Working with Reports
- Creating Reports
- Grouping Records in a Report
- Formatting Reports Using AutoFormats
- Creating and Deleting an AutoFormat
- Creating and Using Calculated Controls
- Calculating Totals on Reports
- Creating Mailing Labels Using a Report
- Creating Subreports on Reports
Working with the Internet
- Understanding Internet Terms
- Navigating Using Hyperlinks
- Using Hyperlinks in Tables
- Using Hyperlinks on Forms
- Creating Hyperlinks to Web Sites
- Creating Hyperlinks to Documents
- Creating Web Pages
- Creating Data Access Pages

ADVANCED ACCESS

PARTICIPANTS
Advanced Microsoft Access 2002 is designed for those who have considerable experience with Access 2002 and want to use Accessís advanced features.

PREREQUISITES
Students must have completed Intermediate Microsoft Access 2002.

OBJECTIVES
Students will learn how to compact and repair databases, import and link external tables and spreadsheet files, examine relationships between tables, and create a form using an AutoLookup query. Students will learn to create crosstab queries and publish a pivot table and an Access report as Web pages. Advanced query
techniques will be covered. Specific objectives are listed at the beginning of each chapter of the workbook. Hands-on exercises test the studentsí mastery of the topics at the end of each chapter.

STRUCTURE
The course is presented through a combination of instructor-led lectures and hands-on exercises, aided by a step-by-step workbook and an exercise disk. Sample data files are provided on the exercise disk so students spend less time typing and more time learning.

OUTLINE

Maintaining Databases
- Compacting and Repairing Databases
- Converting Databases to Different Access Formats
- Protecting a Database by Saving it as an MDE File
Importing and Linking to Data
- Importing and Linking to External Data Sources
- Importing Data from External Sources
- Linking to Data in External Sources
- Performing Calculations on Access Tables in Microsoft Excel
Developing an Application

- Examining Relationships
- Using the Documenter
- Creating a Market Analysis Database Application
- Developing a Master Form
- Organizing with Groups
Developing Forms
- Creating a Customer Survey Form
- Designing a Master Form
- Creating a Query Listing
- Creating a Subform
- Linking the Master Form and Subform
- Modifying Controls on the Master Form
A Case Study of Product Sales
- Creating a Query that Lists Products Sold to
Customers
- Creating a Pivot Table
- Converting a Pivot Table to a Web Page
- Creating a Totals Query
- Creating a Totals Report
- Converting a Report to a Web Page
- Creating a CrossTab Query
- Creating a Report with Totals
- Understanding SQL
Developing a Project Using Advanced Access
Features

- Creating a Query Using AutoLookup
- Creating a Customer Form Using SQL Code
- Creating a Macro
- Creating a Command Button that Runs a Macro
- Creating a Totals Query that Counts Orders
- Creating a Macro Using the Expression Builder

 
Home   |    Web Designs  |   Web Hosting    |    Services    |   Contact Us

Copyright ©Compu-Wise.Com 1997. All Rights Reserved