Access XP Advanced Version 10.0
Prerequisites Duration 2 day(s)
Validating Data
Understanding Database Design
Introduction to the Course Exercises
Understanding Relationships
Creating a Permanent Relationship
Understanding Queries
Creating a Select Query
Adding Sort Order, Criteria, and Calculated Fields to a Query
Using the Find Duplicates Query Wizard
Using the Find Unmatched Query Wizard
Changing the Join Type
Creating a Self-Join
Using the Table Analyzer Wizard
Using the Lookup Wizard
Creating an AutoLookup Form
Enhancing Select Queries
Modifying Query Properties
Creating a Top Values Query
Defining Operators and Functions
Using the Expression Builder
Designing a Parameter Query
Defining Parameter Order and Data Type
Adding Groups and Totals to a Query
Creating a Crosstab Query in Design View
Using the Crosstab Query Wizard
Running Action Queries
Defining Action Queries
Designing a Make Table Query
Designing a Delete Query
Designing an Update Query
Creating an Append Query
Creating Advanced Reports
Creating a Summary Report
Modifying Report Properties
Creating a Running Sum
Creating a Report from a Parameter Query
Designing a Chart in a Report
Enhancing Charts
Changing the Chart Type
Defining a New Default Report Template
Working with Advanced Form Controls
Understanding Switchboard Forms
Modifying Form Properties
Creating a Check Box
Using the Combo Box Wizard
Using the List Box Wizard
Using the Option Group Wizard
Creating a Command Button
Creating a Tab Control
Creating Conditional Formats
Creating Multi-Table Forms
Understanding Subforms
Designing Forms with Subforms
Changing Subform Properties
Using the Subform Wizard
Specifying the Tab Order of Form Controls
Modifying the Record Source Property
Creating Macros
Creating a Macro
Running a Macro
Assigning a Macro to a Command Button
Creating a Macro Group
Creating a Conditional Macro
Referencing Form Controls
Creating an AutoKeys Macro
Creating a Menu Bar
Customizing the Startup Environment
Working with PivotTables and PivotCharts
Understanding PivotTables and Pivot Charts
Creating a PivotTable Form
Creating a PivotTable from a Query
Modifying PivotTable Fields
Adding Total Fields to a PivotTable
Filtering Fields in a PivotTable
Changing the Detail Level in a PivotTable
Formatting PivotTables
Creating a PivotChart
Working with Web Features (Optional)
Importing and Linking HTML Files
Defining Access Web Pages
Exporting Objects to HTML Format
Creating Data Access Pages Using the Wizard
WACMXP ONLINE - 6/17/2002 0:00:00
