Join
Microsoft Access™ expert Alison Balter featuring state-of-the-art
training covering beginning, intermediate, and advanced levels
in this basic training series.
Order below...
Access
XP Essentials: (CD-ROM)
3
Fully-Interactive CD-ROMs
Free
Shipping (in U.S.)
Online:
$169.95
Access
XP Essentials: (Video)
3
High-Quality Video Tapes
Free
Shipping (in U.S.)
Online:
$149.95
Order
with absolute confidence, all Order pages...
Detailed
Course Outline
Beginner
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
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
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
About Trainer
Alison
is a Microsoft Solution Provider, Microsoft Certified Systems
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.
Order
with complete confidence, all Order pages...
Aaron's Computer Training is your online source
for MCSE and A+ Certification computer training courses. We
also offer a complete suite of computer training certification
beyond A+ and MCSE Certification. Some of our most popular
classes are: Microsoft Office, MOUS, Linux, and Oracle.
Call for
Orders or Questions:1-800-617-5586
Toll Free ! Customer Service Hours: 9:00am-5:00pm, eastern
time, Monday - Friday aarons@aarons-computer-training.com