Microsoft Access XP Basic Training Course
All three of the following courses for the special price of $159.95!
Covers Microsoft Access 2002
$159.95US
Microsoft Access XP Beginning
Introduction: Starting Access; Opening an Existing Database; The Access Desktop;
The Database Window; A Preview of the Database Components
Working with an Existing Database: Viewing & Navigating Table Data; Editing Table Data;
Adding Records to a Table; Selecting & Deleting Records; Find & Replace;
Modifying the Appearance of a Datasheet; Spell-Check & Auto-correct
Form Basics: Moving from Record to Record; Finding; Sorting; Filtering; AutoForms;
Using a Form Wizard; Conditional Formatting
Report Basics: Moving from Page to Page; Zooming In & Out; Viewing Multiple Pages;
Printing; AutoReports & the Report Wizard; Printing Database Objects
Microsoft Access XP Intermediate
Planning & Designing a Database: Evaluating Inputs & Outputs; Normalization;
Creating a Database Using a Wizard; Creating a Database from Scratch
Building & Modifying Tables: Creating Tables Using a Wizard;
Creating Tables without the Use of a Wizard; Setting Primary Keys; Field Properties;
Input Masks; The Lookup Wizard; Indexes
Working with Relationships: Introduction to Relationships; Types of Relationships;
Referential Integrity; Indexes & Relationships; Printing Relationships
Microsoft Access XP Advanced
Designing Simple Queries: Selecting Fields;
Ordering the Query Result & Refining Queries with Criteria; Updatability of Query Results;
Queries Based on Multiple Tables
Building & Modifying Forms: Adding Controls; Selecting Controls;
Moving, Sizing, & Deleting Controls; Aligning Controls; Changing Control Properties;
Changing the Tab Order Controls; Form Properties; Working with Combo Boxes & List Boxes
Building & Modifying Reports: Understanding Report Bands; Working with Controls;
Creating Groups & Total Reports; Working with Report Properties; Modifying Selection Criteria
|