typloop.gif


MICROSOFT 
ACCESS SIG's

Fundamentals SIG

Beginner SIG

Intermediate SIG

Advanced SIG

Developer's SIG

Help Workshop SIG

HAL-PC Home Page

The Dyson Group

Tips and other links

Jokes

Book Reviews







The Microsoft Access Developer's

Workshop
Special Interest Group
___________________________________

typloop.giftyploop.gif

    Workshop oriented toward... 
    the Seasoned Access Developer!

SIG Leader: Bob Stewart 

______ Monthly Meetings ______

Day:  

Second Saturday of the Month

Time:  

9:00 am to 12:00 noon

  • Advanced topics are covered using Access XP and SQL Server 2000. 
  • Beginners are encouraged to attend so they can learn the "right" way to develop Access programs.
  • Normally, the first half of the SIG will be dedicated to covering a new topic. See the list below for some of the topics that will be covered over the next year.
  • The second half of the SIG will be dedicated to showing examples that cover what was presented during the first half. During this time, we will also cover any questions that are within the subject area of the presentation.
  • Ocassionally, we will have a general question and answer session that will try to give you the answers you are looking for.
  • The current SIG leader will not cover securing an Access application and will not discuss it during the SIG.
  • Where appropriate the differences between the versions will be addressed by the presenter.
TOPIC SCHEDULE OVERVIEW
Topics being covered during the 2003-2004 SIG year will include the following:

 

Business rule implementation

Business definition

Scaling up to full SQL (data)

Access Functions to SQL Server Functions

Access Subs to SQL Server Stored

Stored Procedures

Unbound Reports

Unbound Forms

Transaction based data

Transact SQL (SQL Server programming)

Data warehousing

Access Data Projects

Access Data Pages

MSDE (MS Data Engine)

SQL Server Administration for an Access Programmer

Effecient form and report design

Creating SQL queries on the fly

Back to top of page.

 

Send e-mail to the SIG Leader for this page

Copyright © 2000-2003, "Access Advanced" Special Interest Group!