One of the best ways to take your Access applications to the next level is by using SQL Server as a back-end. SQL Server gives you a lot of functionality that Access lacks and along with much improved security. An Access front-end with a SQL Server back-end is a set-up that has been used thousands of times the world over by many different types of companies (including Fortune 500 companies).
- 01 – What is SQL Server?
- 02 – Installing SQL Server
- 03 – Logging On
- 04 – Creating A Database
- 05 – Creating A Table
- 06 – Table SQL Basics
- 07 – Adding A New User To A Database
- 08 – Installing SQL Server Migration Assistant
- 09 – Migrating Tables And Data To SQL Server
- 10 – Creating Views
- 11 – Functions
- 12 – Stored Procedures
- 13 – Calling A Stored Procedure From Access
- 14 – Creating A Trigger
- 15 – Designing For SQL Server