Microsoft Access. Level 2

Prerequisites
Access 2003 Introduction or equivalent skills. Must be able to create and use tables. Ability to create queries, forms, and reports is required.

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