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

Access 2003: A Comprehensive Hands-On Introduction

Building a Foundation for Client/Server Database Applications
 
Course: 307   Type: Hands-On Training   Duration: 5 Days
 
 

You Will Learn How To

  • Design robust relational database applications using Microsoft Access 2003
  • Develop client/server database front-ends
  • Build database applications quickly using Form, Table, Report and Query wizards
  • Link to ODBC and OLE-DB data sources to leverage enterprise security
  • Create and integrate macros into your applications
  • Implement advanced Access reporting features

Course Benefits

Microsoft Access is a powerful tool with which to design and develop Windows-based database applications. This course explains key database design concepts and functionality. You learn to build an Access database system in class and develop a front-end that queries a SQL Server database over a Windows network.

Who Should Attend

Anyone who plans to prototype, build and integrate database applications using Microsoft Access 2003 or a prior version of Access. Familiarity with Windows is assumed; some knowledge of databases or macros is helpful.

Hands-On Training

During the course, you perform extensive exercises that provide in-depth hands-on experience with Microsoft Access. Exercises include:
  • Building a Microsoft Access database
  • Linking data among Access tables and with other programs
  • Using Form and Query wizards
  • Linking to and querying a SQL Server database
  • Programming with macros and VBA
  • Handling Windows events
  • Creating preformatted and custom reports
  • Developing advanced Access reports

Related Courses

 
Access is a trademark of Microsoft Corporation. 		 

Upcoming Dates

Feb 2 - 6, 2009
 Los Angeles
Feb 9 - 13, 2009
 Washington, DC (Reston, VA)
Feb 23 - 27, 2009
 Dallas
Feb 23 - 27, 2009
 Washington, DC (Rockville, MD)
Mar 2 - 6, 2009
 New York
Jun 1 - 5, 2009
 New York
Jun 15 - 19, 2009
 Atlanta
Jun 22 - 26, 2009
 Washington, DC (Rockville, MD)
Jul 6 - 10, 2009
 Dallas
Jul 27 - 31, 2009
 Los Angeles
Aug 24 - 28, 2009
 New York

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

Access 2003: A Comprehensive Hands-On Introduction

Building a Foundation for Client/Server Database Applications
 
Course: 307   Type: Hands-On Training   Duration: 5 Days
 
 
Course 307 Content
 

Introduction to Access

Overview of database concepts

  • Databases and their contents
  • Flat file and relational databases

The fundamentals of database design

  • Tables, records and fields
  • Ordering schemes
  • Indexes and keys

Introduction to the Access product

  • The visual development environment
  • When to use Access

Creating a Relational Database Management System with Access

Defining the requirements

  • Eliciting user needs and wants
  • Designing the data model

Building an Access database system

  • Access tables, fields, indexes
  • Table relationships
  • Table wizards

Adding the data

  • Working with the datasheet view
  • Attaching or importing existing tables
  • Designing a friendly user interface
  • Forms design
  • Form wizards
  • Controls and control properties

Querying the Database

Query types and elements

  • What is a Query?
  • Query by Example (QBE)
  • Query by Form (QBF)
  • Select queries
  • Crosstab queries
  • Action queries
  • Parameter queries

Managing queries

  • Query wizards
  • Expressions in queries

Access as a Client/Server Front-End

Attaching to a SQL Server database

  • The ODBC OLE-DB connectivity standards
  • Multiuser and security concerns

SQL queries across the network

  • Using Query wizards with SQL
  • Issuing commands to SQL databases using pass-through queries

Access Reports

Using Report wizards

  • Quick printouts with AutoReports
  • Tabular, groups/totals, mailing labels and other standard report types
  • Visually enhancing your presentation with wizards
  • Exploiting formulas and expressions in reports
  • Designing queries for effective report grouping

Modifying the standard report formats

  • Elements of effective custom reports
  • Adjusting report controls

Application Development with Macros and VBA

Designing effective macros

  • Point and click
  • Debugging tips
  • Macro style guidelines
  • Running a macro from events
  • Converting macros to VBA code

Event-driven programming

  • Writing event-driven programs
  • Associating macros with controls to respond to user-triggered events
  • Programming conditional macros to respond to user input

Automating your application with VBA

  • Correlating data types with Access table definitions
  • Controlling form values with variables

Advanced Access Techniques

Techniques for forms

  • Validating user data with field masks, field-level validation and advanced logic control
  • Populating list and combo boxes with queries
  • Hiding columns in list and combo boxes

Macro techniques

  • Grouping macros for organization
  • Creating keyboard shortcuts with AutoKeys
  • Converting Access macros to VBA code
 
http://www.learntree.com/courses/307pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Access 2003: A Comprehensive Hands-On Introduction Tuition

Building a Foundation for Client/Server Database Applications
 
Course: 307   Type: Hands-On Training   Duration: 5 Days
 
 

Course Tuition
$ 3,090 Standard Tuition
Tuition with a Savings Plan
$ 2,250 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,785 Alumni Gold Discount
$ 2,744 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/307pf.htm