Fully Customizable Courseware For Trainers
Microsoft Office Access 2007: Basic
DOWNLOAD A FREE SAMPLE
With Microsoft Office Access 2007: Basic training courseware we walk you through the concepts and possibilities that Microsoft Office Access 2007 has to offer. With our courseware and training material you’ll be able to instruct others like a pro.
Access allows you to store, sort and search data within a database. With our Microsoft Office Access 2007: Basic training material we will teach how to exploit the additional features of Office Access 2007 has to offer; like, an all new interface, drag-and-drop functionality and modern styling.
With our guidance – and your know-how – you’ll be able to successfully teach the program. We help you prepare a unique, flexible, easy-to-use approach to educating your students, and with a fully customizable format we even let you take the credit!
Just have a look at what you’ll get:
- Exercise Files
- Instructor Guide
- Student Manual
- Exercise Workbook
- Lesson Plan
- PowerPoint Slides
- Quick Reference Guide
You know we’ve done all the work for you, so why spend countless hours doing it yourself?
Our training material has been industry tested and proven! We know that you can teach it, and now we want to give you the confidence to do it.
Section 1: Getting Started
Lesson 1.1: Starting Out
What is Microsoft Access?
What's New in Access 2007?
Basic Terminology
Opening Microsoft Access
Interface Overview
Closing Microsoft Access
Step-By-Step
Skill Sharpener
Lesson 1.2: Using the Getting Started Window.
Overview of the Window
Navigating Through the Window
Creating a Database from a Template
Creating a Blank Database
Step-By-Step
Skill Sharpener
Lesson 1.3: The Trust Center
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 Screen
Overview of the Help Screen
Online Help 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: Using the Quick Access Toolbar
About the Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
Step-By-Step
Skill Sharpener
Lesson 2.2: Basics of Tabs
About Tabs
Opening Dialog Boxes from the Ribbon
About the Office Menu
Step-By-Step
Skill Sharpener
Lesson 2.3: The Home Tab
Views
Clipboard
Font
Rich Text
Records
Sort and Filter
Find
Step-By-Step
Skill Sharpener
Lesson 2.4: Create Tab
Tables
Forms
Reports
Other
Step-By-Step
Skill Sharpener
Lesson 2.5: External Data Tab
Import
Export
Collect Data
SharePoint Lists
Step-By-Step
Skill Sharpener
Lesson 2.6: Database Tools Tab
Macro
Show/Hide
Analyze
Move Data
Database Tools
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 Database from a Template
Creating a Blank Database
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
E-Mailing Records
Printing Records
Step-By-Step
Skill Sharpener
Lesson 3.3: Creating a Table
About Tables
Creating a Table
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 Forms
What is a Form?
Bound vs. Unbound Controls
Creating a Form with the Wizard
Using Design View to Modify Your Form
Using Forms
Step-By-Step
Skill Sharpener
Lesson 4.2: Creating Queries
What is a Query?
Creating a Query with the Wizard
Using Design View to Modify a Query
Using Queries
Step-By-Step
Skill Sharpener
Lesson 4.3: Reports
What is a Report?
Creating a Report with the Wizard
Using Design View to Modify a Report
Using Reports
Step-By-Step
Skill Sharpener
Lesson 4.4: Sorting and Filtering Data
Using Find and Replace
Sort 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 Tabs
Closing Individual Tabs
Step-By-Step
Skill Sharpener
Lesson 4.6: Printing a Database Object
Using the Print Menu
Using Print Preview
Using the Print Preview Tab
Printing vs. Exporting
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: Review Questions
Index
With Microsoft Office Access 2007: Basic training courseware we walk you through the concepts and possibilities that Microsoft Office Access 2007 has to offer. With our courseware and training material you’ll be able to instruct others like a pro.
Access allows you to store, sort and search data within a database. With our Microsoft Office Access 2007: Basic training material we will teach how to exploit the additional features of Office Access 2007 has to offer; like, an all new interface, drag-and-drop functionality and modern styling.
With our guidance – and your know-how – you’ll be able to successfully teach the program. We help you prepare a unique, flexible, easy-to-use approach to educating your students, and with a fully customizable format we even let you take the credit!
Just have a look at what you’ll get:
- Exercise Files
- Instructor Guide
- Student Manual
- Exercise Workbook
- Lesson Plan
- PowerPoint Slides
- Quick Reference Guide
You know we’ve done all the work for you, so why spend countless hours doing it yourself?
Our training material has been industry tested and proven! We know that you can teach it, and now we want to give you the confidence to do it.
Section 1: Getting Started
Lesson 1.1: Starting Out
What is Microsoft Access?
What’s New in Access 2007?
Basic Terminology
Opening Microsoft Access
Interface Overview
Closing Microsoft Access
Step-By-Step
Skill Sharpener
Lesson 1.2: Using the Getting Started Window.
Overview of the Window
Navigating Through the Window
Creating a Database from a Template
Creating a Blank Database
Step-By-Step
Skill Sharpener
Lesson 1.3: The Trust Center
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 Screen
Overview of the Help Screen
Online Help 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: Using the Quick Access Toolbar
About the Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
Step-By-Step
Skill Sharpener
Lesson 2.2: Basics of Tabs
About Tabs
Opening Dialog Boxes from the Ribbon
About the Office Menu
Step-By-Step
Skill Sharpener
Lesson 2.3: The Home Tab
Views
Clipboard
Font
Rich Text
Records
Sort and Filter
Find
Step-By-Step
Skill Sharpener
Lesson 2.4: Create Tab
Tables
Forms
Reports
Other
Step-By-Step
Skill Sharpener
Lesson 2.5: External Data Tab
Import
Export
Collect Data
SharePoint Lists
Step-By-Step
Skill Sharpener
Lesson 2.6: Database Tools Tab
Macro
Show/Hide
Analyze
Move Data
Database Tools
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 Database from a Template
Creating a Blank Database
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
E-Mailing Records
Printing Records
Step-By-Step
Skill Sharpener
Lesson 3.3: Creating a Table
About Tables
Creating a Table
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 Forms
What is a Form?
Bound vs. Unbound Controls
Creating a Form with the Wizard
Using Design View to Modify Your Form
Using Forms
Step-By-Step
Skill Sharpener
Lesson 4.2: Creating Queries
What is a Query?
Creating a Query with the Wizard
Using Design View to Modify a Query
Using Queries
Step-By-Step
Skill Sharpener
Lesson 4.3: Reports
What is a Report?
Creating a Report with the Wizard
Using Design View to Modify a Report
Using Reports
Step-By-Step
Skill Sharpener
Lesson 4.4: Sorting and Filtering Data
Using Find and Replace
Sort 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 Tabs
Closing Individual Tabs
Step-By-Step
Skill Sharpener
Lesson 4.6: Printing a Database Object
Using the Print Menu
Using Print Preview
Using the Print Preview Tab
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 manual gives each participant the student version of the course you will be teaching.
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.
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.
