Microsoft Access 2013 Level 2

Planning Information

The duration of this course is 1 Day. The list price is $295.00.

Description

In this Microsoft® Access® 2013 Level 2 course, students will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts. Students will also have the opportunity to and create specialized objects such as lookup fields, sub forms and sub reports, navigation forms, and calculated fields. 

Intended Audience

This course is designed for persons who are able to create and modify basic tables, forms, and reports in Microsoft Access 2013, but need to know how to create or modify documents using advanced tools and efficiency procedures.                                                   

Prerequisites

Students should be able to use Microsoft Access 2013 to create and manage tables and basic queries, define product options, compare/contrast types of table relationships, navigate the Access 2013 environment. Students can obtain this level of skill by taking Microsoft Access 2013 Level 1.

Materials

Courseware Microsoft® Access® 2013 Intermediate MOS Edition

Course Outline

Lesson: Introduction

  • About the manual

  • Setting up your expectations

  • Re-keying the course

Lesson: Relational databases

  • Database normalization

  • Table relationships

  • Referential integrity

Lesson: Related tables

  • Creating lookup fields

  • Modifying lookup fields

  • Subdatasheets

Lesson: Complex queries

  • Joining tables in queries

  • Using calculated fields

  • Summarizing and grouping values

Lesson: Advanced form design

  • Adding unbound controls

  • Graphics

  • Adding calculated values

  • Adding combo boxes

  • Advanced form types

Lesson: Reports and printing

  • Report formatting

  • Calculated values and subreports

  • Printing

  • Label printing

Lesson: Charts

  • Charts in forms

  • Charts in reports

This course is also available for private training. Please contact us to learn more.
Register your interest now

Pin It on Pinterest