Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 5


In this one-day course, students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and many more.

  • Course Start Date: Oct. 4
  • Location: Toronto (Map)
  • Time: 9:00 am - 4:30 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 1 day
  • Delivery Method(s):Instructor Assisted (Mentored)
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Discount Seats Available:2
  • Category:Microsoft Access Training Seminars and Courses

 
Course Outline
This course, rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2010: Basic. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.This course will help students prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2010.

Outline     

Unit 1: Relational databases
  • Topic A: Database normalization
  • Topic B: Table relationships
  • Topic C: Referential integrity
Unit 2: Related tables
  • Topic A: Creating lookup fields
  • Topic B: Modifying lookup fields
  • Topic C: Subdatasheets
Unit 3: Complex queries
  • Topic A: Joining tables in queries
  • Topic B: Using calculated fields
  • Topic C: Summarizing and grouping values
Unit 4: Advanced form design
  • Topic A: Adding unbound controls
  • Topic B: Adding graphics
  • Topic C: Adding calculated values
  • Topic D: Adding combo boxes
  • Topic E: Advanced form types
Unit 5: Reports and printing
  • Topic A: Customized headers and footers
  • Topic B: Calculated values
  • Topic C: Printing
  • Topic D: Labels
Unit 6: Charts
  • Topic A: Charts in forms
  • Topic B: Charts in reports
Unit 7: PivotTables and PivotCharts
  • Topic A: PivotTables
  • Topic B: Modifying PivotTables
  • Topic C: PivotCharts
  • Topic D: PivotTable forms


Prerequisites & Certificates
Pre-Requisites

Access 2010 Level 1 or equivalent knowledge

Certificates offered

Certificate of Completion


Cancellation Policy
Cancellations or postponements received more than ten business days prior to the first day of the course will be fully refunded less a $75 processing fee. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.
Map & Reviews
Acend Corporate Learning
[ View Provider's Profile ]

Toronto Training Center
69 Yonge St
Suite 1200

Toronto, Ontario
Canada   M5H 1A1


Reviews
 
Overall, the course has been well handled by the Training Provider. But i would expect that, somehow, there is a time allotted in the afternoon for more visible and face to face interaction between the TP and the whole class. Others may be asking questions that may not have been thought of by other learners but may be helpful.
Reviewed by 2013
A co worker of mine, did not receive the certificate of completing the course. As well, I received a website to log to after the course for 30 days (The Online Support). Although the vendor ID number does not exisit. I have gone back to my contact at Last Minute Training, and haven't received any feedback from her. The course was good, the follow up, was the greatest service.
Reviewed by 2011
4-October-2016 $236 Regular Price $295 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

Not interested in this Course?

Tell us why:

This page has been viewed 9 times.