Home Training Products Services DS Info Clients

Microsoft Access

Access as a Front End to SQL Server

This course teaches Access developers how to convert their file server systems to client server, using MS SQL Server as the database back end. We discuss why we would want to do this and the differences between the roles of Jet and SQL server in these different systems. Then we look at advantages to using SQL Server, and what we get with a SQL Server system that we don’t have with Jet. We will learn the basics of using stored procedures and other SQL server objects. And, of course, we will look at different ways to access server data from a front end application. This course assumes previous experience in MS Access database development. (3 or 5 days with hands on, depending on topics covered)

Topics:

v File Server verses Client Server, What’s the difference.

v Differences between Jet and SQL Server in managing data.

v Upsizing an existing database

v An Intro to Stored Procedures

v Inserts, Updates, and deletes in a client server system.

v Dealing with concurrency issues

v Getting at the data

v An intro to ADO

v Using SQL Server data in Access reports

v Securing a SQL Server data

v 2 Tier vs N Tier in Access-SQL Applications

v Deployment and Maintenance considerations