Microsoft Access- private, one on one training - INTERMEDIATE level

You’ve started using MS Access but you know you can do more. You want to know how to use its more advanced functions. Our private one on one training will target the areas you need help with and teach you what you need to know quickly and effectively

Course Outline

You’ve started using MS Access but you know you can do more. You want to know how to use its more advanced functions. Our private one on one training will target the areas you need help with and teach you what you need to know quickly and effectively.

Ideally doing creating a complex database would be easy. You would know all of the features and be able to fully utilize the tools provided.

Instead you find yourself spending a lot of time looking up instructions and trying to figure out how to do things using online help.

Really you just need someone to spend a little time with you to teach you the things you don't know - quickly and affordably.

That has been difficult up until now since you don't have time to spend taking a full day seminar, or even a series of evening seminars. Even then, most of those seminars cover materials you already know.

Fortunately by using our one on one private training you can get the exact learning you need, only the learning you need, in a shorter time and without leaving your office.

Here are the 5 main benefits of attending this seminar:

• You will learn only what you need to learn - not what someone else needs to learn
• You will get private one on one instruction.
• All of the focus wil be on you and your needs.
• You won't have to leave the office.
• More training, taught more effectively, in a shorter period of time.

What can be learned at this seminar: WORKING WITH THE NORTHWIND SAMPLE DATABASE

• Installing the NORTHWIND Database

DESIGNING TABLES IN ACCESS

• Normalizing Data
• Establishing Relationships
• Working with Indexes and Data Types
• Joining Tables

DESIGNING QUERIES IN ACCESS

• Creating Action Queries, Parameter Queries ating a Table
• Creating Calculated Columns in Queries

DESIGNING FORMS IN ACCESS

• Creating Date Entry Forms and Pop-up Forms
• Working with Sub-forms
• Working with Switchboards

DESIGNING REPORTS IN ACCESS

• Working with Standard Reports, Pop-up Reports, Sub-reports and Report Snapshots
• Developing Data Access Pages

WORKING WITH PIVOTTABLES AND PIVOTCHARTS

• Creating Pivot-Tables and Pivot-charts
• Creating Pivot-table and Pivot-chart Forms

IMPORTING AND EXPORTING

• Linking to External Data Sources
• Importing Data into ACCESS
• Exporting Data from ACCESS

BUILDING EXPRESSIONS

• Using the Expression Builder
• Using common built-in functions

Testimonial

JN Software was exceptionally flexible and able to work quickly on a large project crucial to my program at the XVI International AIDS Conference. Surprisingly, they were not only able to create a comprehensive computer program, but also able to teach me how to use it! I will definitely call on JN Software to assist me in the future.

Christine Johnston,Volunteer Coordinator, AIDS 2006 Local Host Secretariat XVI Internationa1 About our seminar leader (s):

Joy Neuhold is a Certified Adult Educator who has spent the last 5+ years helping computer users throughout Canada improve their skills by conducting one-on-one training sessions both online and on-site. As an entrepreneur, she built JN Software Consulting from the ground up into a business that now helps numerous medium business, small business and individual clients meet their Software Training, Website Design and Database Development needs. Joy explains,” “My favorite thing about training is to watch someone’s face when they have been struggling with a problem and suddenly they get it! Then to see how proud of themselves they are.” When asked what she enjoys about having her own company Joy explains, “I enjoy the freedom of meeting new peo

Prerequisites & Certificates

Pre-Requisites

A short phone conversation with the trainer to establish your training needs. Cancellation Policy JN Software Consulting works hard to schedule our training around your life, for your convenience. With that in mind we have the following cancellation policies. – Less than 24 hours notice: Full quoted fee – Less than 48 hours notice: 50% of quoted fee – Less than 5 business days notice: 20% of quoted fee – Clients will incur a $40 charge for any NSF cheques.

Certificates offered

Cancellation Policy

JN Software Consulting works hard to schedule our training and other services around your life, for your
convenience. With that in mind we have the following cancellation policy for all booked training. 

•  Less than 48 hours: Full quoted fee 
•  Less than 5 business days: 20% of quoted fee 
• NSF Charge Policy
  Clients will incur a $40 charge for any NSF cheques

 PLEASE NOTE: Onsite sessions are subject to a 3 hour minimum charge regardless of the duration of the actual training. For sessions expected to last less than 3 hours we suggest booking a live online training session.

Map & Reviews

JN Software Consulting
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

Excellent course. Even my most advanced excel users came away with valuable new ways to use excel. I highly recommend this course.

Reviewed by Leigh C. 2012

   

The course was well organized and I recieved lots of attention during the planning phase to make sure we designed the course appropriately for our team I would definately recommend JN Software.

Reviewed by Leigh C. 2012

   

Philippe was really good at catering the training to our needs. He figured out what our prior knowledge was on the topic and went from there istead of having us go over things we already knew. If we had been in a group setting this would not have been possible. He also was helpful in letting us know how the 2003 version was different from the 2010. We therefore purchased an additional training manual for the 2010 version as we recently had it installed on our workstations.

Reviewed by Jennifer H. 2012

   

There was a little mix up with the time the course was to be held. The website said 9-4 but it should have been 10-5, so when I arrived no one was there. However, it was dealt with quickly after a call and the trainer arrived quickly. I was the only person attending the course, it was very informative and it allowed us to touch on all of the questions I had specifically.

Reviewed by Amy D. 2012

   

The instructor was excellent - she was very knowledgeable, patient, and really tried to tailor the course and specific examples to each student. The room was bit too cold in the morning and quite warm in the afternoon, so I would recommend wearing layers for comfort! I would highly recommend this course.

Reviewed by Sarah K. 2012

   

The instructor used real situations from the participants, so it was extremely relevant to what we were doing. She was very knowledgable and answered all questions.

Reviewed by Sandy P. 2011

   

Very informative session focused on all my concerns regarding advanced QuickBooks. Carolyn was helpful and very pleasant to learn from. I would reccomend her highly and might want to work with her again in the future.

Reviewed by Carmina D. 2011

   

The instructor was very knowlegeable but the seminar wasn't very well structured. No handouts, ran out of time before al topics were covered. Certain points were belabored at the expense of covering all desired topics.

Reviewed by Christopher D. 2011

   

I think this training need more time, it was a bit short in duration

Reviewed by Randa E. 2011

   

Course was given on site at my work place - very convenient. Outline changed during course to fit more with our goups needs. Time frame changed also and this caused some disorganization.

Reviewed by Roxanne A. 2011

   

Gordon was a great presenter and traininer, I learned a lot and he has inspired me to further my knowledge in this subject.

Reviewed by Scott R. 2011

   

We all enjoyed Shauna's presentation of Adobe. She's a knowledgeable trainer.

Reviewed by Anita P. 2011

   

Good course, great instructor.

Reviewed by Nicholas P. 2011

   

The instructor was amazing.

Reviewed by Adam B. 2011

   

Excellent training - instructor, facility, course content. Thank you.

Reviewed by Linda S. 2011

   

I took a private class with Jon and it was terrific. He was very knowledgeable and patient in explaining to me the mechanics of what I needed to know. I have worked with excel as long as I can remember, however I started a new job that required me to us

Reviewed by Christopher . 2008