Fully Customizable Courseware For Trainers
Microsoft XP Access 2002: Intermediate
DOWNLOAD A FREE SAMPLE
Are you ready to learn additional skills in our Microsoft XP Access 2002 Intermediate training courseware?
If you understand the program foundations, it makes sense to learn more skills. It will improve your efficiency.
Are you an instructor?Are you sure that your students to improve their skills? Instructors all over the world have been using our pre-written, customizable, training materials and courseware since 1998.
There is a lot to learn. Here are just a few of the topics and lessons covered in this courseware:
- Linking vs. Importing
- Splitting an Access Database
- Working with the Import Spreadsheet Wizard
- Working with the Link Exchange/Outlook Wizard
- Exporting to a File
- Understanding the Clipboard
- Defining Normalization
- How do Key Fields and Table Relationships Help
- Working with the Relationships Window
- Using Wildcards with Parameter Queries
- Protecting Forms by Controlling Edits, Deletions, and Additions
- Understanding Event Procedures
- Understanding Command Buttons
- Using the Format Painter
- Creating the Detail Section
And many more topics!
Our courseware training material is completely customizable so the instructor can add whatever content they deem necessary (or take away whatever is not).
SECTION 1: Importing Data
Lesson 1.1: Linking to External Data Sources
Understanding Linked Data
Linking vs. Importing
Lesson 1.2: Understanding the Database Splitter
Splitting an Access Database
Working with Split Tables
Lesson 1.3: Importing an Excel Spreadsheet
Working with the Import Spreadsheet Wizard
Previewing the Imported Table
Lesson 1.4: Importing an Access Database
Working with the Import Objects Wizard
Understanding Import Options
Lesson 1.5: Linking an Outlook Contact List
Working with the Link Exchange/Outlook Wizard
Practice Exercise
Section 1: Review Questions
SECTION 2: Exporting Access 2002 Data
Lesson 2.1: Exporting Access 2002 Data
Exporting vs. Importing
Exporting to a File
Lesson 2.2: Exporting to an Access Database
Exporting vs. Importing
Preparing the Data
Lesson 2.3: When to Use Cut and Paste
Understanding the Clipboard
Practice Exercise
Section 2: Review Questions
SECTION 3: More About Queries
Lesson 3.1: Understanding Primary Key Fields and Table Relations
Defining Normalization
How do Key Fields and Table Relationships Help
Working with the Relationships Window
Lesson 3.2: Creating Action Queries
Types of Action Queries
Make-Table Query
Update Query
Append Query
Delete Query
Lesson 3.3: Designing Parameter Queries
Using Wildcards with Parameter Queries
Using Calculations in Queries
Designing Concatenated Fields
Using Multiple Tables in Queries
Practice Exercise
Section 3: Review Questions
SECTION 4: More on Designing Forms
Lesson 4.1: Fine-tuning Data Entry Forms
Limiting User Access
Protecting Forms by Controlling Edits, Deletions, and Additions
Lesson 4.2: Working with Subforms
Displaying a Subform within a Form
Synchronizing Forms and Subforms
Entering Data in a Subform
Creating Check Boxes
Understanding Event Procedures
Understanding Command Buttons
Practice Exercise
Section 4: Review Questions
SECTION 5: More on Designing Reports
Lesson 5.1: Fine Tuning Reports
Working with Properties
Using the Format Painter
Lesson 5.2: Working with Report Sections
Creating a Report Header using Labels
Creating a Page Header
Grouping and Sorting
Creating the Detail Section
Creating a Page Footer
Creating a Report Footer
Practice Exercise
Section 5: Review Questions
Are you ready to learn additional skills in our Microsoft XP Access 2002 Intermediate training courseware?
If you understand the program foundations, it makes sense to learn more skills. It will improve your efficiency.
Are you an instructor?Are you sure that your students to improve their skills? Instructors all over the world have been using our pre-written, customizable, training materials and courseware since 1998.
There is a lot to learn. Here are just a few of the topics and lessons covered in this courseware:
- Linking vs. Importing
- Splitting an Access Database
- Working with the Import Spreadsheet Wizard
- Working with the Link Exchange/Outlook Wizard
- Exporting to a File
- Understanding the Clipboard
- Defining Normalization
- How do Key Fields and Table Relationships Help
- Working with the Relationships Window
- Using Wildcards with Parameter Queries
- Protecting Forms by Controlling Edits, Deletions, and Additions
- Understanding Event Procedures
- Understanding Command Buttons
- Using the Format Painter
- Creating the Detail Section
And many more topics!
Our courseware training material is completely customizable so the instructor can add whatever content they deem necessary (or take away whatever is not).
SECTION 1: Importing Data
Lesson 1.1: Linking to External Data Sources
Understanding Linked Data
Linking vs. Importing
Lesson 1.2: Understanding the Database Splitter
Splitting an Access Database
Working with Split Tables
Lesson 1.3: Importing an Excel Spreadsheet
Working with the Import Spreadsheet Wizard
Previewing the Imported Table
Lesson 1.4: Importing an Access Database
Working with the Import Objects Wizard
Understanding Import Options
Lesson 1.5: Linking an Outlook Contact List
Working with the Link Exchange/Outlook Wizard
Practice Exercise
Section 1: Review Questions
SECTION 2: Exporting Access 2002 Data
Lesson 2.1: Exporting Access 2002 Data
Exporting vs. Importing
Exporting to a File
Lesson 2.2: Exporting to an Access Database
Exporting vs. Importing
Preparing the Data
Lesson 2.3: When to Use Cut and Paste
Understanding the Clipboard
Practice Exercise
Section 2: Review Questions
SECTION 3: More About Queries
Lesson 3.1: Understanding Primary Key Fields and Table Relations
Defining Normalizatio
How do Key Fields and Table Relationships Help
Working with the Relationships Window
Lesson 3.2: Creating Action Queries
Types of Action Queries
Make-Table Query
Update Query
Append Query
Delete Query
Lesson 3.3: Designing Parameter Queries
Using Wildcards with Parameter Queries
Using Calculations in Queries
Designing Concatenated Fields
Using Multiple Tables in Queries
Practice Exercise
Section 3: Review Questions
SECTION 4: More on Designing Forms
Lesson 4.1: Fine-tuning Data Entry Forms
Limiting User Access
Protecting Forms by Controlling Edits, Deletions, and Additions
Lesson 4.2: Working with Subforms
Displaying a Subform within a Form
Synchronizing Forms and Subforms
Entering Data in a Subform
Creating Check Boxes
Understanding Event Procedures
Understanding Command Buttons
Practice Exercise
Section 4: Review Questions
SECTION 5: More on Designing Reports
Lesson 5.1: Fine Tuning Reports
Working with Properties
Using the Format Painter
Lesson 5.2: Working with Report Sections
Creating a Report Header using Labels
Creating a Page Header
Grouping and Sorting
Creating the Detail Sectio
Creating a Page Footer
Creating a Report Footer
Practice Exercise
Section 5: Review Questions
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.
