AtHand Logo

 

COURSE LOGIN
Username:
Password:   
FEATURED CUSTOMERS
FEATURED SOLUTION
AtHand Learning System
Total E-Learning Solution


Built-In LMS
Learning Management
Testing Solutions that address the issues you face now.

Access 2000

Print Version

Regarded as the standard in desktop database creation and management, Microsoft® Access has become a must-have application in most business offices. Learning to use this powerful data tool has become an essential productivity skill for today’s business people.

In this course, you will learn to design and create database applications, complete with forms and reports. You will also learn how to organize, query, and export data.

3 levels - 97 modules - 9 learning hours

 

Available Options

SINGLE USER: Access 2000 (3 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$149.00Add To Cart
1 YR ONLINE, e-Study Guides$149.00Add To Cart
CD-ROMs, e-Study Guides$149.00Add To Cart
MULTI USER: Access 2000 (3 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$298.00Add To Cart
CD-ROMs, e-Study Guides$298.00Add To Cart
For additional licensing options. pricing and information, call 877-752-3529

Course Instructor: Dennis P. Taylor

Dennis P. Taylor has spent over 14 years presenting PC software training to individuals in classrooms and seminars, including employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co-authored several books for spreadsheets. Dennis brings a combination of in-depth knowledge and training experience to his spreadsheet training courses. Watch and Learn in minutes with Dennis.

Course Outline

Level 1 Introduction

1.0 Introduction
  • 1.1 Starting Access
  • 1.2 Opening an Existing Database
  • 1.3 The Access Desktop
  • 1.4 The Database Window
  • 1.5 A Preview of the Database Components
2.0 Working with an Existing Database
  • 2.1 Viewing & Navigating Table Data
  • 2.2 Editing Table Data
  • 2.3 Adding Records to a Table
  • 2.4 Selecting & Deleting Records
  • 2.5 Find & Replace
  • 2.6 Modifying the Appearance of a Datasheet
  • 2.7 Spell-Check & Auto-correct
3.0 Form Basics
  • 3.1 Moving from Record to Record
  • 3.2 Finding
  • 3.3 Sorting
  • 3.4 Filtering
  • 3.5 AutoForms
  • 3.6 Using a Form Wizard
  • 3.7 Conditional Formatting
4.0 Report Basics
  • 4.1 Moving form Page to Page
  • 4.2 Zooming In & Out
  • 4.3 Viewing Multiple Pages
  • 4.4 Printing
  • 4.5 AutoReports & the Report Wizard
  • 4.6 Page Setup
5.0 Printing Database Objects
  • 5.1 Printing Table Datasheets
  • 5.2 Printing Queries
  • 5.3 Printing Forms
  • 5.4 Printing Reports
6.0 Getting Help
  • 6.1 The Office Assistant & Index Searching
  • 6.2 Context-Sensitive Help & Printing Help Topics
7.0 Database Maintenance & Shortcuts
  • 7.1 Backing Up & Restoring a Database
  • 7.2 Compacting & Repairing a Database
  • 7.3 Converting a Database to a Previous Version
  • 7.4 Organizing Database Objects into Groups
Level 2 Introduction

1.0 Planning & Designing a Database
  • 1.1 Evaluating Inputs & Outputs
  • 1.2 Normalization
  • 1.3 Creating a Database Using a Wizard
  • 1.4 Creating a Database from Scratch
2.0 Building & Modifying Tables
  • 2.1 Creating Tables Using a Wizard
  • 2.2 Creating Tables from Scratch & Data Types
  • 2.3 Setting Primary Keys
  • 2.4 Field Properties
  • 2.5 Input Masks
  • 2.6 The Lookup Wizard
  • 2.7 Indexes
3.0 Working with Relationships
  • 3.1 Introduction to Relationships
  • 3.2 Benefits of Relationships
  • 3.3 Types of Relationships
  • 3.4 Referential Integrity
  • 3.5 Indexes & Relationships
  • 3.6 Printing Relationships
4.0 Designing Simple Queries
  • 4.1 Selecting Fields & Ordering the Query Result
  • 4.2 Refining Queries with Criteria
  • 4.3 Updatability of Query Results
  • 4.4 Queries Based on Multiple Tables
Level 3 Introduction

1.0 Building & Modifying Forms
  • 1.1 Adding Controls
  • 1.2 Selecting Controls
  • 1.3 Moving
  • 1.4 Aligning Controls
  • 1.5 Changing Control Properties
  • 1.6 Changing the Tab Order Controls
  • 1.7 Form Properties
  • 1.8 Working with Combo Boxes & List Boxes
2.0 Building & Modifying Reports
  • 2.1 Understanding Report Bands
  • 2.2 Working with Controls
  • 2.3 Creating Groups & Totals Reports
  • 2.4 Working with Report Properties
  • 2.5 Modifying Selection Criteria
3.0 Database Startup Options
  • 3.1 Setting the Application
  • 3.2 Designing other Startup Information
4.0 Importing
  • 4.1 Exporting to another Database
  • 4.2 Exporting to an Excel Spreadsheet
  • 4.3 Exporting to ASCII
  • 4.4 Exporting to HTML
  • 4.5 Importing from anther Access Database
  • 4.6 Importing Spreadsheet Data
  • 4.7 Importing ASCII Data
  • 4.8 Importing from HTML
  • 4.9 Linking to Anther Access Database
  • 4.10 Linking to anther types of Database
  • 4.11 The Linked Table Manager