Access 97 Training
Also Available... Access Developer Training Videos
Inquire about Microsoft Office 2000 and XP Training
 Microsoft Access is a powerful database management program that you
can use to efficiently create and manipulate database systems. Microsoft Access allows you to:
- View, enter, and customize data
- Find and display just the information you want to see by sorting and filtering
- Track new information by creating new ideas
- Kepp your information reliable by protecting and validating data, defining relationships, using Lookup fields, and more.
- Answer questions about and analyse your data using queries.
- Merge data from multiple tables to one form using the form wizard
- Steamline data entry.
- Create and enhance a custom report.
- Summarize and group information in reports.
- plus much more . . .
Microsoft Access 97 Training Videos or CD-ROMS Detailed Information
|
All Three Access 97 Videos (Beg/Int./Adv.)
|
kyac7a
|
$119.95
|
|
|
All Four Access 97 Videos
Beg./Int./Adv and Visual Basic for Access
|
kyac7b
|
$159.95
|
|
|
Three Access 97 CD-ROMS (Beg/Int./Adv.)
|
20816a
|
$119.95
|
|
|
All Four Access 97 CD-ROMS
Beg./Int./Adv and Visual Basic for Access
|
208238
|
$159.95
|
|
Microsoft Access 97 Training Videos
|
|
Beginning Training Video (2 hrs 16 min) #kyac71
1.0 Introduction (21 min)
1.1 The Access Desktop
1.2 Opening an Existing Database
1.3 The Database Window
1.4 A Preview of the Database Components
1.5 Getting Help and the Assistant
2.0 Working with an Existing Database (36 min)
2.1 Viewing and Navigating Table Data
2.2 Editing Table Data
2.3 Adding Records to a Table
2.4 Selecting Records
2.5 Deleting Records
2.6 Find and Replace
2.7 Modifying the Appearance of a Datasheet
2.8 Spell-check and Auto-correct
3.0 Designing Your Own Database (19 min)
3.1 Planning Your Database
3.2 Specifications
3.3 Normalization
3.4 Data Integrity
3.5 Field Types
3.6 The Database Wizard
4.0 Creating Your Own Tables (13 min)
4.1 The Table Wizard
4.2 Creating a Table Without a Wizard
4.3 Setting a Primary Key
5.0 Form Basics (11 min)
5.1 Using an Existing Form
5.2 Filter By Form
5.3 Creating a Form with the Form Wizard
6.0 Query Basics (21 min)
6.1 Creating a Query with a Wizard
6.2 Creating a Query without a Wizard
6.3 Adding Fields to the Query Grid
6.4 Entering Selection Criteria & Sorting Query Output
6.5 Removing Fields from the Query Grid
7.0 Report Basics (12 min)
7.1 Creating a Report with the Report Wizard
7.2 Report Bands
7.3 Sorting and Grouping
7.4 Page Setup
7.5 Printing a Report
Intermediate Training Video (2 hrs 12 min) #kyac72
1.0 Advanced Table Techniques (45 min)
1.1 The Field Size Property
1.2 The Caption Property
1.3 Establishing Default Values
1.4 Entering Field-Level Validations
1.5 Entering Table-Level Validations
1.6 Designating a Field as Required
1.7 Formatting Field Data
1.8 Using Input Masks
1.9 The Lookup Wizard
1.1 Adding Table Indexes
1.11 Working with the Hyperlink Data Type
2.0 Establishing Relationships (16 min)
2.1 Referential Integrity
2.2 Cascading Update & Delete
2.3 Modifying Table Design While in the Relationships Window
3.0 Advanced Selection Queries (40 min)
3.1 Entering Complex Criteria
3.2 Building Multi-table Queries
3.3 Adding Calculated Fields
3.4 Parameter Queries
3.5 Totals Queries
3.6 Top Value Queries
3.7 Displaying Unique Values
3.8 Crosstab Queries
4.0 Advanced Form Design (18 min)
4.1 Adding Controls
4.2 Selecting Controls
4.3 Moving Controls
4.4 Deleting & Aligning Controls
4.5 Sizing Controls
4.6 Changing Control Properties
4.7 Form Properties
5.0 Advanced Report Design (12 min)
5.1 Creating Groups and Totals Reports
5.2 Working with Control Properties
Advanced Training Video (2 hrs 22 min) #kyac73
1.0 Database Window Tricks (14 min)
1.1 List Types
1.2 Renaming Objects
1.3 Hide Objects
1.4 Drag and Drop to Create Desktop Shortcuts
1.5 Drag and Drop Between Applications
2.0 Importing, Exporting, and Linking (46 min)
2.1 Exporting to Another Database
2.2 Exporting to an Excel Spreadsheet
2.3 Exporting to ASCII
2.4 Exporting to HTML
2.5 Importing from Another Access Database
2.6 Importing Spreadsheet Data
2.7 Importing ASCII Data
2.8 Importing from HTML
2.9 Linking to Another Access Database
2.10 Linking to Another Type of Database
2.11 The Linked Table Manager
3.0 Action Queries (14 min)
3.1 Make Table Queries
3.2 Append Queries
3.3 Update Queries
3.4 Delete Queries
4.0 Power Query Techniques (26 min)
4.1 The Find Duplicates Wizard
4.2 The Find Unmatched Wizard
4.3 Inner & Outer Joins
4.4 Self-Joins
4.5 Union Queries
5.0 Power Form Techniques (29 min)
5.1 Working with the Built-in Tab Control
5.2 Working with Form Headers and Footers
5.3 Creating Multi-table Forms
5.4 Adding OLE Objects to Forms
5.5 Using a Bitmap as a Form Background
5.6 Other Important Form and Control Properties
5.7 Saving a Form as HTML
6.0 Power Report Techniques (12 min)
6.1 Building Reports With Sub-Reports
6.2 Advanced Band Techniques
6.3 Adding/Modifying Calculations
Microsoft Access 97 Training CD-ROMS
|
|
Introduction Training CD-ROM #208166
Discussing the Access window
Viewing fundamental database components
Opening a database
Using a Database wizard
Creating a database
Adding a table with the wizard
Defining data types
Using the Primary key
Changing field properties
Adding records
Copying records
Creating a form
Copying a table
Moving around a table
Organizing a table
Finding records
Replacing records
Filtering a table
Creating indexes
Sorting records
Intermediate Training CD-ROM #208167
Creating a Select query
Sorting fields for a query
Listing criteria expressions
Entering search criteria
Using AND and OR
Creating a Totals query
Re-labeling query fields
Adding calculating fields
Using an Action query
Creating a backup copy
Making an Update query
Using a Deleting query
Working with a Crosstab query
Creating a form with Forms wizard
Placing a bitmap on a form
Defining controls
Inserting a control
Changing a control's appearance
Creating a check box control
Adding a record
Creating a combo box
Changing the form's detail section
Using the Report wizard
Creating a graph
Placing the graph
Using the Button wizard to create a macro
Creating macros from scratch
Attaching a macro to a form
Advanced Training CD-ROM #208168
Defining database relationships
Demonstrating one-to-many
Showing many-to-many
Using a junction table
Defining one-to-one
Discussing Referential integrity
Joining databases
Using the Performer Analyzer
Query joined tables
Discussing equivalent values
Using parameters
Adding a list box
Adding a word
Using the Toggle Button tool
Creating a main form
Making a sub form
Linking tables
Creating a report
Making a template from a report
Creating mailing labels
Linking tables
Importing files
Exporting a table
Exporting in Rich Text Format
Assigning a password
Backing up a database
Encrypting a database
|
