|
Provided by: 123-CBT Computer Based Training Access 2002 Advanced |
 |
Training
Provided by 123-CBT Computer Based Training
Lesson 1: Sharing Data
Introduction
Lesson Objectives
Opening Access
Opening The Northwind Sample Database
Exporting Data
Viewing Exported Data
Exporting Data In HTML Format
Opening An HTML File
Sharing Reports
Emailing A Report
The Snapshot Viewer
Viewing An Attachment
Printing A Report
Creating Backward Compatible Databases
Renaming A Database
Opening A Converted Database
The Upsizing Wizard
Object Linking & Embedding
Creating A New Table
Switching To Datasheet View
Entering An Object In A Table
The Insert Object Command
Linking An Object
Viewing Objects
Inserting A New Object
Verifying A Link
Importing Data Into Access
The Import Spreadsheet Wizard
Viewing Imported Data
Linking Tables
Properties Of Linked Tables
Inserting Hyperlinks
Setting Hyperlink Properties
Testing A Hyperlink
Removing A Hyperlink
Lesson 2: Advanced Queries
Introduction
Lesson Objectives
Creating A New Query
Selecting Source Data
Adding Fields To A Query
Defining Sort Order
Running A Query
Adding Calculated Fields
Modifying A Query
Creating A Multi-Table Query
Selecting Queries
The Show Tables Button
Selecting Fields
Joining Fields
Join Properties
Modifying Sort Order
Resizing Fields
Creating A Crosstab Query
Specifying Column & Row Headings
The Value Option
Running A Crosstab Query
Specifying Criteria
Creating A Delete Query
Previewing Results
Creating An Update Query
Conclusion
Lesson 3: Replication & Collaboration
Introduction
Lesson Objectives
Microsoft Access Projects
Opening A New Project
The Data Link Properties Dialog Box
Project Options
Creating A Form For A Project
Locking Records
Locking Options
Database Replication
Opening A Replica
Working With A Replica
Synchronizing Databases
Viewing Results
Working With Multiple Replicas
Synchronizing Multiple Replicas
Resolving Conflicts
Data Access Pages
Selecting Source Data For A Page
Applying A Theme
Viewing A Data Access Page
Editing A Data Access Page
Viewing A Page In Internet Explorer
Lesson 4: Introduction To Macros
Introduction
Lesson Objectives
Introduction To Macros
Macro Properties
Macro Basics
Running A Macro
Customizing Macros
Verifying Changes
Creating A New Macro
Selecting An Action
Macro Action Arguments
Adding Comments
Saving A Macro
Running Macros
Adding Macros To Toolbars
Changing The Appearance Of A Button
Adding A Macro To A Form
Help With Macros
Lesson 5: Introduction To Visual Basic
Introduction
Lesson Objectives
Visual Basic For Applications
Viewing A Module
The Visual Basic Editor
Converting Macros To Visual Basic
Viewing The Properties Of A Command Button
Creating New Event Procedures
Removing An Event Procedure
Visual Basic Project Security
The Project Properties Dialog Box
Entering A Password
Verifying Protection
Unicode Character Encoding
Unicode Compression Settings
Conclusion
Introduction
Lesson Objectives
Opening Access
Opening The Northwind Sample Database
Exporting Data
Viewing Exported Data
Exporting Data In HTML Format
Opening An HTML File
Sharing Reports
Emailing A Report
The Snapshot Viewer
Viewing An Attachment
Printing A Report
Creating Backward Compatible Databases
Renaming A Database
Opening A Converted Database
The Upsizing Wizard
Object Linking & Embedding
Creating A New Table
Switching To Datasheet View
Entering An Object In A Table
The Insert Object Command
Linking An Object
Viewing Objects
Inserting A New Object
Verifying A Link
Importing Data Into Access
The Import Spreadsheet Wizard
Viewing Imported Data
Linking Tables
Properties Of Linked Tables
Inserting Hyperlinks
Setting Hyperlink Properties
Testing A Hyperlink
Removing A Hyperlink
Lesson 2: Advanced Queries
Introduction
Lesson Objectives
Creating A New Query
Selecting Source Data
Adding Fields To A Query
Defining Sort Order
Running A Query
Adding Calculated Fields
Modifying A Query
Creating A Multi-Table Query
Selecting Queries
The Show Tables Button
Selecting Fields
Joining Fields
Join Properties
Modifying Sort Order
Resizing Fields
Creating A Crosstab Query
Specifying Column & Row Headings
The Value Option
Running A Crosstab Query
Specifying Criteria
Creating A Delete Query
Previewing Results
Creating An Update Query
Conclusion
Lesson 3: Replication & Collaboration
Introduction
Lesson Objectives
Microsoft Access Projects
Opening A New Project
The Data Link Properties Dialog Box
Project Options
Creating A Form For A Project
Locking Records
Locking Options
Database Replication
Opening A Replica
Working With A Replica
Synchronizing Databases
Viewing Results
Working With Multiple Replicas
Synchronizing Multiple Replicas
Resolving Conflicts
Data Access Pages
Selecting Source Data For A Page
Applying A Theme
Viewing A Data Access Page
Editing A Data Access Page
Viewing A Page In Internet Explorer
Lesson 4: Introduction To Macros
Introduction
Lesson Objectives
Introduction To Macros
Macro Properties
Macro Basics
Running A Macro
Customizing Macros
Verifying Changes
Creating A New Macro
Selecting An Action
Macro Action Arguments
Adding Comments
Saving A Macro
Running Macros
Adding Macros To Toolbars
Changing The Appearance Of A Button
Adding A Macro To A Form
Help With Macros
Lesson 5: Introduction To Visual Basic
Introduction
Lesson Objectives
Visual Basic For Applications
Viewing A Module
The Visual Basic Editor
Converting Macros To Visual Basic
Viewing The Properties Of A Command Button
Creating New Event Procedures
Removing An Event Procedure
Visual Basic Project Security
The Project Properties Dialog Box
Entering A Password
Verifying Protection
Unicode Character Encoding
Unicode Compression Settings
Conclusion
|
|
||||||||
Access 2002 Advanced
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
