| |
|
| |
Advanced Database Design in Access 2002 Training Class |
|
| |
|
|
| |
|
|
| |
Advanced Database Design in Access 2002 Training Seminar
To provide an overview of advanced database design in Access 2002
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Price |
|
| |
$74.95
|
|
| |
|
|
| |
Agenda |
|
| |
Data validation in Access 2002
- validate data in Access 2002.
Validating data in Access 2002
- insert a validation rule and validation text in Access 2002.
Optimizing data types in Access 2002
- describe how to optimize data types in Access 2002.
Data validation and restriction in Access 2002
- validate and restrict data entered into a table in Access 2002.
Creating and modifying a form in Access 2002
- create and modify a form in Access 2002.
Customizing a form in Access 2002
- customize a form in Access 2002.
Creating and customizing a form in Access 2002
- create and customize a form in Access 2002.
Subforms in Access 2002
- use subforms in Access 2002.
Using the subform control in Access 2002
- use the subform control in Access 2002.
Switchboards in Access 2002
- use switchboards in Access 2002.
Creating and modifying reports in Access 2002
- create and modify reports in Access 2002.
Using Design view to modify reports in Access 2002
- use Design view to modify reports in Access 2002.
Report control and section properties in Access 2002
- manipulate report control and section properties in Access 2002.
Modifying report properties in Access 2002
- modify report properties in Access 2002.
Subreports in Access 2002
- use subreports in Access 2002.
Creating a subreport in Access 2002
- create a subreport in Access 2002.
Query filters and query properties in Access 2002
- filter queries and modify query properties in Access 2002.
Applying filters in a query in Access 2002
- apply filters in a query in Access 2002.
Specifying join properties in Access 2002
- specify join properties in Access 2002.
Totals and parameter queries in Access 2002
- use totals and parameter queries in Access 2002.
Creating totals and parameter queries in Access 2002
- create totals and parameter queries in Access 2002.
Action queries in Access 2002
- use action queries in Access 2002.
Optimizing queries in Access 2002
- optimize query performance in Access 2002.
Working with queries in Access 2002
- use queries in Access 2002.
|
|
|
|
| |
|
|
| |
Audience |
|
| |
Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level
|
|
|
| |
|
|
| |
Pre-Requisites |
|
| |
The Microsoft Office XP: Beginning Access 2002 learning path; familiarity with any Windows user environment
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|