Access Advanced

Learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques.

Class Outline

Unit 1: Implementing Advanced Form Design

• Topic A: Add Controls to Forms
• Topic B: Enhance navigation and organization of forms
• Topic C: Apply conditional formatting

Unit 2: Sharing data across applications

• Topic A: Import data into access
• Topic B: Export Access data
• Topic C: Link Tables to external data sources
• Topic D: Create a mail merge

Unit 3: Using macros to improve user interface design

• Topic A: Create a macro
• Topic B: Restrict records by using a condition
• Topic C: Validate data by using a macro
• Topic D: Automate data entry by using a macro
• Topic E: Converting a macro to VBA

Unit 4: Using Advanced database management

• Topic A: Manage a database
• Topic B: Determine object dependency
• Topic C: Document a database

Unit 5: Distributing and Securing a database

• Topic A: Splitting a database for multiple-user access
• Topic B: Implement security
• Topic C: Convert an Access database to an ACCDE file
• Topic D: Package a database with a digital signature

Unit 6: Creating a Start-up Display Form

• Topic A: Create a display form
• Topic B: Set start-up options