Access 2000 Advanced

Lesson 1: Working With Menus And Toolbars,Opening An Existing Database,Access Sample Databases, Installing The Northwind Database, The Show Me Menu, Customizing Toolbars And Menus, Customizing Toolbars, Customizing Menus, Creating Custom Toolbars, Adding Commands To A Custom Toolbar, Sorting Records, Hiding A Toolbar, Deleting A Toolbar, Grouping Toolbar Commands, Modifying ToolTips, Creating Custom ToolTips

Lesson 2: Sharing Data, Opening Access, Exporting Data From Microsoft Access, The Export Table 'Product' To Dialog Box, Viewing Exported Data, Exporting Data In HTML Format, Locating A File, The Snapshot Viewer, Sharing A Report, Sending A Report In Snapshot Format, Creating Backward Compatible Databases, Renaming A Database, Opening A Converted Database, The Upsizing Wizard, Object Linking And Embedding, Creating A New Table, Switching To Datasheet View, Copying Data From Excel For Use In A Table, The Insert Object Command, The Insert Object Dialog Box, Linking An Object, Viewing Objects, Verifying A Link, Importing Into Microsoft Access, The Import Dialog Box, The Import Spreadsheet Wizard, Viewing Imported Data, Linking Tables In Microsoft Access, The Link Spreadsheet Wizard, Properties Of Linked Tables, Inserting Hyperlinks, Setting Hyperlink Properties, Testing A Hyperlink, Removing A Hyperlink

Lesson 3: Advanced Queries, Introduction - Advanced Queries, Creating A New Query, Defining A Sort Order, Running A Query, Calculating Fields, Modifying A Query, Creating A Multi-table Query, The Show Tables Button, Joining Fields, Joining Properties, Creating A Crosstab Query, Running A Crosstab Query, Specifying Criteria, Creating A Delete Query, Previewing Delete Query Results, Creating An Update Query

Lesson 4: Replication And Internet Access, Introduction, Microsoft Access Project, Opening A New Project, The Data Link Properties Dialog Box, Project Options, Creating A Form For A Project, Record Level Locking, Locking Options, Replication, Opening A Replica, Synchronizing Databases, Viewing Results, Working With Multiple Replicas, Synchronizing Multiple Replicas, Resolving Conflicts, The Microsoft Replication Conflict Viewer, Creating Hyperlink Columns, Following A Hyperlink, Creating A New Database, Creating A Table, Verifying A Link, Saving A Table As An HTML File, Creating Forms For The Internet, The Form Wizard, Exporting A Form, Viewing A Form In HTML Format, Data Access Pages, Applying A Theme, Viewing A Data Access Page, Editing A Data Access Page, Viewing A Page In Internet Explorer

Lesson 5: Working With Macros, Introduction To Macros, Macro Properties, Macro Basics, Running A Macro, Customizing Macros, Verifying Changes, Creating A New Macro, New Macro Actions In Access 2000, Macro Action Arguments, Adding Comments, Running Macros, Adding Macros To The Toolbar, Changing The Appearance Of A Button, Adding A Macro To A Form, Help With Macros

Lesson 6: Visual Basic And Access 2000, Visual Basic for Applications, Viewing A Module, The Visual Basic Editor, Converting Macros To Visual Basic, Viewing Converted Code, Viewing The Properties Of A 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