Site Navigation:

Customizable Training


Onsite training is a very effective method to quickly train a team. Since we have written courseware, articles and published books on various technologies, we can easily adapt and tailor the material for your particular project and developer needs. Electing to have the class come to you provides a high ROI by eliminating travel costs and time away from the office while providing some progress on your project through the tailored solutions presented. The onsite option can be cost effective with as few as 3 attendees.

We will be glad to discuss this option in more detail and review dates that may work for your project team.

The following classes are offered for Customizable Onsite Training. For other technologies, visit the links on the lower right of the page.

Access 2002/2003 Level 1: Creating Applications

Standard Duration Price # of Students Additional Student Price
2 days $3,580 5 $400

Level 1 courseware introduces you to application development using Microsoft Access 2000. You'll learn the tools you need to create a simple Microsoft Access application including tables, queries, forms, reports, and just enough VBA code to get you started. By the end of Level 1, you'll learn how to put an application together, including how to create menus and how to launch your application from a startup form.

In Level 1 you will learn...

  • Design tables and queries so you can store and retrieve your information the best way possible.
  • Create useful, attractive form for data input and application navigation.
  • Create reports that display the data you want, formatted the way you want it.
  • Use hyperlinks and the Access Wizards to help create a full Access application without writing any code.



Access 2002/2003 Level 2: Programming

Standard Duration Price # of Students Additional Student Price
3 days $5,370 5 $600

Level 2 looks at the critical aspects of application development using Microsoft Access. You'll dig deeper into forms, tables, queries, and reports, and explore modules as you learn to use Visual Basic for Applications (VBA). Level 2 teaches you both how to design effective database applications, including database normalization and relationships, rules, and indexes; and how to work with VBA to manipulate objects and data. You?ll learn how to programmatically display and manipulate data on forms and reports, and you?ll begin to work with the Internet features in Microsoft Access as you create and deploy Data Access Pages.

In Level 2 you will learn...

  • Start using VBA in Microsoft Access.
  • Design efficient table structures to organize your data.
  • Create relationships between tables and set up referential integrity.
  • Display filtered and sorted data on forms and reports.
  • Master tips and tricks that create great reports.
  • Publish live Access data on the Web using Data Access Pages.
  • Work with forms? recordsets.



Access 2002/2003 Level 3: Advanced Development

Standard Duration Price # of Students Additional Student Price
3 days $5,370 5 $600

Level 3 shows you how to move from creating simple applications to creating enterprise-wide, robust applications for multiple users. You'll learn how to debug and handle errors, how to use ADO to work with data programmatically, how to secure your data with Microsoft Access security, and how to scale up to an Access client/server solution.

In Level 3 you will learn...

  • Debug applications and handle errors.
  • Master Microsoft Access security.
  • Use Replication to synchronize data among multiple sites.
  • Design client/server applications with Microsoft Access.
  • Use Automation to incorporate other Windows applications into your Access solutions.
  • Manipulate data using ActiveX Data Objects (ADO).



Details:

The DSW Group, Ltd. charges a flat travel free for the continental U.S. of $1700 for 5 day classes, $1500 for 4 day classes, $1300 for 3 day classes, $1100 for 2 day classes, and $900 for 1 day classes. This fee is in addition ot the above pricing. A non-refundable deposit of $3,000 is required to lock in a scheduled date and instructor. Balance duie will be invoiced upon completion, due Net 15 upon receipt of invoice. Payment can be made by check, Visa, Master Card, American Express or Discover.

Normal class times for a 5-Day class are 9:00am to 5:00pm Monday through Thursday and 9:00 to 1:00pm on Friday. Unless instructed otherwise, we will assume business casual as the appropriate dress code.

Our client is responsible for providing the training room, one PC for each student, appropriate software loaded on each machine, whiteboard, screen and projector for our instructor to use with his notebook computer.

Contact:

To inquire and/or schedule an onsite training session, please contact:

Training@thedswgroup.com
770-953-0393

The DSW Group

Consultants, Trainers and Content Producers. Learn more about us.

Available Technologies

Explore other training options...