Microsoft Access Intermediate (2024)

Price

R1,500.00R2,173.63 (Excl. VAT)

COURSE FEATURES

This course enables individuals to create more sophisticated databases, design complex forms and reports, optimize queries, automate tasks with macros, and collaborate effectively. The training’s purpose is to enhance participants’ proficiency in Access and empower them to manage data more efficiently in a variety of professional settings.

What you will learn in this course

Lesson 1: Database Design and Table Relationships

  • Review of Database Basics
  • Intermediate Table Design
  • Establishing Table Relationships
  • Enforcing Referential Integrity

Lesson 2: Intermediate Query Design

  • Creating Queries with Multiple Tables
  • Joining Tables with INNER and OUTER Joins
  • Calculated Fields and Expressions
  • Parameter Queries and Query Criteria

 

Lesson 3: Form Design and Customization

  • Advanced Form Design Techniques
  • Sub-forms and Tab Controls
  • Form Navigation and Layout
  • Data Validation and Input Masks

 

Lesson 4: Report Creation and Customization

  • Building Complex Reports
  • Grouping and Sorting Data
  • Calculated Controls in Reports
  • Advanced Printing and Export Options

 

Lesson 5: Data Validation and Integrity

  • Data Validation Rules
  • Input Masks and Validation Text
  • Table Validation Rules
  • Using Validation in Forms and Reports

 

Lesson 6: Query Optimization and Performance

  • Indexing and Query Performance
  • Query Optimization Techniques
  • Query Tuning

Lesson 7: Macros and Automation

  • Creating Data Macros
  • Macro Design and Debugging
  • Automating Tasks with Macros
  • Event-Driven Macros

 

Lesson 8: Importing and Exporting Data

  • Importing Data from External Sources
  • Exporting Data to Various Formats
  • Using Import and Export Specifications
  • Automating Data Transfer

 

Lesson 9: Collaboration and Integration

  • Integrating with Other Office Applications
  • Collaborative Features with SharePoint
  • Web Database Publishing
  • Multi-User Database Management

 

Lesson 10: Advanced Tips and Tricks

  • Keyboard Shortcuts and Productivity Tips
  • Troubleshooting Common Issues
  • Database Backup and Recovery
  • Best Practices in Access Development

Troubleshooting Performance Issues

Who should attend?

WHO SHOULD ATTEND?

Business Professionals who need to create and manage databases for tracking and reporting. Office Administrators and Data Entry Specialists responsible for maintaining databases. Small Business Owners looking to organize and analyse their business data. Students and Learners interested in acquiring database management skills. Anyone seeking a foundational understanding of Microsoft Access

COURSE CODE
MAI
INFORMATION SHEET
COURSE SCHEDULE

Select Per Person or A Group of people Programme *
Please include:

Register

Choose Intake & Study Mode

Related Courses

Select Per Person or A Group of people Programme *
Please include:
0
    0
    Your Cart
    Your cart is emptyReturn to Shop
    Your skills provider of choice since 1957 providing purposeful development journeys through its unique mix of people, solutions and passion so that individuals, teams and organisations are empowered to make a difference.