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
Level 2 (Advanced)

Register for this class

Switch version:
2010 2013 2016

This Course Comes With


PDF Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned

Customize Your Course

Tailored Training

Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Custom Manual

Purchase the customization option and receive a custom manual with objectives you’ve selected from our different courses

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Also Available With This Course

Printed Manual

Instead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference

Quick Reference Cards

Receive durable, full-color reference cards with helpful hints and tips for use after your course is completed

Video Library

Sign up to our video library subscription and review an extensive selection of training videos to refresh your memory
Register for this class here
Learn more about each course here
Contact us for more information here