Days: 1
Prerequisites: Access 2000/XP/2003: Intermediate or equivalent experience
Unit 1 : Advanced forms
· Building a form based on joined tables
· Automating data entry
· Using grouped controls
· Enhancing the user interface
· Subforms
Unit 2 : Macros
· Creating and running macros
· Attaching macros to events of database objects
Unit 3 : Advanced macros
· Creating macros to provide user interaction
· Creating macros that require user decision
· Using AutoKeys and AutoExec macros
Unit 4 : Exploring Access SQL
· Identifying different clauses in a SQL statement
· Writing SQL statements
· Attaching a SQL statement to a database object
Unit 5 : Internet integration
· Working with Hyperlink fields
· Working with data access pages
Unit 6 : Security fundamentals
· Securing databases
· User-level security