KidsTerrain



Pre-recorded Webinars Available 24/7
On-site Seminars and Programs
Partners and Affiliates
KidsTerrain At Work KidsTerrain Online Store

Access 2007 Intermediate Level Seminar

Full Day: In this course you will learn how to maintain data consistency and integrity; improve queries, forms and reports; and also how share Access with other applications.  

 
Controlling Data Entry
•    Restrict Data Entry Using Field Properties
•    Establish a Pattern for Entering Field Values
•    Create a List of Values for a Field

Joining Tables
•    Create Query Joins
•    Join Unrelated Tables
•    Relate Data Within a Table

Creating Flexible Queries
•    Set Select Query Properties
•    Create Parameter Queries
•    Create Action Queries

Improving Forms
•    Design a Form Layout
•    Enhance the Appearance of a Form
•    Restrict Data Entry in Forms
•    Add a Command Button to a Form
•    Create a Subform

Customizing Reports
•    Organize Report Information
•    Format the Report
•    Set Report Control Properties
•    Control Report Pagination
•    Summarize Report Information
•    Add a Subreport to an Existing Report
•    Create a Mailing Label Report

Sharing Data Across Applications
•    Import Data into Access
•    Export Data
•    Analyze Access Data in Excel
•    Export Data to a Text File

Download this outline as a PDF

KidsTerrain
"Do one thing every day that scares you."
-Eleanor Roosevelt


Click Here

to preview our FREE informational program

Webinars --
A 21st Century
Business Tool

and discover how this
cost-effective technology can help
your business or organization. 

---------------

Interested in
On-Site Training?
About Our Trainers

---------------

Interested in
Internet-Based Webinar Programs?

Webinars are multi-media programs that enable you to view a presentation, lecture, or seminar from the comfort of your office or home. Available 24/7 via the Internet, webinars are an effective alternative to on-site presentations. 

Webinars in our library are just 15.00!

Achieve Your Goals

Bullying In The Workplace 

Finding Your Value: The Art Of Self-Promotion 

 

 
KidsTerrain Footer
Copyright © 2007 KidsTerrain, Inc. All rights reserved.