Microsoft Access On-site Training Courses

Our experts are here to help

We’re now offering Microsoft Access On-site Training for Introductory, Intermediate, and Advanced levels. As experts in the field, we’ve had a demand for this service and have done some trial runs with a handful of companies.

Learn More

Contact Us Today

(773) 809 5456

sales@itimpact.com

  • Hidden
  • Hidden

What is Microsoft Access and why?

Microsoft Access is a database tool to manage, store, retrieve, analyze and report information. It can streamline businesses processes and help you do more with your business with the same amount of employees.

Microsoft Access training from IT Impact, Inc. puts you in the driver’s seat to take control and discover the power of your data! The course will help you manage your database as efficiently as possible.

What does each course include?

What better way to know the ins and outs of your Access database than to learn from the pros? Juan Soto, a recognized Microsoft Access MVP and President of IT Impact, is available for on-site Access training at your company for any number for employees and users. Each course level runs for three days and includes techniques for optimization with SQL Server.

Sample MS Access On-site Training Syllabus

Here you can see our sample syllabus for on-site MS Access Training: Introductory, Intermediate & Advanced courses. Depending on your needs and user level, we can adjust and customize each syllabus to fit your company’s needs and leverage MS Access to your best advantage.

Introductory Class

Day 1

  • Design tips for SQL Server tables
    • What is the ONE field type every table should have?
    • Where NOT to add a new field in a table
  •  Linking to SQL Server Databases using DSNs
    • How to create DSNs
    • How to refresh DSN links after changes to a table in SQL Server
  • Tips and tricks to filtering data in the data grid. (Hint: Use the force, I mean the right-click)
  • Creating native tables in Access, do’s and don’ts
  • Creating Forms using the wizard
    • Adding objects to your forms using wizards: List boxes, combos and command buttons
  • Adding subforms

Day 2

  • Reports
    • Creating reports using the wizard
    • Adding groups
    • Adding subtotals
    • Adding Filters
    • Adding subreports
  • Queries
    • Know the answer before asking the question
    • Using the query wizard
    • Creating left, right and outer joins
    • Creating group by queries
    • Creating calculated columns

Day 3

  • Importing data into Access
    • Excel imports
    • CSV imports
  • Cleaning data using queries
  • Adding data from imports into other tables (Insert Queries)
  • Creating import specifications and saving them
  • Linking vs. importing Excel data

Intermediate Class

Day 1

  • Designing SQL Server Tables for Access
  • Adding indexes to tables
  • Creating views in SQL Server
    • Do’s and don’ts for using views in Access
      • You can’t edit data using views in Access, or can you?
      • To delete or not delete?
  • Forms
    • Adding controls and programming command objects
    • Launching forms with where clauses
    • Advanced combos and list controls

Day 2

  • Reports
    • Launching reports with where clauses
    • Sub reports
  • Queries
    • Creating a house of cards (using multiple queries together)
    • SQL mode vs. QBE or in other words, doing it the hard vs. easy way
    • Why we don’t bother with hybrid queries, unless you need a coffee break

Day 3

  • Importing data from Excel
  • Creating a program to clean imported data
  • Exporting to other formats
  • Querying SQL Server data from Excel (yes, no need for Access)

Advanced Class

Day 1

  • TSQL Primer
  • Query Optimisation
  • Creating SQL Server procedures – use table variables or temp tables, that is the question
  • Invoking SQL Server Procedures using Access pass through queries
  • Changing Access queries SQL on the fly with code
  • Server Processing vs Doing it in Access

Day 2

  • Form object model
    • Controls Collection
    • Iterating through controls
  • TableDefs Collection
  • Form recordsets
    • Using the bookmark property
  • Using queries in your code with recordsets – the easy way
  • TempVars
  • Proper coding conventions
  • Functions vs Subroutines
    • ByVal or ref?

Day 3

  • Creating a menu system in Access
  • Invoking forms from other forms
    • Reading data from one form to another
  • Advanced Importing Techniques
  • Excel Querying

Total Costs: $5,640 + expenses