Access XP
Interactive Instructor Based Video Training Courses

Trainer

Outline

Specials

Buy Options

Access is a powerful, yet easy-to-use database software package that is part of the Microsoft Office XP suite of products. This course will help familiarize you with the fundamentals of Access XP, such as working with forms, reports, and existing databases, as well as creating tables, designing queries, and much more.

KeyStone Self-Paced Training Courses Computer Based Training (CBT) and Video Based Training (VBT) have emerged as the premier training tools in recent years. KeyStone Self-Paced CBT/VBT courses are known for their high quality in-depth content. Compared to traditional training methods, KeyStone courses cost less and users can learn faster while taking advantage of some of the best trainers in the industry. They are easy to use, comfortable to follow, perfect for training rooms and ideal for learning at home.

Course Description: Join Microsoft Access™ expert Alison Balter featuring state-of-the-art training covering beginning, intermediate, and advanced levels in this basic training series.

Trainer Information: Alison Balter Alison Balter is a Microsoft Solution Provider, Microsoft Certified Systmes Developer and Access Trainer who teaches Access to all levels of users. She has over 15 years of experience working with corporations and government agencies. Alison is also a regular speaker for Advisor Publication Conferences. She has the experience to effectively transfer her many years of Access knowledge to you quickly and easily.

	Access XP: Beginner Level
	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 XP: Intermediate Level
	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 XP: Advanced Level
	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

Note: Course outlines are subject to change.