Microsoft Office Access 2016: Part 2 (Intermediate) Course

This comprehensive Microsoft office access intermediate course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Access 2016 can also take this course.

Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector.

This Microsoft office access intermediate course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection.

This Microsoft office access intermediate course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%.

Designing a Relational Database

• Analyze The Relational Database Design Process
• Understand Primary Keys
• Explore Table Relationships
• Create a Table
• Create a Table Relationship

Joining Tables

• Joining Tables – Introduction
• Inner and Outer Joins
• Create Inner and Outer Joins
• Join Unrelated Tables
• Relate Data Within a Table
• Work with Subdatasheets – Introduction
• Work with Subdatasheets

Using Data Validation

• Use Data Validation – Introduction
• Field Validation
• Input Mask
• Form Validation
• Record Validation

Creating Advanced Queries

• Create Advanced Queries – Introduction
• Create Parameter Queries
• Use Wildcards in a Parameter Query
• Create Queries with Multiple Parameters
• Create Crosstab Queries
• Update Queries
• Append Queries
• Delete Queries
• Make Table Queries
• Unmatched and Duplicated Queries – Introduction
• Create Unmatched Queries
• Create Duplicate Queries

Organizing a Database for Efficiency

• Data Normalization
• The Table Analyser Wizard
• Junction Tables – Introduction
• Junction Tables
• Improve Table Structures

Using Advanced Reporting Techniques

• Use Advanced Reporting Technique
• Conditional Formatting – Data Bars
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report
• Bonus Lecture