|
Access 2003 Advanced (Code: AS23AV)
Days of training: 2 Prerequisites: Access
2003 Intermediate or equivalent experience
Relational
databases
Database
normalization
Relating tables
Implementing referential integrity
Working with related tables
Using the Lookup Wizard
Modifying Lookup fields
Adding data to related tables
Complex queries
Joining tables in queries
Creating calculated fields
Summarizing and grouping values
Advanced queries
Creating crosstab queries
Using parameter queries
Using action queries
Advanced form design
Adding unbound controls
Adding graphics
Adding calculations
Adding combo boxes
Advanced reports
Creating customized headers and footers
Adding calculated values
Working with subreports
Creating charts
Creating charts in forms
Creating charts in reports
Internet integration
Working with hyperlink fields
Working with data access pages
Macros
Creating and running macros
Attaching macros to events of database objects
Importing, exporting, and linking objects
Importing Access objects
Exporting Access objects
XML documents
Linking Access objects
Working with shared databases
Database management
Optimizing resources
Ensuring database integrity
Security fundamentals
Protecting databases
Encrypting and decrypting databases
User-level security
Modules
Understanding modules
| 
