|
| |
Day
2 is on SQL
Server |
Access 2002 and SQL Server
Development Seminar
|
Access project interface
 |
Opening and creating SQL Server databases
|
 |
Importing, linking, and creating tables
|
 |
Creating views
|
 |
Coding stored procedures/triggers/user-defined
functions
|
 |
Adapting Books Online Code for Access projects
and VBA modules
|
Programming, Forms, and Reports
 |
Programming Transact SQL (T-SQL)
|
 |
Creating solutions with SQL-DMO
|
 |
Managing SQL Server security; expanded for
security threats
|
 |
Using Access forms and reports with SQL Server data sources
|
 |
Developing workflow solutions; dropped for
expanded security coverage
|
 |
Using data access pages with SQL Server
|
Web Development Techniques
 | Publishing SQL Server datasheets to the web
 |
Using static and dynamic publishing
|
 |
Creating custom ASP files
|
 |
Publishing pictures in datasheets
|
|
 |
Processing forms with ASP for SQL
Server
 |
Intro to form design for webs
|
 |
Browsing, adding, updating, deleting, and
searching for data and pictures
|
|
Seminar
home page Site home Page |