UpcomingAccess 2010 Level 3

admin

Price Qty*
July 31, 2017 show details + $351.75 (CAD)  
August 16, 2017 show details + $351.75 (CAD)  
September 22, 2017 show details + $351.75 (CAD)  
October 30, 2017 show details + $351.75 (CAD)  
November 27, 2017 show details + $351.75 (CAD)  

  • July 31, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • August 16, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • September 22, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • October 30, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • November 27, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)

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

Course Overview: You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and performing database maintenance. This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Course Content

Section 1: Advanced Data Management
Lesson 1.1: Referential Integrity
Lesson 1.2: Table Relationships
Lesson 1.3: An Introduction to SQL
Lesson 1.4: Modal Dialog Boxes
Section 2: Advanced Form Tasks
Lesson 2.1: Using Subforms
Lesson 2.2: Creating a Navigation Form
Lesson 2.3: Advanced Form Controls
Lesson 2.4: Exporting a Form
Lesson 2.5: Other Form Tasks
Section 3: Pivoting Data
Lesson 3.1: Creating a PivotTable
Lesson 3.2: Using PivotTables
Lesson 3.3: Advanced PivotTable Tasks
Lesson 3.4: Creating a Pivot Chart
Lesson 3.5: Using PivotCharts
Section 4: Advanced Topics
Lesson 4.1: Access and Windows
Lesson 4.2: Splitting Your Database
Lesson 4.3: Using Outlook with Access
Lesson 4.4: Using Access 2010 with SharePoint Server
Lesson 4.5: Access and Web Databases
Section 5: Macros and Visual Basic for Applications (VBA)
Lesson 5.1: Macro Basics
Lesson 5.2: More about Macros
Lesson 5.3: Access and VBA
Lesson 5.4: Building Advanced Procedures
Lesson 5.5: Using VBA in a Database

adminUpcomingAccess 2010 Level 3