Access 2000 Advanced
Enhance reports and forms with advanced features, automate with macros, explore
SQL, understand security fundamentals.
Recommended Preparation: Access
2000 Intermediate or equivalent knowledge.
Register for a class
Personalized training and consulting is available upon
request.
Lesson 1: Using Advanced Report Features
- Creating customized headers and footers
- Combining values from multiple fields
- Adding calculated values
- Working with sub-reports
Lesson 2: Advanced Forms
- Building a form based on joined tables
- Using grouped controls
- Enhancing the user interface
- Sub-forms
Lesson 3: Macros
- Creating and running macros
- Attaching macros to events of database objects
Lesson 4: Advanced Macros
- Creating macros to provide user interactions
- Creating macros that require user decision
- Using AutoKeys and AutoExec macros
|
|
Lesson 5: Exploring Access SQL
- Identifying different clauses in an SQL statement
- Writing SQL statements
- Attaching and SQL statement to a database
Discussion: Security Fundamentals
- Securing databases
- User-level security
|
