Microsoft Access

Microsoft

Microsoft Access Training Course

Unlock the full potential of relational databases with our MICT SETA accredited Microsoft Access training. Whether you are a beginner looking to build your first tracking database or a professional aiming to master complex queries and custom interface design, our facilitator-led sessions provide the hands-on experience you need to manage large datasets with precision.

Our Microsoft Access courses are designed to boost workplace data integrity and reporting power. We don’t just teach table creation; we teach scalable data solutions. From structural normalization to advanced SQL integration and macro automation, we provide the tools to turn raw information into a sophisticated, searchable, and secure business asset.

Why Choose Our Microsoft Access Training?

Our Microsoft Access courses are designed to boost organizational efficiency and data accuracy. We don’t just teach software features; we teach logical database architecture. By the end of this course, you will be able to automate data entry through custom forms, visualize complex relationships through professional reports, and utilize powerful multi-table queries to make data-driven business decisions.

What you will receive:

Live, interactive facilitator-led training (Online or On-site).
Comprehensive training manuals and practical exercises.
A formal Certificate of Attendance.

Access Course Outline

Course Content

Description: This series of courses covers Microsoft Access from foundational database concepts to advanced management and maintenance. It is designed to take users through creating tables, establishing relational designs, building complex queries, and automating processes using macros.

Who Should Attend: Information regarding specific target audiences for these Access levels is not specified in the provided document.

Duration: Each level (Level 1, Level 2, and Level 3) is a 1-day course.

Prerequisites: Information regarding specific prerequisites for these Access levels is not specified in the provided document.

Unit Standards: Information regarding specific SAQA Unit Standards for these Access levels is not specified in the provided document.

Access Level 1: Course Outline

Module 1: About Access

What is Access?

Module 2: Database Fundamentals

Types of Databases.
Database Objects & their Roles.
Naming Conventions.

Module 3: Start Access

Launch Access and Open a Database.
Access Environment.
Table, Forms, Query & Report Overview.

Module 4: Create a Database

Database Templates.
Plan a Database.
Create a New Database.

Module 5: Create Tables

Table Views, Data Types, and Field Properties.
Create Tables and Manage Tables.
Sort and Filter Data.
Find & Replace Data.
View Subdatasheets.

Module 6: Table Relationships

Relationships Window and Join Lines.
Understanding Primary & Foreign Keys.
Set up Relationships.
Edit and Delete Line Joins.
Print Relationship Report.

Module 7: Queries

Create Simple Query using the Wizard or Query Design.
Create queries using different Criteria.
Sort and Filter Data.
Comparisons and Conditionals.
Build Simple Calculations.

Module 8: Create Forms

Form Views.
Navigate, Sort and Filter Data in a Form.
Create Basic Forms using the Wizard or New Form option.
Examine Split Forms and Multiple Items Forms.
Format Forms.

Module 9: Reports

Report Views and Navigate Reports.
Create Reports using various methods (Wizard or New Reports option).
Modify Reports in Layout and Design View.
Format Reports using Themes.
Print Report Preview.

Access Level 2: Course Outline

Module 1: Relational Database Design

Determine Purpose of a Database.
Determine Data, Fields, and Tables.
Normalization ( $1^{st}$ , $2^{nd}$ , and $3^{rd}$ Normal Forms) & Denormalization.
Relationship Types, Join Lines, and Primary/Foreign Keys.
Referential Integrity, Cascade Update Fields, and Cascade Delete Records.
Table Analyzer to improve Table structure.
Junction Tables to associate unrelated Tables.

Module 2: Tables in Depth

Table Specifications and Limits.
Manage Data Entry: Data Types and Field Properties.
Create Lookup fields and Field Validation.
Create Subdatasheets.

Module 3: Control Data Input via Forms & Reports

Restrict data input via Forms and Record Validation.

Module 4: Advanced Queries

Understanding Query Joins and Types.
Create Outer Join, Flexible, and Null Value queries.
Create Parameter and Top/Bottom Queries.
Group & Summarise Records Using Query Criteria.
Create Self Join, Subqueries, and Crosstab queries.
View query SQL code.

Module 5: Improve Forms

Modify Form in Layout View.
Understand Bound and Unbound Objects.
Property Sheet and Conditional Formatting.
Understand and insert Controls.
Insert SubForms and Create Tab Page Forms.

Module 6: Customise Reports

Apply advanced formatting and insert Controls.
Insert a Calculated field.
Manage Page Breaks and Margins.
Insert a Chart.

Appendix: Switchboards

Access Level 3: Course Outline

Module 1: Import and Export Table Data

Import Data with and without Links.
Export Data to different file formats.
Create a Mail Merge.

Module 2: Taking Queries Further

Create Action Queries: Update, Append, and Delete.
Create Unmatched & Duplicate Queries.
Create Unique Value and Record Queries.

Module 3: Create Complex Forms and Reports

Create Navigation Forms and SubReports.
Show details in Subforms and Popup Forms.

Module 4: Macros

Macro Specifications, Types, and Object Events.
Macro Builder Window and Action Arguments.
Create Standalone and Action Macros.
Restrict Records Using a Condition.
Validate Data and Create Data Macros.

Module 5: Database Management & Maintenance

Database Backup and Analyse Database Performance.
Compact & Repair Database and Document a Database.
Password Protect Database and Object Dependency.
Split Database.
Convert database to an ACCDE file.
Assign a Digital Signature.