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

Access 2002 Advanced

About The Training Provider: 123-CBT Computer Based Training

More Microsoft Access 2002 XP Training from 123-CBT Computer Based Training

• Access 2002 Basic
• Access 2002 Intermediate
• Access 2002 Set of 3