Microsoft Access 2016 Intermediate Training Course Outline

Microsoft Access Training CoursesThis one-day course builds on the skills and concepts taught in Access 2016: Basic. Students will learn how to normalise data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts.

 

 

Course objectives

After completing this course, students will know how to:

  1. Normalise tables, analyse tables and view object dependencies, set table relationships, implement referential integrity between related tables, and set cascading deletes and updates.
  2. Create a lookup field and a multivalued field, modify lookup field properties, and use a subdatasheet to add data to related tables.
  3. Create join queries, create calculated fields in a query, and use queries to view summarized and grouped data.
  4. Add unbound controls, graphics, and calculated fields to a form; create multiple item forms, split forms, datasheet forms, and subforms.
  5. Add headers and footers in a report, use functions to add calculated values in a report, print table objects and database documents, and create labels.
  6. Create and modify charts in forms and reports.
  7. Create a PivotTable, modify a PivotTable, and create a PivotChart and a PivotTable form.

Course contents

Relational databases 
Topic A: Database normalisation 
Topic B: Table relationships 
Topic C: Referential integrity

Related tables 
Topic A: Creating lookup fields 
Topic B: Modifying lookup fields 
Topic C: Subdatasheets

Complex queries 
Topic A: Joining tables in queries 
Topic B: Using calculated fields 
Topic C: Summarizing and grouping values

Advanced form design 
Topic A: Adding unbound controls 
Topic B: Graphics 
Topic C: Adding calculated values 
Topic D: Adding combo boxes 
Topic E: Advanced form types

Reports and printing 
Topic A: Report formatting 
Topic B: Calculated values and subreports 
Topic C: Printing 
Topic D: Label printing

Charts 
Topic A: Charts in forms 
Topic B: Charts in reports 

Prerequisites

Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that you've completed the following courses or have equivalent experience: Windows : Basic level and Access 2016: Basic level.

Target Audience

Youshould be comfortable using a personal computer and Microsoft Windows. You should also have some experience using Access 2016. You will get the most out of this course if your goal is to become proficient using more advanced Access features and functions, such as relating tables, referential integrity, joins, queries, forms, reports, charts, PivotTables, and PivotTables charts and forms.

Certification Track

For comprehensive training, you should complete all of the following courses: Access 2016: Basic, Access 2016: Intermediate, and Access 2016: Advanced.