Access 2007 Level 2 (Advanced)

Course Length: 6hrs (1 Day)

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Course Outline:
Section 1: Advanced Data Management
Lesson 1.1: Referential Integrity
Lesson 1.2: Table Relationships
Lesson 1.3: Switchboards
Lesson 1.4: Modal Dialogue Boxes

Section 2: Advanced Form Tasks
Lesson 2.1: Using Subforms
Lesson 2.2: Advanced Form Tasks
Lesson 2.3: Exporting Your Form
Lesson 2.4: Using Outlook and SharePoint with Access

Section 3: Pivoting Data
Lesson 3.1: Creating a PivotTable
Lesson 3.2: Creating a PivotChart
Lesson 3.3: Using PivotTables and PivotCharts

Section 4: Access and Windows
Lesson 4.1: Access and Windows
Lesson 4.2: Using the Access Viewer
Lesson 4.3: An Introduction to SQL

Section 5: Using Scripts in Access
Lesson 5.1: Macro Basics
Lesson 5.2: Other Macro Tasks
Lesson 5.3: Visual Basic and Macros
Lesson 5.4: Macro Groups