1-800-THE-TREE (1-800-843-8733)
 

Access™ 2003: A Comprehensive Hands-On Introduction

Building a Foundation for Client/Server Database Applications

 
Course: 307     Type: Hands-On Training     Duration: 5 Days

Quick Enroll    

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

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

Related Courses
Access is a trademark of Microsoft Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save Up to 40% per course on the Training Passport!

Access™ 2003: A Comprehensive Hands-On Introduction
Upcoming Dates
Oct 20 - 24, 2008
 Washington, DC (Rockville, MD)
Dec 8 - 12, 2008
 New York
Dec 15 - 19, 2008
 Atlanta
Jan 5 - 9, 2009
 Washington, DC (Alexandria, VA)
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
May 4 - 8, 2009
 Washington, DC (Alexandria, VA)

Access™ 2003: A Comprehensive Hands-On Introduction
Bring Learning Tree On-Site

Course Tuition
$ 3,090 Standard Tuition
Tuition with a Savings Plan
$ 2,250 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,785 Alumni Gold Discount
$ 2,744 Government Discount
 

 

Access™ 2003: A Comprehensive Hands-On Introduction
Access™ 2003: A Comprehensive Hands-On Introduction
Course participants using Access to develop a client/server front-end.
The most recent 100 evaluations scored this course at:

  (3.84/4.00)


Certification Core Course CPE 29 Credits 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733