100 megs data gift for every genuine quote requested

Microsoft Access is the most popular database for Windows. It enables you to collect, organise, and report on data via a graphical user interface. Templates provide pre-defined forms, reports and database designs - and Macros enable you to automate regular tasks.

The Microsoft Access 2016 Advanced training course is designed for participants wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

This dynamic training course is now available in Gauteng, Durban and Cape Town.

Contact us today for a group quote.

Excel

Word

PowerPoint

Outlook

Access

Project

Who Should Attend

This course is designed for people who have attended the Access Intermediate course or have a comprehensive working knowledge of Access.

They should be confident in designing tables, forms queries and reports.

Upon completion of the Advanced Access course, students will be able to work with Select and Action queries, they will gain an understanding of the impact of relationships including enforcing referential integrity, cascade and delete updates when creating and designing a relational database.

They will be able to work confidently with properties and expressions in queries, calculations in forms, pivot table and pivot chart creation and macro design.

This course also introduces the concept and use of VBA in database design.

Learning Outcomes - Microsoft Access 2016 Advanced Training Course

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customise reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

After completing this course, participants will have learned to:

  • Customise a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Use VBA to enhance tasks.
  • Organise data into appropriate tables to ensure data dependency and minimise redundancy.
  • Lockdown and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the startup options.

Course Content - Microsoft Access 2016 Advanced Training Course

Lesson 1: Implementing Advanced Form Design
Topic A: Add Controls to Forms
Topic B: Enhance Navigation and Organisation of Forms
Topic C: Apply Conditional Formatting

Lesson 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

Lesson 3: Using Macros to Improve User Interface Design
Topic A: Create a Macro
Topic B: Restrict Records Using a Condition
Topic C: Validate Data Using a Macro
Topic D: Automate Data Entry Using a Macro

Lesson 4: Using VBA
Topic A: Getting Started with VBA
Topic B: Enhance Access Using VBA

Lesson 5: Using Advanced Database Management
Topic A: Manage a Database
Topic B: Determine Object Dependency
Topic C: Document a Database

Lesson 6: 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

Lesson 7: Managing Switchboards
Topic A: Create a Database Switchboard
Topic B: Modify a Database Switchboard
Topic C: Set Startup Options