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


For complete schedule, please visit www.learningtree.com
 
http://www.learningtree.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.learningtree.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
$ 2,950 Standard Tuition
Tuition with a Savings Plan
$ 2,075 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,655 Alumni Gold Discount
$ 2,620 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,665 per course
  • Savings as much as 40%
  • Only $4,990
Flex Pass
  • 3 courses in 24 months
  • As little as $1,830 per course
  • Save as much as 35%
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,150
Training Vouchers
  • Save as much as $950 per course
  • Fully transferable
  • As low as $2,095 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 $295 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.learningtree.com/courses/307pf.htm