• Course
  • Vendor

Topics included: Understanding relational databases; Understanding Different Join types to combine table information; Advanced queries; Implementing many-to-many relationships; Import/export data; Advanced reporting

  • Course Start Date: 2019-03-13
  • Time: 08:30:00 - 16:30:00
  • Duration: 1 Day
  • Location: Vancouver
  • Delivery Methods(s): Instructor Led

Course Outline

Pre-Requisites

Microsoft Access 2013 Level 1 or equivalent experience

Lessons

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

Objectives
  • Understanding relational databases
  • Understanding Different Join types to combine table information
  • Advanced queries
  • Implementing many-to-many relationships
  • Import/export data
  • Advanced reporting
Outline
  • Lesson 1: Designing a Relational Database
    • Topic A: Relational Database Design
    • Topic B: Create a Table
    • Topic C: Create Table Relationships
  • Lesson 2: Joining Tables
    • Topic A: Create Query Joins
    • Topic B: Join Tables That Have No Common Fields
    • Topic C: Relate Data within a Table
    • Topic D: Work with Subdatasheets
  • Lesson 3: Creating Advanced Queries
    • Topic A: Create Parameter Queries
    • Topic B: Create Action Queries
    • Topic C: Create Unmatched and Duplicate Queries
    • Topic D: Summarize Data
  • Lesson 4: Organizing a Database for Efficiency
    • Topic A: Data Normalization
    • Topic B: Create a Junction Table
    • Topic C: Improve Table Structure
  • Lesson 5: Sharing Data Across Applications
    • Topic A: Import Data into Access
    • Topic B: Export Data to Text File Formats
    • Topic C: Export Access Data to Excel
    • Topic D: Create a Mail Merge
  • Lesson 6: Advanced Reporting
    • Topic A: Organize Report Information
    • Topic B: Format Reports
    • Topic C: Include Control Formatting in a Report
    • Topic D: Add a Calculated Field to a Report
    • Topic E: Add a Subreport to an Existing Report

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 144 reviews.

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
Only challenge was the computers were not working properly in the lab. They were slow and seemed to take a long time to run progra ... Read more
x

Only challenge was the computers were not working properly in the lab. They were slow and seemed to take a long time to run programs and run Adobe Illustrator.

Parking - I took the Harbour Air Shuttle. Environment - Good based on the renovations and recent move that just took place. This ... Read more
x

Parking - I took the Harbour Air Shuttle. Environment - Good based on the renovations and recent move that just took place. This is completely understandable. Instructor - Bev is amazing.

Course Reviews

No Reviews Yet

More Courses from On Track Computer Training

ON TRACK COMPUTER TRAINING
2019-02-26
Vancouver
ON TRACK COMPUTER TRAINING
2019-02-20
Vancouver
ON TRACK COMPUTER TRAINING
2019-04-12
Vancouver
ON TRACK COMPUTER TRAINING
2019-03-27
Vancouver

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

ON TRACK COMPUTER TRAINING
2019-03-06
Vancouver
GLOBAL KNOWLEDGE
2019-06-03
Vancouver