Fully Customizable Courseware For Trainers
Microsoft Access 2010: Part One
DOWNLOAD A FREE SAMPLE
Microsoft Access 2010: Part One will help you take your students take their Microsoft Access 2010 skills to the next level by preparing for the related Microsoft Office Specialist Exam (77-885). The?first half of this two-part series introduces students to many of the key topics, including getting started with Access, working with Access objects, organizing databases, customizing the Access interface, sharing data, and more.
When you purchase this Microsoft Access 2010: Part One course, you’ll receive the following customizable training components:
- Instructor guide with delivery tips
- Student manual
- Synchronized PowerPoint slides
- Sample exercise files for activities and lesson labs
- Lesson plan with timings
- Course outline, detailing each lesson and its contents
- Quick Reference Guide (great for post-training reference!)
That’s right – everything is customizable! That gives you the flexibility to design a custom training program every time you deliver a workshop. Or, just?buy and teach: it’s all up to you!
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1: Getting Started with Access
TOPIC A: Orientation to Microsoft Access
Microsoft Access 2010
Access Files
The Access 2010 Application Window
Tables
Forms
Queries
Reports
The Ribbon Interface
Activity 1-1
TOPIC B: Create a Simple Access Database
Database Templates
Using Database Objects
Setting Navigation Options
Save Options
Field Definition
Methods to Create a Form
Form Object Views
Form Sections
Activity 1-2
TOPIC C: Get Help in Microsoft Access
Access Help
Activity 1-3
Summary
Review Questions
Lesson 2: Working with Table Data
TOPIC A: Modify Table Data
AutoCorrect and Spell Check
Commit, Save, and Undo
Quick Search
The Find and Replace Dialog Box
Datasheet Totals
Activity 2-1
TOPIC B: Sort and Filter Records
The Sort Feature
The Filter Feature
Filter Commands
Activity 2-2
TOPIC C: Create Lookups
Lookup Fields
The Property Sheet Pane
Activity 2-3
TOPIC D: Format Text
Copying, Cutting, and Pasting
Using Paste Special
Using Font Tools
Using the Format Painter
Activity 2-4
Summary
Review Questions
Lesson 3: Querying a Database
TOPIC A: Join Data from Different Tables in a Query
Query Object Views
The Simple Query Wizard
Types of Queries
The Run Command
Query Design
Activity 3-1
TOPIC B: Sort and Filter Data in a Query
Query Criteria
Comparison Operators
Logical Operators
Sorting Query Results
Grouping Query Results
The Zoom Dialog Box
Activity 3-2
TOPIC C: Perform Calculations in a Query
Arithmetic Operators
Activity 3-3
Summary
Review Questions
Lesson 4: Creating Advanced Queries
TOPIC A: Create Parameter Queries
Parameter Queries
Wildcards and Parameter Queries
The Ampersand Operator
Activity 4-1
TOPIC B: Create Action Queries
Action Queries
Types of Action Queries
Activity 4-2
TOPIC C: Create Unmatched and Duplicate Queries
The Find Unmatched Query Wizard
The Find Duplicates Query Wizard
Activity 4-3
TOPIC D: Summarize Data
Crosstab Queries
PivotTables
PivotCharts
Activity 4-4
Summary
Review Questions
Lesson 5: Generating Reports
TOPIC A: Create Reports
Report Creation Tools
Report Object Views
The Report Wizard
Activity 5-1
TOPIC B: Add Controls to a Report
Report Sections
Control Properties
Activity 5-2
TOPIC C: Enhance the Appearance of a Report
Galleries
Themes
Activity 5-3
TOPIC D: Prepare a Report for Print
Page Setup Options
The Print Preview Tab
Activity 5-4
Summary
Review Questions
Lesson 6: Customizing the Access Environment
TOPIC A: The Access Options Dialog Box
Access Options
Activity 6-1
Summary
Review Questions
Lesson 7: Designing a Relational Database
TOPIC A: Relational Database Design
Relational Databases
The Relational Database Design Process
The Statement of Purpose
Existing Data
Guidelines for Determining Fields
Business Rules
Guidelines for Grouping Fields into Tables
Primary Keys
Foreign Keys
Composite Keys
Table Relationships
Activity 7-1
TOPIC B: Create a Table
Table Views
Data Types
Quick Start Fields
Calendar for Picking Dates
The Lookup Wizard
The Table Properties Dialog Box
Activity 7-2
TOPIC C: Manage Table Fields
Insert Fields
Rename Fields
Delete Fields
Hide and Unhide Fields
Freeze and Unfreeze Fields
Modify the Field Description
Activity 7-3
TOPIC D: Create Table Relationships
The Relationship View
Referential Integrity
Guidelines for Enforcing Referential Integrity
The Edit Relationships Dialog Box
Join Lines
Relationship Report
Activity 7-4
Summary
Review Questions
Lesson 8: Joining Tables
TOPIC A: Create Query Joins
Query Joins
Inner Joins
Outer Joins
The Join Properties Dialog Box
Activity 8-1
TOPIC B: Join Tables That Have No Common Fields
Joining Tables with No Common Fields
Activity 8-2
TOPIC C: Relate Data within a Table
Self-Joins
The Alias Property
Activity 8-3
TOPIC D: Work with Subdatasheets
Subdatasheets
Activity 8-4
TOPIC E: Create Subqueries
Subqueries
Activity 8-5
Summary
Review Questions
Lesson 9: Organizing a Database for Efficiency
TOPIC A: Data Normalization
First Normal Form
Second Normal Form
Third Normal Form
Denormalization
The Table Analyzer Wizard
Activity 9-1
TOPIC B: Create a Junction Table
Many-to-Many Relationships
Junction Tables
Activity 9-2
Summary
Review Questions
Lesson 10: Sharing Data Across Applications
TOPIC A: Import Data into Access
Data Importing
The Get External Data Wizard
Delimiters
Activity 10-1
TOPIC B: Export Data to Text File Formats
Data Exporting
Activity 10-2
TOPIC C: Export Access Data to Excel
Exporting Access Data to Excel
Activity 10-3
TOPIC D: Create a Mail Merge
The Microsoft Word Mail Merge Wizard
Merge Fields
The Mail Merge Task Pane
Activity 10-4
Summary
Review Questions
Lesson 11: Advanced Reporting
TOPIC A: Organize Report Information
Report Design Elements
Report Design Tools
Adding a Background Image to a Report
Activity 11-1
TOPIC B: Format Reports
The Rich Text Property
Report Format Tools
Report Control Properties
Report Pagination
Activity 11-2
TOPIC C: Include Charts in a Report
Data Bars
Charts
Activity 11-3
TOPIC D: Add a Calculated Field to a Report
Calculated Fields
Activity 11-4
TOPIC E: Add a Subreport to an Existing Report
Subreports
Activity 11-5
Summary
Review Questions
Lesson 12: Additional Reporting Options
TOPIC A: Create a Mailing Label Report
The Label Wizard
Activity 12-1
TOPIC B: Publish a Report as PDF
Publish a Report as PDF
Activity 12-2
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson 2
Lesson Lab 2-1
Lesson Lab 2-2
Lesson 3
Lesson Lab 3-1
Lesson 4
Lesson Lab 4-1
Lesson Lab 4-2
Lesson 5
Lesson Lab 5-1
Lesson Lab 5-2
Lesson 6
Lesson Lab 6-1
Lesson 7
Lesson Lab 7-1
Lesson Lab 7-2
Lesson 8
Lesson Lab 8-1
Lesson Lab 8-2
Lesson 9
Lesson Lab 9-1
Lesson 10
Lesson Lab 10-1
Lesson Lab 10-2
Lesson 11
Lesson Lab 11-1
Lesson Lab 11-2
Lesson 12
Lesson Lab 12-1
Course Wrap-Up
Post-Course Assessment
Course Summary
Next Steps
Appendices
Keyboard Shortcut Quick Reference Sheet
Mapping to Microsoft Office Access 2010, Exam 77-885
Glossary
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.
