This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. This workshop is designed for the advanced users of Access 2013. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

This workshop is meant to provide a safe learning environment where they can practice and learn Access 2013 Expert functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Classroom
  • April 14th 2023
  • 9 am – 5pm
  • Regus Colorado
    springs
  • Price: $495
Classroom
  • April 21st 2023
  • 9 am – 5pm
  • Regus Salt Lake City, UT
  • Price: $495
Classroom
  • April 26th 2023
  • 9 am – 5pm
  • Regus Framingham, MA
  • Price: $495
Classroom
  • April 28th 2023
  • 9 am – 5pm
  • Regus Bellevue, WA
  • Price: $495
Classroom
  • April 28th 2023
  • 9 am – 5pm
  • Regus Portland, OR
  • Price: $495
Classroom
  • May 12th 2023
  • 9 am – 5pm
  • Regus Atlanta, GA
  • Price: $495
Classroom
  • May 19th 2023
  • 9 am – 5pm
  • Regus Plano, TX
  • Price: $495
Virtual
  • April 28th 2023
  • 9 am – 5pm
  • Online
  • Price: $495

Duration                Learning Credits

1 Day – 8 hours of      8 PDU’s 

Session  


Public Classroom Pricing:

Early Bird Price: USD 595.00

Regular Price: USD 795.00


Instructor-Led Virtual Live Pricing:

Early Bird Price: USD 495.00

Regular Price: USD 695.00


Private Group / In-House Learning:

Have a group of 3 or more people? Register

yourself with a special pricing and request

the training exclusively for your group.

Hot Selling Course
  • 4.5 | 2546 Ratings | 5246 Attended |245 Corporate Trainings
Course Outline

Module One: Customizing Apps (I)

● Creating a Custom App from Scratch

● Adding a Template Table Adding a Blank Table

● Importing Access 2010 Tables

● Module One: Review Questions

Module Two: Customizing Apps (II)

● About Custom Actions

● Adding a Custom Action

● Editing a Custom Action

● Deleting a Custom Action

● Module Two: Review Questions

Module Three: Customizing Apps (III)

● About User Interface Macros

● Creating an Embedded Macro

● Creating a Standalone macro

● Saving Your App as a Package

● Module Three: Review Questions

Module Four: Working with Validation Rules and Messages

● Creating a Field Validation Rule

● Creating a Field Validation Message

● Creating a Validation Rule

● Creating a Validation Message

● Testing Validation Rules

● Module Four: Review Questions

Module Five: Working with Macros

● Creating a Before Change Event

● Working with the Macro Tools Design Tab

● Working with the Action Catalog

● Creating an After Event

● Creating a Named Macro

● Renaming or Deleting Macros

● Module Five: Review Questions

Module Six: Advanced Query Tasks

● Using Query Design View

● Creating Ad Hoc Relationships

● Creating an Update Query

● Creating a Parameter Query

● Comparing Two Tables by Using a Join

● Module Six: Review Questions

Module Seven: Designing Forms

● Common Formatting Tasks

● Using Themes

● Working with Controls

● Adding Header and Footer Elements

● Arranging Form Elements

● Formatting Forms

● Module Seven: Review Questions

Module Eight: Advanced Reporting Tasks

● Using Report Sections

● Using Conditional Formatting

● Grouping and Sorting Data

● Adding Calculated Controls

● Creating Labels

● Module Eight: Review questions

Module Nine: Advanced Database Tools

● Using the Database Documenter

● Analyzing Table Performance

● Analyzing Database Performance

● Repairing a Database

● Compacting a Database

● Module Nine: Review Questions

Module Ten: Working with the Access Environment

● Working with Database Properties

● Encrypting a Database with a Password

● Using Save Object As

● Setting Access Options

● Module Ten: Review Questions

Module Eleven: Wrapping Up

● Words from the Wise

● Review of Parking Lot

Who can attend?

Anybody who is interested in learning Access 2013 Expert Skills

Learning Goals

After completing this course, Individuals will be able to demonstrate their understanding of:

● Customizing Apps

● Working with Validation Rules and Messages

● Working with Macros

● Advanced Query Tasks

● Designing Forms

● Advanced Reporting Tasks

● Advanced Database Tools

● Working with the Access Environment

Frequently Registered Together
Essential Coaching Skills for Managers

Duration: 1 Day
Timing: 9:00 am – 5:00 pm
Certificate: Course Completion Certificate
Price Range: $495 – $595

Essential Management Skills

Duration: 1 Day
Timing: 9:00 am – 5:00 pm
Certificate: Course Completion Certificate
Price Range: $495 – $595

Manager Management

Duration: 1 Day
Timing: 9:00 am – 5:00 pm
Certificate: Course Completion Certificate
Price Range: $495 – $595

Managing Performance

Duration: 1 Day
Timing: 9:00 am – 5:00 pm
Certificate: Course Completion Certificate
Price Range: $495 – $595

Train The Trainer

Duration: 1 Day
Timing: 9:00 am – 5:00 pm
Certificate: Course Completion Certificate
Price Range: $495 – $595

Presentation Skills – Professional

Duration: 1 Day
Timing: 9:00 am – 5:00 pm
Certificate: Course Completion Certificate
Price Range: $495 – $595

Conflict Management

Duration: 1 Day
Timing: 9:00 am – 5:00 pm
Certificate: Course Completion Certificate
Price Range: $495 – $595

Employee Engagement

Duration: 1 Day
Timing: 9:00 am – 5:00 pm
Certificate: Course Completion Certificate
Price Range: $495 – $595

Courses Relevant to your Job Role / Industry
Agile & More
  • 6 Courses
  • 8 Hours
  • Certificate by Mangates
Data Modelling
  • 8 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
ITIL
  • 5 Courses
  • 8 – 16 Hours
  • Certificate by ITIL
DevOps
  • 5 Courses
  • 8 – 24 Hours
  • Certificate by DASA
Cyber Security
  • 5 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
Leadership
  • 15 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
Sales & Marketing
  • 6 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
Testing & Essentials
  • 6 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
Quality Management
  • 4 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
Soft Skills
  • 24 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
Comparing Other Courses
Essential Management Skills
  • Management as a Product
  • Assessing Your Personal Management Style
  • Setting Goals, Strategies, Objectives, Tasks and KPIs
  • Delegating
  • Having Innovative Meetings
  • Creating Engagement
popular
Leading Effective Teams
  • Qualities of an Effective Leader
  • Developing Your Team Goals
  • Dealing With Difficult Team Members
  • Coaching
  • Three Key Skills of Coaching
  • Instant Results Coaching
Performance Management
  • The Performance Management Cycle
  • Adapting Your Leadership Style
  • Giving Difficult Feedback
  • Performance Reviews Practice
  • Using the GROW Model to Joint Problem Solve
  • Managing Poor Performance
Employee Engagement
  • Roles and Responsibilities
  • The Four Enablers
  • Critical Success Factors
  • Creating the Right Work Environment
  • Engagement and Retention
  • Disengagement and the Six Human Needs