Microsoft Access 2016 Level 2

Master the art of advanced data management with Microsoft Access 2016 Level 2, empowering professionals to optimize databases with enhanced querying and reporting techniques.

Course Thumbnail

Essential Skills Gained

Checkmark

Normalize databases to optimize data structure.

Checkmark

Implement advanced queries and calculated fields.

Checkmark

Design and print comprehensive Access 2016 reports.

Checkmark

Utilize advanced form controls for user interaction.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Microsoft Access Users
  • Database Administrators
  • Office Specialists
  • IT Professionals preparing for certification

Description

You will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Unit 1: Relational databases

  1. Database normalization

  2. Table relationships

  3. Referential integrity

Unit 2: Related tables

  1. Creating lookup fields

  2. Modifying lookup fields

  3. Subdatasheets

Unit 3: Complex queries

  1. Joining tables in queries

  2. Using calculated fields

  3. Summarizing and grouping values

Unit 4: Advanced form design

  1. Adding unbound controls

  2. Graphics

  3. Adding calculated values

  4. Adding combo boxes

  5. Advanced form types

Unit 5: Reports and printing

  1. Report formatting

  2. Calculated values and subreports

  3. Printing

  4. Label printing

Unit 6: Charts

  1. Charts in forms

  2. Charts in reports

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.