Duration: 1 Day
Access 2003 Advanced
Advanced queries
- Creating crosstab queries
- Using parameter queries
- Using action queries
Querying with SQL
- The SQL statement
- Writing SQL statements
- Attaching an SQL statement to database objects
Macros
- Creating and running macros
- Attaching macros to events of database objects
Advanced macros
- Creating macros to provide user interaction
- Creating macros that require user decision
- Using AutoKeys and AutoExec macros
Database management
- Optimizing resources
- Ensuring database integrity
Security fundamentals
- Protecting databases
- Encrypting and decrypting databases
- User-level security
- Working with shared databases
Internet integration
- Working with hyperlink fields
- Working with data access pages
|
