Design Smarters Databases & Automate your Workflow.

Do you already understand the basics of Microsoft Access and want to build more powerful, professional database solutions?

In this advanced training, you will deepen your understanding of relational database design, create complex queries, build advanced forms and reports, and introduce automation techniques. You will learn how to structure databases efficiently, improve performance, and create user-friendly applications.

After this course, you will be able to build robust database solutions tailored to real business needs.

Duration

2 days.

Why follow this course ?

After completing this training, you will be able to:

• Design well-structured relational databases
• Create advanced queries with multiple joins and calculations
• Build dynamic and interactive forms
• Create professional reports with advanced grouping and logic
• Automate tasks using macros
• Improve database performance and reliability
• Apply database best practices

This course is practical, hands-on and focused on real-life business scenarios.

Course Outline

Advanced Database Design & Querying

1. Advanced Database Design

• Database normalisation (1NF, 2NF, 3NF – practical understanding)
• Avoiding redundancy and data anomalies
• Designing scalable database structures
• Advanced relationship types (one-to-many, many-to-many)
• Referential integrity and cascade options
• Indexing for performance optimisation

2. Advanced Queries

• Review of selection queries
• Complex criteria and logical operators (AND, OR, NOT)
• Calculated fields with expressions
• Using built-in functions (Date, String, Numeric)
• Crosstab queries
• Action queries:
  • Update queries
  • Append queries
  • Delete queries
  • Make-table queries
• Subqueries
• Query performance considerations

Advanced Database Design & Querying

1. Advanced Forms

• Form design best practices
• Subforms and master-detail forms
• Conditional formatting in forms
• Using calculated controls
• Navigation forms
• Data validation techniques
• Customising user interaction

2. Advanced Reports

• Advanced grouping and sorting
• Conditional formatting in reports
• Calculated controls and expressions
• Dynamic report filtering
• Professional report layout techniques
• Automating report output (PDF export)

3. Introduction to Macros

• What are macros in Access?
• Creating standalone macros
• Embedded macros in forms and reports
• Automating repetitive tasks
• Adding buttons to trigger macros
• Error handling in macros

4. Data Integration & Maintenance

• Importing and linking external data (Excel, CSV)
• Splitting databases (front-end/back-end structure)
• Compact and repair strategies
• Database security basics
• User-level best practices

Audience

This course is designed for professionals who:

• Have completed the Access Basic course or have equivalent experience
• Work regularly with relational databases
• Want to build more structured and automated database solutions
• Manage medium-sized database applications

Typical participants include administrative professionals, analysts, operations staff, HR professionals and internal application managers.

Prerequisites

Participants should:

• Understand tables, relationships, queries, forms and reports
• Be able to create basic queries and forms independently
• Have practical experience working with Access databases

No programming knowledge is required, but logical thinking is beneficial.