Microsoft access 2016

Apply now for our Microsoft access 2016 Course



  • Work with Table Data and Query a Database
  • Create Advanced Queries and Generate Reports
  • Customize the accesss Environment and Design a Relational Database
  • Join Tables and Organize a Database for Efficiency
  • Use Macros to Improve User Interface Design
  • Distribute and Secure a Database
  • Use Advanced Database Management and Share Data Across Applicatim
  • Implement Advanced Form Design and Using Data Validation


Course Details and Pricing


Instructor Led Learning


  Duration: 2 Days

  Registration Open Now!

Video Learning


  Duration: 2 Days

  Registration Open Now!

Call us : 021 419 3213

Microsoft access 2013 overview

Microsoft access 2016 Course overview

Part 1:
In this course, students will learn how to use Access 2016 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Part 2:
In this course, students learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.





Microsoft Acces Course capetown south africa

Who Should Attend Microsoft Access Course:

Part 1:
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Part 2:

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills. This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2016.

Microsoft Project 2016 Course capetown south africa

Microsoft Access 2016 courses | Online & Classroom Training

Microsoft Access 2016 courses will provide you with the basic skills required to work with Microsoft Access 2016 databases, including the creating and interacting with the Access tables, relationships, queries, forms and reports.



Microsoft Access 2016 is a relational database application in the Microsoft 2016 office suite that lets you enter, manage and run reports on large amounts of data. Microsoft Access 2016 also provides you with more knowledge on how to rich platform for developing database management solutions with easy-to-use customization tools.

Improve your career, and get your training here! MasterGrade IT Offers Online Access training.





Microsoft Acces Course capetown south africa, it training Microsoft, Microsoft training

3 Steps to Master Microsoft Acces 2016

01

Take a
course

02

Write an
Exam

03

Get
Certified

What you will learn
Microsoft Access 2016 Training Course


      Part 1 (Basic)

    • Lesson 1Getting Started with Access
    • Lesson 2Working with Table Data
    • Lesson 3 Querying a Database
    • Lesson 4Creating Advanced Queries & Using forms
    • Lesson 5 Generating Reports
    • Lesson 6 Customizing the Access Environment
    • Lesson 7 Designing a Relational Database

    Part 2  (Intermediate)

  • Lesson 1 Designing a Relational Database
  • Lesson 2Joining Tables
  • Lesson 3 Organizing a Database for Efficiency
  • Lesson 4 Sharing Data Across Applications

    Part 3   (Advanced)

  • Lesson 1 Implementing Advanced Form Design
  • Lesson 2Using Data Validation
  • Lesson 3 Using Macros to Improve User Interface Design
  • Lesson 4 Using Advanced Database Management
  • Lesson 5 Distributing and Securing a Database
  • Lesson 6 Managing Switchboards

Full course outline
Microsoft 2016 Project Training Course

Microsoft Access 2016 Part 1 (Basic)

Lesson 1: Getting Started with Access

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help in Microsoft Access

Lesson 2: Working with Table Data

  • Modify Table Data
  • Sort and Filter Records
  • Create Lookups

Lesson 3: Querying a Database

  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

Lesson 4: Creating Advanced Queries & Using Forms

  • Create Parameter Queries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Summarize Data
  • Create Basic Access Forms

Lesson 5: Generating Reports

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports

Lesson 6: Customizing the Access Environment

  • The Access Options Dialog Box

Lesson 7: Designing a Relational Database

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

Microsoft Access 2016 Part 2

Lesson 1: Designing a Relational Database

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

Lesson 2: Joining Tables

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Create Subqueries

Lesson 3: Organizing a Database for Efficiency

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

Lesson 4: Sharing Data Across Applications

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

Microsoft Access 2016 Part 3

Lesson 1: Implementing Advanced Form Design

  • Add Controls to Forms
  • Create Subforms
  • Organize Information with Tab Pages
  • Enhance Navigation of Forms
  • Apply Conditional Formatting
  • Set form controls

Lesson 2: Using Data Validation

  • Field and Record Validation
  • Form Validation

Lesson 3: Using Macros to Improve User Interface Design

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyse the Performance of a Database

Lesson 4: Distributing and Securing a Database

  • Splitting a Database for Multiple User Access
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Lesson 4: Managing Switchboards

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

Are you ready to become a Microsoft Access expert?