Fully Customizable Courseware For Trainers
Microsoft Office Access 2010: Basic
DOWNLOAD A FREE SAMPLE
Train Microsoft Access 2010 with confidence using our customizable Microsoft Office Access 2010: Basic courseware training material.
Microsoft Access 2010 includes many new features to help you organize your important company data. A very powerful tool to help your business save time. Handle your business confidently, link data with a primary key, one-to-many relationships, run a query to poll only the data you want then print it off in minutes.
Tired of hearing “how do you use this thing? “? Our customizable Microsoft Office Access 2010: Basic courseware will give you the ability to help anyone understand those functions or “how do you use this thing.”
You will have access to amazing customizable material, insert your name and logo, make it your own, and run with it! We write the course, you take the credit! Sit back and relax, we have you covered!
You will be the shining star with everything you would need to run a short or long-term training session:
- Instructor guides
- Student workbook
- Lesson plans
- Quick access guide
- PowerPoint presentations AND MORE!
Microsoft Office Access 2010: Basic customizable courseware training material covers: Interface basics, Quick Access Toolbar, Creating and maintain a database, reports, relationships and much more!
Whether you are training the fresh beginners, or the database mogul; you can train effortlessly and confidently to any range of experience with our foundation and intermediate courses.
Introduction
Prerequisites
Section 1: Getting Started
Lesson 1.1: Starting Out
What is Microsoft Access?
What's New in Access 2010?
Basic Database Terminology
Opening and Closing Access
Step-By-Step
Skill Sharpener
Lesson 1.2: Interface Basics
Understanding Backstage View (File Menu)
Interface Overview
Using the Standard Tabs
Using Contextual Tabs
Step-By-Step
Skill Sharpener
Lesson 1.3: Database Security
Warnings You May See when Opening a Database
Enabling Content
About Digital Signatures
About Trusted Locations
Opening the Trust Center
Assigning a Password to your Database
Step-By-Step
Skill Sharpener
Lesson 1.4: Getting Help
Opening the Help File
Overview of the Help File
Online vs. Offline Help
Searching for Help
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: The New Interface
Lesson 2.1: The Quick Access Toolbar
The Default QAT Commands
Adding Commands
Removing Commands
Customizing the Toolbar
Step-By-Step
Skill Sharpener
Lesson 2.2: Basics of Tabs
About Tabs
Opening Additional Dialog Boxes
Using the File (Backstage) Menu
Minimizing the Ribbon
Step-By-Step
Skill Sharpener
Lesson 2.3: The Home Tab
Views Commands
Clipboard Commands
Sort & Filter Commands
Records Commands
Find Commands
Text Formatting Commands
Step-By-Step
Skill Sharpener
Lesson 2.4: The Create Tab
Templates Commands
Tables Commands
Queries Commands
Forms Commands
Reports Commands
Macros & Code Commands
Step-By-Step
Skill Sharpener
Lesson 2.5: The External Data Tab
Import & Link Commands
Export Commands
Collect Data Commands
Step-By-Step
Skill Sharpener
Lesson 2.6: The Database Tools Tab
Tools Commands
Macro Commands
Relationships Commands
Analyze Commands
Move Data Commands
Add-Ins Commands
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Creating a Database
Lesson 3.1: First Steps
Planning a Database
Creating a Blank Database
Creating a Database from a Template
Using Database Objects
Setting Navigation Options
Step-By-Step
Skill Sharpener
Lesson 3.2: About Records
What is a Record?
Navigation Tips
Adding Records
Editing Records
Deleting Records
Printing Records
Step-By-Step
Skill Sharpener
Lesson 3.3: Creating a Table
About Tables
Creating a Table
Using Design View
Entering Data into a Table
Formatting a Table
Step-By-Step
Skill Sharpener
Lesson 3.4: Formatting Text
Using the Zoom Box
Selecting Data
Cutting, Copying, and Pasting
Using the Format Painter
Using Undo and Redo
Checking your Spelling
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 4: Doing More with your Database
Lesson 4.1: Creating and Using Forms
What is a Form?
Bound vs. Unbound Controls
Creating a Basic Form
Creating a Form with the Wizard
Using Design View to Modify your Form
About the Form Design Tools Contextual Tabs
Using Forms
Step-By-Step
Skill Sharpener
Lesson 4.2: Creating and Using Queries
What is a Query?
Creating a Query with the Wizard
Using Design View to Modify a Query
About the Query Design Tools Contextual Tab
Using Queries
Step-By-Step
Skill Sharpener
Lesson 4.3: Creating and Using Reports
What is a Report?
Creating a Report with the Wizard
Using Design View to Modify a Report
About the Report Design Tools Contextual Tabs
Using Reports
Step-By-Step
Skill Sharpener
Lesson 4.4: Sorting and Filtering Data
Using Find and Replace
Sorting Ascending or Descending
Toggling Filter
Using Selection Sort
Using Advanced Sort
Step-By-Step
Skill Sharpener
Lesson 4.5: Viewing Data
Using the View Menu
Using the View Icons
Using the Object Tabs
Closing Individual Object Tabs
Step-By-Step
Skill Sharpener
Lesson 4.6: Printing a Database Object
Print Commands
The Print Dialog Box
Using Print Preview
Printing vs. Exporting
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: 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.
