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 2010 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 2010 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

Safe Home Connections, a division of KidsTerrain, Inc. assists individuals with the option to age in place, that is, to live in one's home while having access to services and support as needs change. 

To learn more about Safe Home Connections services and support, visit our web site or Contact our Certified Aging-In Place Specialist for more information.

What Our Clients Are Saying...

[The trainer]had a great handle on the information . . . Good structure to the presentation… Excellent examples…very impressed by the instructor.  She brought a lot of insight into her presentation. I found this class very helpful and I am very glad that I came…well worth it. ~ City of Waltham (condensed)

We Are SDO Certified!

WorkTerrain, through its parent company KidsTerrain,  has received certification from the Commonwealth Supplier Diversity Office (SDO). 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 SDO...

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
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.