ProgrammingMSAccess.com

Learn about Developers Group
Join Developers Group
Order SPAM Blocker
Free Stuff
Guest Book
.NET Resources
SQL Server Resources
Favorites
Technical Support
Books & DVDs by Webmaster
Articles, tutorials, & more
FAQs
Product Reviews
Samples
Prior Newsletters
Contact Us
Home
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Day 2 is on

SQL Server

Access 2002 and SQL Server Development Seminar

Access project interface

bullet

Opening and creating SQL Server databases

bullet

Importing, linking, and creating tables

bullet

Creating views

bullet

Coding stored procedures/triggers/user-defined functions

bullet

Adapting Books Online Code for Access projects and VBA modules

Programming, Forms, and Reports

bullet

Programming Transact SQL (T-SQL)

bullet

Creating solutions with SQL-DMO

bullet

Managing SQL Server security; expanded for security threats

bullet

Using Access forms and reports with SQL Server data sources

bullet

Developing workflow solutions; dropped for expanded security coverage

bullet

Using data access pages with SQL Server

Web Development Techniques

bulletPublishing SQL Server datasheets to the web
bullet

Using static and dynamic publishing

bullet

Creating custom ASP files

bullet

Publishing pictures in datasheets

bullet

Processing forms with ASP for SQL Server
bullet

Intro to form design for webs

bullet

Browsing, adding, updating, deleting, and searching for data and pictures

 Seminar home page  Site home Page