Here is a excellent Advanced Access 2000 Tutorial, from the Community College of Rhode Island. It teaches you step-by-step how to perform and work with the following advanced Access functionality: Working with Tables, Field Properties, Operators in Queries, Advanced Queries, Action Queries, Linking and importing Data to an Access Table, Compacting and Backing up a Database, Working with Controls, Design View, Advanced Form Design, Advanced Report Design, and Editing Tools. These tutorial lessons can also be used to learn Access of this Access functionality in Access XP and Access 2003.
Contents of Advanced Access Tutorial Lessons:
- Inserting a Column in a Table
- Changing a Column Name
- Deleting a Column
- Inserting a Lookup Column
- Inserting a Hyperlink Column
- Creating a Many-to-Many Relationship
Lesson 2 – Setting Field Properties
- Using Field Properties
- Limiting Field Size
- Setting Number Formats
- Setting Date/Time Formats
- Setting Yes/No Formats
- Setting Default Values
- Setting Validation Rules
- Creating an Input Mask
Lesson 3 – Using Operators in Queries
- Using Comparison Operators
- Using an And Condition
- Using an Or Condition
- Using the Between And Operator
- Using a Wildcard Character
Lesson 4 – Designing Advanced Queries
- Setting Top Values in a Query
- Creating a Calculated Field
- Creating a Function Query
- Creating a Parameter Query
- Creating a Concatenation in a Query
- Using Multiple Tables in a Query
- Filtering a Query
Lesson 5 – Creating Action Queries
- Creating a Make-table Query
- Creating an Update Query
- Creating an Append Query
- Creating a Delete Query
Lesson 6 – Using Advanced Query Wizards
- Using the Crosstab Query Wizard
- Using the Find Duplicates Query Wizard
- Using the Find Unmatched Query Wizard
Lesson 7 – Using Advanced Database Features
- Printing a Relationship Document
- Linking Data to an Access Table
- Importing Data
- Setting a Database Password
- Compacting a Database
- Backing Up a Database
Lesson 8 – Manipulating Controls
- Using Controls
- Selecting Non-adjacent Controls
- Deleting Controls
- Sizing a Control by Dragging
- Selecting Adjacent Controls
- Moving Selected Controls
- Sizing Controls Automatically
- Hiding the Ruler
- Disabling the Snap to Grid Feature
- Displaying the Field List
- Adding a Field
- Moving Part of a Paired Control
- Aligning Controls
- Spacing Controls
- Using the Toolbox
- Adding a Label
- Adding an Image
- Adding a Rectangle
- Adding a Line
- Editing an Unbound Control
Lesson 10 – Using Advanced Form Design
- Using Forms in Design View
- Creating a Combo Box
- Creating a List Box
- Creating an Option Group
- Setting the Tab Order Automatically
- Setting the Tab Order Manually
- Adding a Form Header and Footer
- Creating a Blank Form
Lesson 11 – Using Advanced Report Design
- Using Reports in Design View
- Creating a Calculated Control
- Grouping Data in a Report
- Creating a Header for Each Group
- Creating a Running Summary
- Inserting a Date/Time Control
- Inserting a Page Break
- Changing the Report Margins
- Using the Label Wizard
- Creating a Blank Report
Lesson 12 – Using Editing Tools
- Selecting a Font Name
- Selecting a Font Size
- Selecting a Font Style
- Using the Format Painter
- Selecting Objects with the Toolbar
- Using AutoFormat
- Running the Spelling Checker
- Setting AutoCorrect Options
- Adding AutoCorrect Entries
- Deleting AutoCorrect Entries
