Access Advanced

Course Description:

 : Thie Microsoft Access 2016 Advanced course will expand upon the topics covered in the Access 2016 Introduction course, including teaching relational database design, writing advanced queries, structuring existing data, sharing data across applications, and customizing reports. lease note: This class taught using the Access 2016 version and is for users of Access 2016, 2013 and 2010. There are very few differences between the versions, and the instructor will highlight any differences.

Upon completion of the course, users will be able to:

• Efficiently organize a database
• Join tables
• Perform advanced reporting
• Implement advanced form design
• Use data validation
• Use macros to improve user interface design
• Use advanced database management
• Managing switchboards

Course Content

Section 1: Organizing a Database for Efficiency
Topic 1: Data Normalization
Topic 2: Creating a Junction Table
Topic 3: Improve Table Structure

Section 2: Joining Tables
Topic 1: Creating Query Joins
Topic 2: Relating Data Within a Table
Topic 3: Working with Subdatasheets

Section 3: Creating Advanced Queries in Access 2016
Topic 1: Creating Parameter Queries
Topic 2: Summarizing Data
Topic 3: Creating Subqueries
Topic 4: Creating Action Queries
Topic 5: Creating Unmatched and Duplicate Queries

Section 4: Using Advanced Reporting Techniques
Topic 1: Including Control Formatting in a Report
Topic 2: Adding a Calculated Field to a Report
Topic 3: Adding a Subreport to an Existing Report

Section 5: Implementing Advanced Form Design
Topic 1: Adding Controls to Forms
Topic 2: Enhancing Navigation and Organization of Forms
Topic 3: Applying Conditional Formatting

Section 6: Using Data Validation
Topic 1: Using Field Validation
Topic 2: Using Form and Record Validation

Section 7: Using Macros to Improve User Interface Design
Topic 1: Creating a Macro
Topic 2: Restricting Records Using a Condition
Topic 3: Validating Data Using a Macro
Topic 4: Automating Data Entry Using a Macro

Section 8: Managing Switchboards
Topic 1: Creating a Database Switchboard
Topic 2: Modify a Database Switchboard
Topic 3: Set Startup Options

Section 9: Using Advanced Database Management
Topic 1: Managing a Database
Topic 2: Determining Object Dependency
Topic 3: Documenting a Database

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation