Velsoft Training Materials
Search
Client Login

Fully Customizable Courseware For Trainers

Microsoft Office Access 2010: Intermediate

DOWNLOAD A FREE SAMPLE

FREE SAMPLE

Easily edit and rebrand as your own

$495.00

We have created?Microsoft Office Access 2010: Intermediate customizable courseware and training material to properly inform business professionals exactly how to use and take advantage of the features of Office Access 2010. ?Databases, formatting, commands; all familiar terms, right? Well, maybe, but does your personnel know how to correctly use Office Access 2010? The information and statistics of your organization must be handled with precision, to ensure an accurate perception of your activities. Creating reports using Office Access 2010 is a proven way to organize and reorganize your business.

The most important features of Office Access 2010 are fully explained and exemplified in our training materials through various methods. They have been designed to engage students so effectively, that their learning experience directly and positively impacts their workplace performance.

Our training materials forMicrosoft Office Access 2010: Intermediate provide instructors and students with resourceful “how-to pictures”. The visual aid of “screen shots” included in our training materials demonstrate to users exactly where and how to access these options. The “screen shots” act as a personal trainer, showing users the correct way to perform the functions of the program.

Introduction

Prerequisites

Section 1: Advanced File Tasks

Lesson 1.1: Using Windows Explorer within Access

Navigating with Windows Explorer

Performing Basic Tasks with Windows Explorer

Changing Views in Windows Explorer

Using the Navigation Pane

Step-By-Step

Skill Sharpener

Lesson 1.2: Database Management

Compact and Repair a Database

Backing Up your Database

Editing Database Properties

Adding or Removing Database Passwords

Step-By-Step

Skill Sharpener

Lesson 1.3: Saving Your Files

Using the Save As Dialog

An Overview of Additional Database Formats

Packaging a Database

About AutoRecover

Step-By-Step

Skill Sharpener

Lesson 1.4: Exporting Files

Exporting to PDF or XPS

Exporting to Microsoft Office Word and Excel

Exporting to Other Destinations

Using Saved Exports

Packaging and Signing Data

Exporting to Older Versions of Access

Step-By-Step

Skill Sharpener

Lesson 1.5: Linking Files

Linking to a Microsoft Excel Spreadsheet

Linking to Another Database

Linking to a SharePoint Site

Other Types of Linked Documents

Creating Hyperlinks

Step-By-Step

Skill Sharpener

Section 1: Case Study

Section 1: Review Questions

Section 2: Working with Tables

Lesson 2.1: Customizing Tables

Understanding Field Properties

Adding a Primary Key

Indexing a Field.

Inserting, Deleting, and Moving Fields

Adding Quick Start Elements

Importing a Table from another Source

Step-By-Step

Skill Sharpener

Lesson 2.2: Formatting Tables.

Formatting Number Fields

Formatting Text Fields

Adding Field Descriptions

Changing Field Data Types

Adding Captions

Step-By-Step

Skill Sharpener

Lesson 2.3: Controlling Table Data Entry

Setting a Default Value

Setting a Required Value

Creating and Using Input Masks

Creating and Removing Table Relationships

Step-By-Step

Skill Sharpener

Lesson 2.4: Managing Table Data Entry

Using the Table Tools - Design Tab

Validating Data

Creating a Lookup Field

Modifying a Lookup Field

Creating a Value List

Modifying a Value List

Step-By-Step

Skill Sharpener

Section 2: Case Study

Section 2: Review Questions

Section 3: Working with Forms

Lesson 3.1: Basic Form Controls

Types of Forms

Types of Form Controls

Adding a Control

Using the Control Wizard

Cutting, Copying, Pasting, and Moving a Control

Formatting a Control

Step-By-Step

Skill Sharpener

Lesson 3.2: Advanced Form Controls

Modifying a Control's Properties

Changing a Control's Data Source

Changing a Control's Default Value

Creating a Calculated Control

Using Form Properties

Step-By-Step

Skill Sharpener

Lesson 3.3: Formatting Your Form

Formatting Gridlines

Modifying the Font

Adding Logos

Changing the Layout

Step-By-Step.

Skill Sharpener

Lesson 3.4: Formatting Controls

Changing the Color of a Control

Using Control Properties

Aligning and Sizing Controls

Applying Special Effects

Step-By-Step

Skill Sharpener

Lesson 3.5: Using Themes

Using Themes

Modifying Fonts

Modifying Colors

Saving Customized Themes

Step-By-Step

Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Section 4: Working with Reports

Lesson 4.1: Organizing Report Data

Adding and Removing Fields

Using Report Sections

Changing Section Properties

Grouping and Sorting in a Report

Doing More with Grouping and Sorting

Using Calculated Controls in a Report

Step-By-Step

Skill Sharpener

Lesson 4.2: Formatting Reports

Formatting Gridlines

Modifying the Font

Adding Logos

Changing the Layout

Using Themes

Step-By-Step

Skill Sharpener

Lesson 4.3: Common Report Tasks

Adding a Photo

Adjusting Page Properties

Adding Page Numbers

Using the Label Wizard

Adding Conditional Formatting

Step-By-Step

Skill Sharpener

Section 4: Case Study

Section 4: Review Questions

Section 5: Working with Queries

Lesson 5.1: Basic Queries

Review of Queries

Creating a Query

Sorting a Query

Filtering a Query

Showing and Hiding Fields

Step-By-Step.

Skill Sharpener

Lesson 5.2: Doing More with Queries

Using AND/OR Operators

About IIF Functions

Creating Multiple Table Queries

Creating a Calculated Field

About the Expression Builder

Using Queries to Summarize Data

Step-By-Step

Skill Sharpener

Lesson 5.3: Creating Advanced Queries

Creating a Parameter Query

Using Parameter Queries

Creating Crosstab Queries

Using Crosstab Queries

Using Make-Table Queries

Step-By-Step

Skill Sharpener

Lesson 5.4: Creating Management (Action) Queries

Append Queries

Delete Queries

Update Queries

Exporting Queries

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.