2. Advanced table design techniques
- validating field entries
- creating a custom input mask

3. Advanced form techniques
- creating a master
- detail form, adding a picture to a form
- displaying the current date on a form, modifying form properties

4. Advanced filter and query techniques
- creating an advanced filter
- including multiple conditions in a query
- creating a parameter query- creating an action query

5. Advanced report techniques
- creating a master
- detail report, completing the report
- adding a cover sheet to a report
- modifying report properties

6. Working with macros and modules
- what is a macro?
- creating a macro
- running a macro
- creating a command button
- writing an event procedure

8. Additional advanced Access features
- creating a many-to-many relationship between tables
- creating a switchboard
- exporting Access data to an XML document
- importing an XML document into Access
- saving an Access database in an MDE file
- creating an Access workgroup
- macro security

9. Final case study

10. Conclusion