Access 2016 Advanced

$400.00

About this course

The skills and knowledge acquired in Microsoft Access 2016 – Level 3 are sufficient to design and create a multi-table database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2016.

Course Outline

Clear
SKU: INF1632 Categories: , , , Tag:

Description

At Course Completion

After completing this course, students will be able to:

  • design a relational database project
  • create a relational database file with multiple tables
  • set table relationships and join tables together
  • export records to and import records from a wide variety of sources and applications
  • create queries based on one or more tables
  • create and work with aggregation queries
  • create and use a series of action queries
  • make your Microsoft Access data and computer more secure
  • understand and use a variety of tools that ensure the wellness of your database files
  • create some simple programming code using VBA

Prerequisites

Microsoft Access 2016 – Level 3 assumes a significant knowledge of the software, and it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Course Outline

Reviews

There are no reviews yet.

Be the first to review “Access 2016 Advanced”

Your email address will not be published. Required fields are marked *

Related products

  • Adobe InDesign CS6
    $880.00

    About this course

    The skills and knowledge acquired in this courseware will allow the learner to create a variety of documents, both print-based and digital. The learner will be able to create a variety of documents ranging from simple text documents through to complex brochures and flyers with detailed graphics and advanced formatting features

    Course Outline

    Select options
  • academy-it-microsoft-office-project-vendor-training
    Project 2016 Introduction
    $480.00

    About this course

    The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2016 to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

    Course Outline

    Select options
  • academy-it-microsoft-office-excel-vendor-training
    Excel 2016 Introduction
    $360.00

    About this course

    This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

    Course Outline

    Select options
  • academy-it-microsoft-office-word-vendor-training
    Word 2016 Introduction
    $360.00

    About this course

    This hands-on beginner’s course aims to give the learner a sound grounding in the use of Microsoft Word 2016 to create everyday documents required either at work or at home. Particular emphasis is placed on developing accurate and well-designed documents. The course begins by showing the learner how to navigate around Microsoft Word 2016. It then quickly gets the learner to create a new document before moving onto features such as text manipulation and enhancement, creating and using tabs and tables, embellishing documents with clip art and pictures, creating multiple documents through merging and printing documents.

    Course Outline

    Select options