Microsoft Access Advanced (2024)

Lesson 1: Advanced Database Design

• Entity-Relationship Diagrams (ERD)
• Table Normalization Techniques
• Complex Table Relationships
• Indexing and Optimization

Lesson 2: Advanced Query Techniques

• Advanced Query Design
• Parameter Queries
• Crosstab and Pivot Queries
• SQL Queries and Expressions

Lesson 3: Data Validation and Validation Rules

• Input Masks and Data Types
• Advanced Validation Rules
• Handling Null Values
• Complex Data Validation Techniques

Lesson 4: Advanced Form Design

• Tab Controls and Sub-forms
• Advanced Form Controls
• Creating Custom Forms
• Data-Driven Forms

Lesson 5: Advanced Report Design

• Sub-reports and Linked Reports
• Calculated Controls and Expressions
• Grouping and Sorting in Reports
• Interactive Reports

Lesson 6: Automation with Macros

• Creating Advanced Macros
• Data Import and Export Macros
• Event-Driven Macros
• Error Handling and Debugging

Lesson 7: VBA (Visual Basic for Applications)

• Introduction to VBA
• Writing VBA Code
• Automating Complex Tasks
• Custom Functions and Procedures

Lesson 8: Integration with Office Applications

• Integrating Access with Excel
• Data Export to Word and PowerPoint
• Outlook Integration
• Automating Office Tasks

Lesson 9: Advanced Data Management

• Data Import and Export Techniques
• Data Transformation and Manipulation
• Data Analysis and PivotTables
• Handling Large Datasets

Lesson 10: Security and Data Protection

• User-Level Security
• Encrypting Databases
• Backup and Restore Strategies
• Data Recovery Options