Loading Events

Access 2016 – Intermediate (1 Day)

You have the basic skills needed to work with Microsoft® Office AccessTM 2016 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Who is this course for?

Microsoft Office Access 2016: Intermediate is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Intermediate course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2016.

Pre-requisites

  • Microsoft Office Access 2016: Basic

Objectives

Upon successful completion of this course, students will be able to:

  1. Modify the design and field properties of a table.
  2. Retrieve data from tables.
  3. Create flexible queries to display specified records.
  4. Enhance the capabilities of a form and add graphics.
  5. Customize reports.
  6. Share Access data across other applications.
  7. Use charts and Pivot Tables.

Course Contents

Unit 1: Relational databases

  • Database normalization
  • Relating tables
  • Implementing referential integrity

Unit 2: Related tables

  • Lookup fields
  • Modifying lookup fields
  • Sub datasheets

Unit 3: Complex queries

  • Joining tables in queries Calculated fields
  • Summarizing and grouping values

Unit 4:  Advanced form design

  • Adding unbound controls
  • Adding Graphics
  • Adding calculated values
  • Adding combo boxes
  • Advanced form types

Unit 5: Reports and printing

  • Customized headers and footers
  • Adding calculated values
  • Printing
  • Labels

Unit 6: Charts

  • Charts in forms
  • Charts in reports

Unit 7: Pivot Tables and Pivot Charts

  • Pivot Tables
  • Modifying Pivot Tables
  • Pivot Charts
  • Pivot Table forms
R1,900
1 day
April 25
8:30am - 4:30pm

Book your place

(14 places available)