Access 2000 Intermediate

Lesson 1: Working With Tables, Introduction - Installing The Northwind Database, Opening Microsoft Access 2000, The Single-Click Option, The Find Feature, The Find In Field Dialog Box, Search Options, Using Replace, Filtering By Form, Creating Advanced Filters, Sorting In Form View, Printing Your Data In Form Style, The Compact On Close Option

Lesson 2: Manipulating Table Structure, Introduction, Opening A Table In Design View, The Table Design Window, Switching Between Design And Datasheet Views, Design View Controls, Modifying Field Properties, Modifying Field Layout, The General Sheet, The Lookup Tab, Text, List And Combo Boxes, Creating A New Field, Naming Your New Field, Selecting A Data Type Field Indexing, Setting A Validation Rule

Lesson 3: Multi-Table Relationships, Introduction, Viewing Multiple Tables, The Window Menu, Tiling Vertically, Tiling Horizontally, Resizing A Field, The Database Button, The Relationships Window, The Show Table Button, Creating Multi-Table Relationships, The Edit Relationships Dialog Box, Editing Relationships, Criteria For Data And Referential Integrity, Cascade Update Related Fields, Cascade Delete Related Records, Join Types

Lesson 4: Forms And Charts, Introduction, The Form Wizard, Combining Tables In Forms, Using Subforms, Hierarchical And Synchronized Forms, Showing Related Records, Conditional Formatting, Adding Records In Form View, Adding Records With Subforms, Modifying A Form's Design, Form Design View, Creating Controls On A Form, Expressions In Calculated Controls, Modifying Controls, Grouping Controls, Text Formatting, Inserting An Image, Printing The Form, Using The Chart Wizard

Lesson 5: Working With Queries And Data Access Pages, Introduction, Creating A Select Query, Adding Fields To A Select Query, Running A Query From The Design Window, Sorting With A Query, Showing And Hiding Fields, Using Criteria In A Query, Querying Multiple Tables, Specifying Another Table In A Query, Using Comparison Operators, Multiple Criteria Conditions, Closing, Saving, Naming and Printing The Query, Building Summary Queries, The Data Access Page, The Page Wizard

Lesson 6: Creating Reports, Introduction, Using The Report Wizard, Viewing Your Report, Modifying A Report Title, Adding Custom Pages, Customize Headers And Footers, Making Calculations On A Report, Formatting Report Text, Lines, Borders And Special Effects, Inserting An Image, Printing Your Report, Using The Label Wizard