Access XP/2000 Level 2

Prerequisites: Windows Level 1 or equivalent knowledge

This course teaches you how to set relationships between tables, create lookup fields to assist in data entry, use subdatasheets and subforms, maintain data integrity by using input masks and validating data, create calculated controls on forms, group data in reports, control pagination, concatenate text fields, create totals and action queries, create parameter queries, create action queries, create and use data access pages, and import and export data.

Register Online

Creating Relational Databases
Creating One-to-Many Relationships
Creating Many-to-Many Relationships
Enforcing Referential Integrity
Working with Related Tables
Creating and Using Lookup Fields
Displaying Information with Subforms
Using Subforms to Add Records
Maintaining Data Integrity
Using Input Masks
Setting the "Required" Property
Specifying Data Validation
Using Advanced Form Features
Using Calculated Controls
Creating Expressions
Using the Expression Builder
Using Shortcut Keys for Data Entry
Setting the Tab Order
Using Advanced Report Features
Grouping and Sorting Reports
Customizing Headers and Footers
Forcing Pagination
Concatenating Text Fields
Working with Subreports
Using Advanced Query Features
Working with Joined Tables
Using Totals to Calculate Values
Creating and Applying Advanced Filters
Creating Advanced Queries
Creating Crosstab Queries
Creating Parameter Queries
Creating Update Queries
Creating Make-Table Queries
Creating Append Queries
Creating Delete Queries
Using Data Access Pages
Saving Forms as Data Access Pages
Saving Reports as Data Access Pages
Creating Data Access Pages
Saving PivotTables and PivotCharts as Data Access Pages
Importing and Exporting Data
Importing Data from Other XP Applications
Exporting Data to Other XP Applications
Working with XML Documents