Fully Customizable Courseware For Trainers
Microsoft Office Access 2010: Intermediate
DOWNLOAD A FREE SAMPLE
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.
