• Course
  • Vendor

Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.

  • Course Start Date: 2019-10-16
  • Time: 08:30:00 - 16:30:00
  • Duration: 1 Day(s)
  • Location: Vancouver
  • Delivery Methods(s): Instructor Led
$329.00
October 16th
Click for more dates
2 seats left!
or make an offer

Course Outline

Pre-Requisites

Familiarity with personal computers and keyboard and mouse Basic Microsoft Windows Skills Knowledge of Excel data management (Optional)

Lessons

Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.

Objectives

To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.

Outline
  • Introduction to Databases
    • Database concepts
    • Database Layout
    • Launching Access
    • The Access Menu System
    • Dialog Boxes
    • Getting Help
    • Creating A New Database
    • Creating an Access Web App
    • Closing A Database (Vs Exit Access)
    • Opening A Database
  • Tables
    • Database Design
    • Creating Tables Using The Table Wizard
    • Creating Tables In The Datasheet View
    • Creating Tables In The Design View
    • Data Types
    • Field Properties
    • Data Display Format Vs Input Mask
    • The Input Mask
    • Data Entry Problems
    • Moving And Copying Records
  • Working with Tables
    • Pasting Records
    • Sorting The Table
    • Deleting A Table
    • Table Layout Changes
    • Find
    • Replace
    • Wildcards
  • Queries
    • The Simple Query Wizard
    • The Design View
    • Modifying The Query
    • Using Basic Criteria
    • Additional Criteria
    • Parameters
    • Multiple Object Queries
    • Custom Calculations In A Query
    • Calculating Fields Continued
    • Grouping Fields
  • Introduction to Reports
    • Reports
    • The Report Wizard
  • Introduction to E-mailing database information
    • E-Mailing Database Information

Cancellation Policy

Should you postpone or cancel your course you must give 5 business days notice.

Training Location

On Track New Location
609 Granville Street 6th Floor

Vancouver, BC
Canada   

About On Track Computer Training

x

For the best in Microsoft Excel Training in Vancouver, or any other Microsoft product training, including Access, Word, Outlook, PowerPoint or Project training come to On-Track Computer Training. In addition to Microsoft program we also offer: Dreamweaver MX training FrontPage training HTML training courses Flash MX & CS3 training Acrobat 7.0 Professional Illustrator CS2 & CS3 training InDesign CS2 & CS3 training Photoshop CS2 & CS3 training MS Publisher 2003 Visio 2002 training and much more in the Vancouver area. On-Track Computer Training Ltd. has been providing corporate computer training since 1989 and has established itself as a leader in innovative training, consulting and development. As a Microsoft GOLD Certified Partner On-Track continually strives to achieve the best in computer training and guarantees results and rates through our client satisfaction program. GUARANTEE'S Results: On-Track will retrain you at our cost if you are unable to understand objectives and provide complimentary refresher courses within 6 months Rates: On-Track will beat any written corporate computer training rate Support: On-Track provides free technical support through our email and phone system for those difficult situations Service: On-Track staff are all owners of the company and take pride in the service we offer

Training Provider Rating

This vendor has an overall average rating of 4.36 out of 5 based on 146 reviews.

I was expecting to see and learn more advanced materials like pivot point and vlookup in Level 2, but they are in level 3 so I ha ... Read more
x

I was expecting to see and learn more advanced materials like pivot point and vlookup in Level 2, but they are in level 3 so I have to come back for level 3.

She did a wonderful job with our group. It was fun and educational.
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
Great course, great teacher.
No comment
No comment
No comment
No comment
Course was more than I had expected and the trainer was very pleasant and enjoyable to learn from!
Learned what I needed and more. Good class size.
No comment
No comment

Course Reviews

This course has an overall avarage rating of 4.93 out of 5 based on 1 reviews.

Previous

Oliver K attended this course May 2018

Course Content

Delivery Structure

Instructor Ability

Great course, great teacher.

More Courses from On Track Computer Training

ON TRACK COMPUTER TRAINING
2019-10-30
Vancouver
ON TRACK COMPUTER TRAINING
2019-10-24
Vancouver
ON TRACK COMPUTER TRAINING
2019-10-23
Vancouver
ON TRACK COMPUTER TRAINING
2019-10-01
Vancouver

More Courses in 'Microsoft Access Training Seminars and Courses' Category

ON TRACK COMPUTER TRAINING
2019-10-23
Vancouver
CTC TRAINCANADA
2020-08-31
Vancouver
GLOBAL KNOWLEDGE
2020-03-04
Vancouver
GLOBAL KNOWLEDGE
2019-12-04
Vancouver