Webcast Today–Author Andrew Couch Speaks on Access Applications

Presented by the author of Microsoft Access 2010 VBA Programming Inside Out
Building Access Applications with SQL Server Databases

DateTuesday, August 9, 2011

Time 10AM PT, San Francisco
6pm - London | 1pm - New York | Wed, Aug 10th at 3am - Sydney | Wed, Aug 10th at 2am - Tokyo | Wed, Aug 10th at 1am - Beijing | 10:30pm - Mumbai

Presented by: Andrew Couch

Duration: Approximately 60 minutes.

Cost: Free

Once you have connected an Access accdb or mdb application to SQL Server, just how should you tackle the question of developing or adapting your application to be efficient and flexible? This session is sprinkled with VBA, TSQL, Access and the SQL Server Management Studio.

The best way to get an overview of how to develop with an Access application linked to SQL Server and use the associated tools is to watch someone building solutions. In this session we will be demonstrating the construction of DSN's, linking tables, views, and using stored procedures and views in pass-through queries. This will include a discussion of the benefits in using SQL Server Schemas and Synonyms. Following this we will look at techniques for using local temporary tables, SQL Server temporary tables and resolving performance issues.

The session provides an introduction to these topics which are further explained in my book Microsoft Access 2010 VBA Programming Inside Out.

About Andrew Couch

Andrew Couch is a Microsoft Access MVP. He has been programming with VBA since it was introduced into the Access product, and uses VBA on a daily basis in commercial applications. As a director and founding member of the UK Access User Group, he has been involved with developers and software companies using VBA. Andrew is also an experienced instructor, and has taught Introductory, Advanced, and VBA programming courses.

Skip to main content