UpcomingAccess 2010 Level 2

admin

Price Qty*
December 19, 2017 show details + $351.75 (CAD)  
January 24, 2018 show details + $351.75 (CAD)  
February 9, 2018 show details + $351.75 (CAD)  
March 14, 2018 show details + $351.75 (CAD)  
April 11, 2018 show details + $335.00 (CAD)  
May 2, 2018 show details + $351.75 (CAD)  
May 16, 2018 show details + $351.75 (CAD)  
June 20, 2018 show details + $351.75 (CAD)  

  • December 19, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • January 24, 2018
    8:30 am - 4:00 pm
  • February 9, 2018
    8:30 am - 4:00 pm
  • March 14, 2018
    8:30 am - 4:00 pm
  • April 11, 2018
    8:30 am - 4:00 pm
  • May 2, 2018
    8:30 am - 4:00 pm
  • May 16, 2018
    9:30 am - 4:00 pm
  • June 20, 2018
    8:30 am - 4:00 pm

Course Length: 1 day (8:30 a.m. – 4:00 p.m.)           Instructor Led Training

Course Overview:  You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2010 with other applications. Microsoft Office Access 2010: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2010. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2010 can also take this course.

Course Content

Section 1: Advanced File Tasks
Lesson 1.1: Using Windows Explorer within Access
Lesson 1.2: Database Management
Lesson 1.3: Saving Your Files
Lesson 1.4: Exporting Files
Section 2: Working with Tables
Lesson 2.1: Customizing Tables
Lesson 2.2: Formatting Tables
Lesson 2.3: Controlling Table Data Entry
Lesson 2.4: Managing Table Data Entry
Section 3: Working with Forms
Lesson 3.1: Basic Form Controls
Lesson 3.2: Advanced Form Controls
Lesson 3.3: Formatting Your Form
Lesson 3.4: Formatting Controls
Lesson 3.5: Using Themes
Section 4: Working with Reports
Lesson 4.1: Organizing Report Data
Lesson 4.2: Formatting Reports
Lesson 4.3: Common Report Tasks
Section 5: Working with Queries
Lesson 5.1: Basic Queries
Lesson 5.2: Doing More with Queries
Lesson 5.3: Creating Advanced Queries
Lesson 5.4: Creating Management (Action) Queries
adminUpcomingAccess 2010 Level 2