Loading Events

Access 2013 Intermediate ( 2 Days)

  • This event has passed.

You have the basic skills needed to work with Microsoft® Office Access™ 2013 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 2013: 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 2013.

Pre-requisites

  • Microsoft Office Access 2013: Basic

Course content

Unit 1: Relational databases

  • Database normalization
  • Relating tables
  • Implementing referential integrity

Unit 2: Related tables

  • Lookup fields
  • Modifying lookup fields
  • Subdatasheets

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: PivotTables and PivotCharts

  • PivotTables
  • Modifying PivotTables
  • PivotCharts
  • PivotTable forms
R3,800
2 days
19 September 2017 to 20 September 2017
8:30am - 4:00pm

Book your place

(12 places available)