100 megs data gift for every genuine quote requested
So you’re ready to take your MS Access 2016 skills to the next level beyond simple database queries. This intermediate level course is designed to give you a deeper understanding of the powerful data mining tools available in this software.
The MS Access 2016 Intermediate Training Course provides training in setting table relationships, customising reports, create pivot tables and pivot charts, conducting self-join queries, work with orphan records and much more.
This dynamic training course is now available in Gauteng, Durban and Cape Town.
Contact us today for a group quote.
Who Should Attend
This course is designed for people who have attended the Access Beginner course or have a comprehensive working knowledge of Access.
They should be confident in designing tables, forms queries and reports.
Learning Outcomes - Microsoft Access 2016 Intermediate Training
Upon successful completion of this course, participants will be able to:
- Design a relational database.
- Join tables to retrieve data from unrelated tables.
- Validate data entered into a database.
- Use advanced queries to manipulate your data.
- Organise a database for efficiency and performance, and to maintain data integrity.
- Customise reports to organise the displayed information and produce specific print layouts.
- Create and manage custom categories and groups in the Navigation Pane
Course Content - Microsoft Access 2016 Intermediate Training
Lesson 1: Designing a Relational Database
Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships
Lesson 2: Joining Tables
Topic A: Create Query Joins
Topic B: Relate Data Within a Table
Topic C: Work with Subdatasheets
Lesson 3: Using Data Validation
Topic A: Use Field Validation
Topic B: Use Form and Record Validation
Lesson 4: Creating Advanced Queries
Topic A: Create Parameter Queries
Topic B: Summarise Data
Topic C: Create Subqueries
Topic D: Create Action Queries
Topic E: Create Unmatched and Duplicate Queries
Lesson 5: Organising a Database for Efficiency
Topic A: Data Normalisation
Topic B: Create a Junction Table
Topic C: Improve Table Structure
Lesson 6: Using Advanced Reporting Techniques
Topic A: Include Control Formatting in a Report
Topic B: Add a Calculated Field to a Report
Topic C: Add a Subreport to an Existing Report