Velsoft Training Materials
Search
Client Login

Fully Customizable Courseware For Trainers

Microsoft Office Access 2010: Advanced

DOWNLOAD A FREE SAMPLE

FREE SAMPLE

Easily edit and rebrand as your own

$495.00

If your students understand the basics and intermediate concepts of Access 2010, Microsoft Office Access 2010: Advanced training is prepared to teach them how to fully master the program’s functions and concepts. An advanced knowledge of Access 2010 enables users to take even more control of their data and improve their workplace performance, as well as how to handle errors and crashes so that data is less likely to be lost.

Velsoft’s Microsoft Office Access 2010: Advanced courseware and training materials teach students advanced data management. Students begin their advanced Access 2010 training by looking at table relationships, introductory SQL, modal dialog boxes, and advanced form tasks. Then, students learn about pivoting data and using PivotTables, how to recover, back up, and repair Access 2010, and move on to learning how to configure multi-user databases, create Web databases using Access Services, create and use macros, and how to use VBA’s features.

Microsoft Office Access 2010: Advanced training material is fully customizable so trainers can include, or remove, whatever content they require. The manual for Access 2010 includes step-by-step instructions and visuals, making Access even easier to navigate and teach. Velsoft’s training is also available through eLearning, a blended learning solution that makes teaching and learning computer skills even more accessible and rewarding.

Introduction

Prerequisites

Section 1: Advanced Data Management

Lesson 1.1: Referential Integrity

Using Relationship View

Using the Relationship Tools - Design Tab

Types of Relationships

Establishing Referential Integrity

Enforcing Referential Integrity

Testing Referential Integrity

Step-By-Step

Skill Sharpener

Lesson 1.2: Table Relationships

About Join Lines

Normalizing Tables

Using the Table Analyzer Wizard

Using Cascade Delete and Cascade Update

Setting Fields for Indexing

Using the Index

Step-By-Step

Skill Sharpener

Lesson 1.3: An Introduction to SQL

What is SQL?

Parts of an SQL Statement

SQL Keywords

Creating SQL Queries

Adding WHERE Clauses

Step-By-Step

Skill Sharpener

Lesson 1.4: Modal Dialog Boxes

Creating a Modal Dialog Box

Adding Controls

Setting Properties

Formatting your Dialog Box

Step-By-Step

Skill Sharpener

Section 1: Case Study

Section 1: Review Questions

Section 2: Advanced Form Tasks

Lesson 2.1: Using Subforms

Creating a Subform

Creating a Form and a Subform

Modifying a Subform

Working with a Subform

Synchronizing Subform Data with a Parent Form

Displaying a Subform within a Main Form

Step-By-Step

Skill Sharpener

Lesson 2.2: Creating a Navigation Form

Creating a Navigation Form

Adding Tabs to a Navigation Form

Creating a Tab Hierarchy

Modifying a Navigation Form

Displaying the Navigation Form when the Database Opens

Step-By-Step

Skill Sharpener

Lesson 2.3: Advanced Form Controls

Limiting User Access to a Form

Creating Check Boxes and Command Buttons

Building Command Button Events

Creating Event Procedures

Step-By-Step

Skill Sharpener

Lesson 2.4: Exporting a Form

Exporting Your Form to XML

Exporting a Form as a Word Document

Exporting a Form as HTML

Sending a Form as an E-mail Attachment

Exporting a Form to Other Formats

Step-By-Step

Skill Sharpener

Lesson 2.5: Other Form Tasks

Using Hyperlinks in a Form

Adding Links to Other Database Objects

Inserting a Mailto Link in a Form

Adding a Browser Control to a Form

Performing Calculations in a Form

Step-By-Step

Skill Sharpener

Section 2: Case Study

Section 2: Review Questions

Section 3: Pivoting Data

Lesson 3.1: Creating a PivotTable

About PivotTables

Creating a PivotTable

Adding Fields to PivotTables

Basic PivotTable Tasks

Step-By-Step

Skill Sharpener

Lesson 3.2: Using PivotTables

Pivoting Data

Refreshing PivotTable Data

Hiding and Showing PivotTable Data

Grouping PivotTable Data

Step-By-Step

Skill Sharpener

Lesson 3.3: Advanced PivotTable Tasks

Using the Properties Dialog

Exporting a PivotTable to Excel

Importing Excel Data

Creating a PivotTable with Excel Data

Step-By-Step

Skill Sharpener

Lesson 3.4: Creating a PivotChart

About PivotCharts

Creating a PivotChart

More about PivotChart Fields

Completing your PivotChart

Step-By-Step

Skill Sharpener

Lesson 3.5: Using PivotCharts

Modifying a PivotChart

Creating a PivotTable and PivotChart from the Same Object

Adding Axis Titles and a Legend

Changing the Chart Type

Step-By-Step

Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Section 4: Advanced Topics

Lesson 4.1: Access and Windows

Recovering Access

Backing Up an Access Database

Restoring a Database from a Backup Copy

Starting Access on Windows Boot

Repairing Access 2010

Step-By-Step

Skill Sharpener

Lesson 4.2: Splitting Your Database

Why Split your Database?

Splitting the Database

Configuring Access 2010 for a Multi-User Database

Setting Record Locking Options

Step-By-Step

Skill Sharpener

Lesson 4.3: Using Outlook with Access

Importing Contacts from Outlook

Linking to an Outlook Folder

Collecting Data with an E-mail Form

Managing Replies

Step-By-Step

Skill Sharpener

Lesson 4.4: Using Access 2010 with SharePoint Server

Understanding SharePoint Server

System Requirements

Important Terminology

Linking Tables and Lists

Moving a Database to SharePoint

Saving a Database to SharePoint

Step-By-Step

Skill Sharpener

Lesson 4.5: Access and Web Databases

Creating a Web Database

Using Web Database Templates

Checking Compatibility

Publishing a Web Database

Step-By-Step

Skill Sharpener

Section 4: Case Study

Section 4: Review Questions

Section 5: Macros and Visual Basic for Applications (VBA)

Lesson 5.1: Macro Basics

Creating Macros

Macros as Event Procedures

Program Control with If-Then-Else Statements

Using Macros in Tables

Step-By-Step

Skill Sharpener

Lesson 5.2: More about Macros

Embedded Macros

Adding Comments to Macros

Creating a Submacro

Grouping Submacros

Handling Macro Errors

Step-By-Step

Skill Sharpener

Lesson 5.3: Access and VBA

Converting a Macro to VBA

Using the VBA Editor

Building VBA Procedures

Declaring Variables

Gathering Information with DLookup

Adding Comments to VBA Code

Step-By-Step

Skill Sharpener

Lesson 5.4: Building Advanced Procedures

Using Message Boxes

Using Input Boxes

Using the DoCmd Object

Handling VBA Errors

Step-By-Step

Skill Sharpener

Lesson 5.5: Using VBA in a Database

Using VBA and Combo Boxes

Handling Run-Time Errors Using Error Numbers

Enabling and Disabling Form Controls

Preparing a Form for a New Record

Step-By-Step

Skill Sharpener

Section 5: Case Study

Section 5: Review Questions

Index

Everything you need to deliver amazing training

Each courseware title is a trainers' kit that comes with the following course components:

Instructor Guide

Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.

Student Manual

Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable Student Manual gives each participant the ?student? version of the course you will be teaching.

Exercise Workbook

Velsoft offers an Exercise Workbook (also customizable) that is specific to the course you are offering. You can choose whether this is something you would like to present to your students.

Sample Files

Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.

PowerPoint Deck

Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.

Quick Reference Guide

Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.

Fully Customizable

Make any changes you like including easily taking our branding off and replacing it with yours.

Unlimited Users

Train as many participants at your location as you like - forever!

Unlimited Printing Rights

Print-on-demand only what you need for as many participants with no limits.

No Annual Renewal Fees

One-off pricing. Never pay again to use the materials.

Velsoft is an educational technologies company focusing on content, platforms and custom development.

Explore Velsoft
Contact Us

Fully customizable courseware

Twitter Linkedin Instagram Facebook-f

Company

Content

Platforms

Resources

© 2024, Velsoft Training Materials, Inc. All rights reserved.

The Top 12 courses are:

Choose from 81 courses available in Articulate Storyline (.story) format.

  • Social Selling for Small Businesses
  • 10 Minute Presentation
  • Successfully Managing Change
  • Performance Management: Managing Employee Performance
  • Building Better Teams
  • Anger Management: Understanding Anger
  • Conflict Resolution: Getting Along in the Workplace
  • Hiring for Success: Behavioral Interviewing Techniques
  • Creating a Top Notch Talent Management Program
  • Conducting Effective Performance Reviews
  • Stress Management
  • Managing Customer Service
  • Closing the Generation Gap in the Workplace
  • Accounting Skills for the New Supervisor
  • Onboarding: The Essential Rules for a Successful Onboarding Program
  • Employee Recognition: Appreciating Your Workforce
  • Creativity In The Workplace
  • Diversity, Equity, and Inclusion
  • Unconscious Bias
  • Becoming Management Material
  • Coaching and Mentoring
  • Motivation Training: Motivating Your Workforce
  • The ABCs of Supervising Others
  • The Professional Supervisor
  • Delegation: The Art of Delegating Effectively
  • Team Building: Developing High Performance Teams
  • Meeting Management: The Art of Making Meetings Work
  • Leadership Skills for Supervisors
  • Managing Difficult Conversations
  • Giving Effective Feedback
  • Managing the Virtual Workplace
  • Managing Across Cultures
  • Women Leadership: Owning Your Strengths and Skills
  • Dealing With Difficult People
  • Vendor Management Essentials
  • How to Become a Leader with Integrity
  • Corrective Action
  • Project Management Principles and Performance Domains
  • Advanced Writing Skills
  • Public Speaking: Presentation Survival School
  • Emotional Intelligence
  • Communication Strategies
  • Critical Elements of Customer Service
  • Skills for the New Employee
  • Business Etiquette: Gaining that Extra Edge
  • Conquering Your Fear of Speaking in Public
  • Time Management
  • Business Writing That Works
  • Critical Thinking
  • Goal Setting
  • Personal Brand: Maximizing Personal Impact
  • Self Leadership
  • Managing Pressure and Maintaining Balance
  • Active Listening
  • Fostering Innovation
  • Delivering Dynamic Virtual Presentations
  • Entrepreneurship 101
  • Workplace Harassment: What It is and What to Do About It
  • Workplace Violence: How to Manage Anger and Violence in the Workplace
  • Lean Process Improvement
  • Employee Accountability
  • Disability Awareness: Working with People with Disabilities
  • Crisis Management
  • Strategic Planning
  • Continuous Improvement with Lean
  • Creating a Positive Work Environment
  • Developing a Safety Procedures Manual
  • Beyond Workplace Politics
  • Digital Transformation
  • GDPR Readiness: Creating a Data Privacy Plan
  • Cybersecurity Fundamentals
  • Respect In The Workplace
  • Advanced Skills for the Practical Trainer
  • Facilitation Skills
  • Survival Skills for the New Trainer
  • Using Activities to Make Training Fun
  • Developing a Training Needs Analysis
  • Measuring Training Results
  • Risk Management
  • Safety in the Workplace

Download a Free Sample

Your privacy is important to us. For more information, take a look at our Privacy Policy.