WorkTerrain
 Free Webinars, News & More   Subscribe Now 
Email:
Pre-recorded Webinars Available 24/7
On-site Seminars and Programs
WorkTerrain At Work WorkTerrain Online Store

Access 2007 Beginning Level

Full Day: In this course you will learn the basic operations of the Microsoft Access database application to perform your day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to your business processes. 

Exploring the Access 2007 Environment
•    Examine Database Concepts
•    Exploring the User Interface
•    Use an Existing Access Database
•    Customize the Access Environment
•    Obtain Help

Designing a Database
•    Describe the Relational Database Design Process
•    Define Database Purpose
•    Review Existing Data
•    Determine Fields
•    Group Fields into Tables
•    Normalize Data
•    Designate Primary and Foreign Keys
•    Determine Table Relationships

Building a Database
•    Create a New Database
•    Create a Table
•    Manage Tables
•    Create a Table Relationship
•    Watch and Evaluate Formulas
•    Save a Database as a Previous Version

Managing Data in a Table
•    Modify Table Data
•    Sort Records
•    Work with Subdatasheets

Querying a Database
•    Filter Records
•    Create a Query
•    Add Criteria to a Query
•    Add a Calculated Field to a Query
•    Perform Calculations on a Record Grouping

Designing Forms
•    View Data Using an Access Form
•    Create a Form
•    Modify the Design of a Form

Generating Reports
•    View an Access Report
•    Create a Report
•    Add a Custom Calculated Field to a Report
•    Format the Controls in a Report
•    Apply an AutoFormat Style to a Report
•    Prepare a Report for Print 

Download this outline as a PDF

We Are SOMWBA Certified

WorkTerrain, through its parent company KidsTerrain,  has received certification from the State Office of Minority and Women Business Assistance. This is a vitally important designation for companies, organizations, and agencies that want to establish business relationships with women-owned business vendors. Read more about SOMWBA...

Keep Up-To-Date On The Latest News From WorkTerrain

Submit your e-mail address (see the banner above) to receive notifications of free webinars, vital news, and more. At WorkTerrain we respect your privacy. Your e-mail address will not be shared and you may unsubscribe at any time.

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 

 

 
WorkTerrain Footer
Copyright © 2008 WorkTerrain All rights reserved.