MOS Microsoft Office Access 2016 Intermediate - CTU Training Solutions
Loading...
Login / Register

MOS Microsoft Office Access 2016 Intermediate

Your training and experience using Microsoft® Access® 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
Duration: 1 Day   |   Location : Online
Course Prerequisites:
To ensure your success, it is recommended you have completed Microsoft® Office Access® 2016: Part 1 or posse... Show More
Request A Quote

Virtual Lecturer-led Interactive Teaching (VLIT)

Virtual instruction environments are designed to simulate the traditional classroom or learning experience. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

Test your skills

Complete our assessment and test your skill level!

Course Content

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: Summarize Data
Topic C: Create Subqueries
Topic D: Create Action Queries
Topic E: Create Unmatched and Duplicate Queries

Lesson 5: Organizing a Database for Efficiency
Topic A: Data Normalization
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

CTU Training Solutions , Updated: September 19th, 2018

Request A Quote

    Your Name
    Your Surname
    Contact Number
    Your Email
    Choose a campus
    Company
    Your job title
    Will your training be sponsored?
    Message
    How did you hear about CTU?
    Agree
    By ticking this box, you confirm that:

    (a) you have read and agree to our Website Terms and Conditions and that

    (b) you have read our Privacy Policy and PAIA Manual.

    If you are under 18 please ask your parent or guardian to confirm this.

    By ticking this box you give us permission to send you information and marketing material about our Brand, Campuses and Programmes.

    If your child is under 18, by checking this box, you give us permission to send your child information and marketing material about our brand, campuses and courses
    The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

    Join the CTU community

    Join the CTU Community Portal and gain access to superior resources.

    Join for Free

    Open chat
    1
    Need Help?
    Hello
    How can we assist you today?