Advanced Access 2000 Tutorial

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:

Lesson 1 - Modifying Tables

• 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 

Lesson 9 - Using Design View

• 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