Access 2002 XP Training
Access 2002 XP Training Course
Hosted by Alison Balter
Approx. 6 hours of Access training on CD
Join Microsoft Access™ expert Alison Balter featuring state-of-the-art training covering beginning, intermediate, and advanced levels in this Access XP series. This Access XP training course will teach you the detailed skills you need, in a step-by-step, easy to understand format to master Microsoft’s Access XP database software.
 |
Special Offer! |
Our Access XP training CD-ROMs include a pretest to assess
your current skill level and a post-test to test your newly
acquired knowledge.
Multimedia CD-ROM Based Training:
With CD based training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics.
System Requirements: x86/400 mhz (minimum), CD-ROM Drive, 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, XP, or Windows Vista.
Access 2002 XP Trainer: Alison Balter
Alison is a highly experienced independent trainer and consultant, specializing in Windows applications training and development. During her seventeen years in the computer industry, she has trained and consulted with many corporations and government agencies. Alison is a regular contributing columnist for Access/Office/Visual Basic Advisor as well as other computer publications. She is also a regular on the Access and Visual Basic national speaker circuit. She was also one of four speakers on the Microsoft Visual Basic/Visual Studio World Tour.
Course Outline - Access 2002 XP Training:
Approx. 6 hrs. of training
ACCESS 2002 XP BEGINNING
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 from Page to Page
4.2 Zooming In & Out
4.3 Viewing Multiple Pages
4.4 Printing
4.5 AutoReports & the Report Wizard
4.6 Printing Database Objects
ACCESS 2002 XP INTERMEDIATE
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 without the Use of a Wizard
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 Types of Relationships
3.3 Referential Integrity
3.4 Indexes & Relationships
3.5 Printing Relationships
ACCESS 2002 XP ADVANCED
1.0 Designing Simple Queries
1.1 Selecting Fields
1.2 Ordering the Query Result & Refining Queries with Criteria
1.3 Updatability of Query Results
1.4 Queries Based on Multiple Tables
2.0 Building & Modifying Forms
2.1 Adding Controls
2.2 Selecting Controls
2.3 Moving, Sizing, & Deleting Controls
2.4 Aligning Controls
2.5 Changing Control Properties
2.6 Changing the Tab Order Controls
2.7 Form Properties
2.8 Working with Combo Boxes & List Boxes
3.0 Building & Modifying Reports
3.1 Understanding Report Bands
3.2 Working with Controls
3.3 Creating Groups & Total Reports
3.4 Working with Report Properties
3.5 Modifying Selection Criteria
Expires Feb 28, 2010
Save 10% to 20%
most training titles
For corporate orders, call to get a special quote or click here to receive a price quote by email.
Computer Training
Videos/CD-ROMs
Product List
Office
Other Categories
Autodesk
IT Certification
Microsoft Office
Soft skills
Computer Programming
Purchase Orders
Accepted from Corp., Gov., & Educational Institutions: Click here
