ObjectSharp logo
The Microsoft Software Development and Training Experts

Course Info

Guaranteed-to-Run
Instructor-in-Cloud
Duration: 2 days
Price: $598

Upcoming Classes

May 2013

Thu 30 - Fri 31 Register

June 2013

Mon 17 - Tue 18 Register

July 2013

Mon 08 - Tue 09 Register
Mon 22 - Tue 23 Register

August 2013

Thu 08 - Fri 09 Register
Thu 22 - Fri 23 Register

Call to register

416-649-3691

Learn from the
Pros Who Know

During this course students will have the opportunity to discuss their own projects with an ObjectSharp subject matter expert.

Home > Training > 

Access 2007 - Level 2

Course Outline

Lesson 1 - Relational databases
  1. Topic A: Database normalization
  2. Topic B: Relating tables
  3. Topic C: Implementing referential integrity
Lesson 2 - Related tables
  1. Topic A: Lookup fields
  2. Topic B: Modifying lookup fields
  3. Topic C: Subdatasheets
Lesson 3 - Complex queries
  1. Topic A: Joining tables in queries
  2. Topic B: Calculated fields
  3. Topic C: Summarizing and grouping values
Lesson 4 - Advanced form design
  1. Topic A: Adding unbound controls
  2. Topic B: Adding Graphics
  3. Topic C: Adding calculated values
  4. Topic D: Adding combo boxes
  5. Topic E: Advanced form types
Lesson 5 - Reports and printing
  1. Topic A: Customized headers and footers
  2. Topic B: Adding calculated values
  3. Topic C: Printing
  4. Topic D: Labels
Lesson 6 - Charts
  1. Topic A: Charts in forms
  2. Topic B: Charts in reports
Lesson 7 - PivotTables and PivotCharts
  1. Topic A: PivotTables
  2. Topic B: Modifying PivotTables
  3. Topic C: PivotCharts
  4. Topic D: PivotTable forms
show more>>

Guaranteed-to-Run

Our Live Instructor-in-the-Cloud classes are Guaranteed-to-Run. And you can count on it. They’re Online Live (OLL), and that means you never have to worry about cancellations caused by low enrolment or other problems. All our Guaranteed-to-Run classes run on their scheduled dates. No exceptions. No excuses. We guarantee it!

show more>>

Our outstanding ObjectSharp instructors are known throughout the IT community for their real-world business experience. We’ve teamed them up with the best IT trainers from across North America. Together, they allow us to offer a huge array of IT training classes to our clients.

From Microsoft to Oracle, from Adobe to Cisco, we’re running over 500 Live Instructor-led classes in the next 90 days alone! And almost all of them are Guaranteed-to-Run. One more reason why ObjectSharp is your best choice for IT technical training in Toronto.

Our Training Center

We encourage you to take this Instructor-Led Training: Live Online course at our downtown Toronto Training Center at 40 University Avenue. For TTC riders, we are right on the subway line just south of the St. Andrews station. For GO-Train commuters, we are just steps north of Union Station.

show more>>

In our Training Center every student gets their own powerful Dell workstation with dual monitors. Our classrooms are designed around comfortable ergonomic chairs, generous work surfaces, special air conditioning by classroom and a high-speed fibre connection to the Internet. So it really is a great place to take any of our courses.

Our Training Center

However, we understand that it is not always possible for you to take this Instructor-Led Training: Live Online course at our Center. Therefore, you have the option to take part or all of this course from an offsite location. As long as you have at least DSL-speed Internet connectivity, our Operations Staff can easily connect and join you into this Instructor-Led Training: Live Online class directly from your work, home or other location. Our Site, Your Site or Offsite. Whatever works best for you!

Microsoft Gold Certified Partner Home  |  Consulting  |  Training  |  Company
© 2012 ObjectSharp Corp.416-649-3690