1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Access 2007: A Comprehensive Hands-On Introduction

 
Course: 970   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Utilize Microsoft Access 2007 to design robust database applications
  • Apply Form, Table, Report and Query wizards to quickly build database applications
  • Create and integrate macros into your applications
  • Quickly modify forms and reports with selective filtering, sorting and grouping
  • Implement advanced Access reporting features
  • Link to SharePoint and SQL Server data systems

Course Benefits

Databases form the core of an organization's information infrastructure. Microsoft Access 2007 is a powerful visual tool with which to design and develop database applications. This hands-on course provides experience with the features and functionality of Access 2007. You learn to develop and support robust Access systems, manipulate and query data, develop forms, design sophisticated data analysis reports, and upsize Excel spreadsheets.

Who Should Attend

Anyone who needs to manipulate, analyze or report on organizational data. Familiarity with databases or macros is helpful.

Hands-On Training

Throughout this course, you gain real-world experience building components of a database inventory system. Extensive hands-on exercises include:
  • Building a Microsoft Access database
  • Establishing indexes and data relationships
  • Implementing Form and Query wizards
  • Automating tasks with macros
  • Creating preformatted and custom reports
  • Developing complex Access reports
  • Limiting Query recordset results
  • Handling the On-No-Data event in reports

Related Courses

 
Access is a trademark of Microsoft Corporation. 		 

Upcoming Dates

Feb 17 - 20, 2009
 Washington, DC (Reston, VA)
Mar 17 - 20, 2009
 Ottawa
Apr 14 - 17, 2009
 Washington, DC (Alexandria, VA)
Apr 21 - 24, 2009
 Toronto
Apr 28 - May 1, 2009
 Chicago (Schaumburg)
Jun 9 - 12, 2009
 New York
Jul 14 - 17, 2009
 Ottawa
Jul 14 - 17, 2009
 Washington, DC (Rockville, MD)
Aug 18 - 21, 2009
 Toronto

For complete schedule, please visit www.learningtree.com
 
http://www.learntree.com/courses/970pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Access 2007: A Comprehensive Hands-On Introduction

 
Course: 970   Type: Hands-On Training   Duration: 4 Days
 
 
Course 970 Content
 

Microsoft Access 2007 Overview

Discovering the interface

  • Browsing by category in Help
  • Quick data functions in reports
  • Exploring the results-based ribbon
  • Categorizing with command groups
  • Changing the view to discover contextual tabs
  • Hiding and revealing the Navigation Pane

Overview of database concepts

  • Databases and their contents
  • Flat file and relational databases
  • Conforming Access to RDBMS standards

The fundamentals of database design

  • Tables, records and fields
  • Implementing database normalization
  • Ordering schemes
  • Indexes
  • Setting compound primary keys

Building a Relational Database with Access

Defining the requirements

  • Eliciting user needs and wants
  • Consolidating a design into a system specification
  • Designing the data model

Creating an Access database system

  • Selecting the best Access design style
  • Access tables, fields, indexes
  • Assigning proper field types
  • Table relationships
  • Modifying field functionality with properties

Integrating internal and external data

  • Customizing forms with the Layout View
  • Embedding forms within other forms
  • Attaching or importing existing tables
  • Designing a friendly user interface
  • Protecting data using layered validation
  • Form controls and properties
  • Picking controls in Layout and Design Views

Querying Relational Data

Query types and elements

  • Defining queries
  • Choosing fields in the Design View
  • Select, Action and Parameter queries

Developing queries

  • Query wizards
  • Expressions in queries
  • Refining data output with sorting and filtering
  • Displaying data from multiple tables
  • Creating calculated fields

Access Reports for Data Analysis

Implementing Report wizards

  • Generating quick reports
  • Stacked and tabular report formats
  • Visually enhancing your presentation with conditional formatting
  • Exploiting formulas and expressions in reports
  • Sorting out groups and totals

Modifying the standard report formats

  • Hiding data detail in summary reports
  • Elements of effective custom reports
  • Adjusting report controls
  • Changing group order and effects
  • Formulating values in expressions
  • Publishing to PDF and XPS formats

Task Automation with Macros

Designing effective macros

  • Point-and-click
  • Embedded macros
  • Macro style guidelines
  • Running a macro from events
  • Picking macro actions and arguments

Event-driven programming

  • Linking forms and reports
  • Associating macros with controls to respond to user-triggered events
  • Managing security through the Trust Center
  • Designing a custom Navigation Pane

Access as a Multiuser Front-End

Data separation in Access

  • Creating a non-data ACCDB
  • Strategically placing your data
  • Handling multiuser conflicts

Linking to SharePoint or SQL Server

  • The ODBC connectivity standard
  • Utilizing SharePoint and SQL Server data within Access
 
http://www.learntree.com/courses/970pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Access 2007: A Comprehensive Hands-On Introduction Tuition

 
Course: 970   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 45%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,625 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learntree.com/courses/970pf.htm