Access 2010 Level 2 (Advanced)


 
Course Length: 6hrs (1 Day)
Access is a powerful database program that enables users to start with simple tables, forms and reports and build on these basic objects. The addition of macros and command buttons enhances the use and performance of forms and reports. Action queries and parameter queries make finding data that much easier.

Learning Objectives:
In this course, you will design more complex forms, reports, queries and macros. You will:
  • Create advanced forms; tabbed forms, split forms, modal forms
  • Add command buttons and advanced design elements such as form controls to forms
  • Create action queries
  • Create parameter queries
  • Create macros
  • Create and design more advanced reports using report controls
Target Student:
This course is for individuals who have experience with database programs and who wish to expand their use and knowledge of practical database applications.

Course Outline:
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 Task

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

Register for this class

Switch version:
2007 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