Microsoft Access Training Courses | Intermediate Level – Toronto

$275

Next Class:

TBA ( 10 a.m. – 4:30 p.m.)

SKU: N/A Categories: ,

MS. Access Training Course – Access Intermediate Level Classes | Designed for Microsoft Access 365, 2019, 2016, 2013

 

The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros.

Training Type:  Classroom Training – Downtown Toronto ” Also available in Mississauga and Scarborough”

Other options : Online Training- On-site at your company office ” Anywhere”

Course Level:  Microsoft Access Intermediate Level Class

Related Access TrainingMicrosoft Access Introduction Level course–  Microsoft Access Advanced Level

Number of students per session:  Our class sizes are typically 6 students per session. Our classes are intentionally kept small in order to foster more interaction between the instructor and students. We limit classes to a maximum of six (6) students unless we are teaching a private group or organization. Each student is provided a laptop with hands-on access to Microsoft Access 365 (Windows)

Locations: Toronto ( 1 Yonge St),  Also we offer the course in Mississauga & Scarborough.

Duration:   1 day  ( 10 AM- 5 PM)

Special Offers:   Sign up with a friend and save 5% each  – Sign up with 2 friends and save 10%

Bring your laptop: Save $ 25 “$225 only” (Your laptop with Microsoft Access 2016 or Access 2019 installed). You can get Microsoft office including MS.Access 2019 for less than $15/Month from Microsoft Office Official site. Select Office 365 Business

Corporate Training:  Contact us for special offers

 

PREREQUISITES

Microsoft Access 2016  Intermediate Level assumes some knowledge of the software to create basic databases and generate reports. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment. Also suitable for those who attended our Access Introduction course. If you have intermediate knowledge of Microsoft Access , you can improve your skills by taking our Microsoft Access Advanced Level Class

 

TARGET AUDIENCE

Our Microsoft Access Intermediate course is suitable for those with a basic working knowledge of Microsoft Access.

Learning Outcome

At the completion of this course you should be able to:

  • Use various data validation features in Access to protect data
  • Format the data in a table
  • Perform more advanced queries using a variety of querying techniques
  • Create and use parameter queries
  • Create calculated queries
  • Modify and adapt an existing form according to specific needs
  • Create a navigation form for a database in Access 2016
  • Create forms using a combination of wizards and manual techniques
  • Create and use macros in Access
  • Work with a number of macro techniques
  • Create and work with macros in forms
  • Create and manage custom categories and groups in the Navigation Pane

After completing this course you will be prepared to attend the Access Advanced training course.

 

COURSE OUTLINE

Data Validation

  • Assigning Default Values
  • Validation Rules and Text
  • Validating Numbers
  • Setting Required Fields
  • Working With Validations

Formatting Tables

  • Changing Column Widths
  • Formatting Cells in a Table
  • Changing Fonts
  • Moving Columns in a Table
  • Freezing Columns in a Table
  • Hiding Columns in a Table
  • Unhiding Columns

Querying Techniques

  • Modifying a Saved Query
  • Creating AND Queries
  • Creating OR Queries
  • Querying Numeric Data
  • Querying Dates
  • Using a Range Expression
  • Querying Opposite Values
  • Moving Fields in a Query
  • Sorting Query Data
  • Removing Fields From a Query
  • Querying Using Wildcards
  • Problem Characters
  • Querying With a Lookup Table
  • Sorting Query Data Numerically
  • Displaying NULL Values
  • Querying for Uniqueness

Parameter Queries

  • Creating a Parameter Query
  • Displaying All Records
  • Using Parameters to Display a Range
  • Using Parameters in Expressions
  • Using Parameters With Wildcards

Calculations in Queries

  • Creating a Calculated Field
  • Formatting Calculated Fields
  • Summarizing Data Using a Query
  • Changing the Grouping
  • Calculating With Dates
  • Using Criteria in Calculations
  • Concatenating String Fields

Modifying Forms

  • Understanding Form Design and Layout
  • Switching Between Form Views
  • Selecting Form Objects
  • Working With a Control Stack
  • Changing Control Widths
  • Moving Controls on a Form
  • Aligning Controls
  • Understanding Properties
  • Changing Label Captions
  • Adding an Unbound Control
  • Adding a Control Source
  • Formatting a Control
  • Checking the Current Tab Order
  • Changing the Tab Order
  • Inserting the Date Into the Form Header

Using a Navigation Form

  • Creating a Simple Navigation Form
  • Creating a More Complex Navigation Form
  • Creating the Navigation Form Page Tabs
  • Creating Subsidiary Pages
  • Adding Subsidiary Pages
  • Editing Page Tab Names
  • Applying a Theme
  • Modifying Properties
  • Automatically Starting the Navigation Form

DIY Forms

  • Creating a Multiple Item Form
  • Adjusting the Layout of a Form
  • Typing Into a Form Layout
  • Disabling Fields
  • DIY Sub Forms
  • Removing SubForm Redundancy
  • Splitting and Merging Layout Cells
  • Adding an Easy Lookup Field
  • Adding Buttons to a Form
  • Adjusting Form Properties

Creating and Using Macros

  • Understanding Macros and VBA
  • Creating a Macro
  • Running a Macro
  • Modifying an Existing Macro
  • Interacting With the User
  • Stepping Through a Macro
  • Documenting Macros

Macro Techniques

  • Creating a Print Macro
  • Using Conditions to Enhance a Macro
  • Creating a Sequence of Conditions
  • Understanding the Versatility of MsgBox
  • Using the MsgBox Function
  • Reconfiguring a Message Box
  • Using the InputBox Function

Macros on Forms

  • Understanding Macros on Forms
  • Creating Navigation Macros
  • Accessing Event Macros
  • Creating Unassigned Buttons
  • Programming an Event
  • Running an Event Macro
  • Modifying an Event Macro
  • Setting Echo Off
  • Adding a Close Button
  • Creating a Search Macro
  • Running the Search Macro
  • Understanding the Search Macro
  • Naming Macros
  • Referencing Macro Sheet Macros

Navigation Pane Protection

  • Understanding the Navigation Pane
  • Creating Custom Categories
  • Creating Custom Groups
  • Adding Objects to a Group
  • Hiding Groups and Objects
  • Showing Hidden Groups and Objects

 

Included Course Materials

  • Course workbook “PDF” including step-by-step course exercises complete with many actual screen captures and advanced project tips, exercises and answers
  • Data files with all applicable Microsoft Access files used in the course
  • Certificate of completion (PDF)

For more details about Microsoft Access , please visit the product  official page Access

 

 

 

Related Classes

Microsoft Access Introduction Level Training Courses in Toronto

Microsoft Access Advanced Level Training in Toronto

Microsoft Excel 2019 Fundamentals Training Courses in Toronto, Mississauga & Ottawa

Microsoft Excel 2019 Intermediate Training Classes in Toronto, Mississauga & Ottawa

Microsoft Excel 2019 Advanced Level Classes in Toronto, Mississauga & Ottawa

Microsoft Excel 2019 Tables, Pivot Tables and Conditional Formatting

Microsoft Excel 2019 | Using Formulas for Financial Analysis.

Microsoft Excel 2019 | Using Formulas For Statistical Analysis

Microsoft Excel 2019 | Data Analysis with Pivot Tables

Delivery Methods:

  1.  Classroom Training: Downtown Toronto – Mississauga , Scarborough, Ottawa & Montreal.
  2.  Virtual Classroom
  3.  On-Site Training: At your location, anytime , anywhere
  4.  Corporate Training: Special rates for Corporate Training

Group Discount:

We provide special rate for groups :

  • 5% Discount for Group of 2
  • 10% Discount for Group of 3
  • 15% Discount for Group of 4

PMVISION reserves the right to postpone/cancel an event, or change the location of an event because of insufficient enrollments, instructor illness or force-majeure events.

 

Cancellation & Refund Policy

  • Reserve your seat fee:  Non Refundable. To be refunded if the class is cancelled by PMVISION
  • In case PMVISION  cancels an event, 100% refund will be paid to the delegate.
  • If the cancellation is done by the delegate within 48 hours of subscribing, 10%  will be deducted as administration fee.
  • If a cancellation is done by a delegate 7 days or more, prior to the event, 20% will be deducted as administration fee.
  • If a cancellation is done by a delegate 7 days or less, prior to the event, no refunds will be made
  • Bookings made at discounted prices ( Including Early Bird Booking) cannot be cancelled.
  • If you will have to travel to attend the course, please don’t make any travel arrangements until we confirm the class. We usually usually confirm the class by emails at least one week prior to the start date.

 

IMPORTANT: We recommend waiting to book any non-refundable travel until 1 week  before the start of class. PMVISION is not responsible for any loss incurred as a result of a canceled class. Please email: contact@pmvision.ca for any additional questions.

Certificate of Completion (PDF Format) is available upon attending the course.