Welcome! In these 5 sessions you will run through the complete process to upgrade and migrate your Access backend to SQL Server, Reporting Services and .NET.

Follow the hands-in labs from top to bottom, using the resources as supplementary material wherever they are referenced.

Day	Session	Workbook	Resources
1	1A. Making a Plan		Northwind Proposal - Contains: your UI, database design, and business rules (aka unit tests)
	1B. Converting Access 97 to 2003	N / A	Microsoft Access 2002 Conversion
	2. Upsizing Access to SQL Server		What's New and Different when Moving Your Backend from Access to SQL Server 2000 How to Migrate Your Backend from Access to SQL Server 2000 Northwind Data (Frontend and Backend MDB files)
2	3. Access to Reporting Services		What's New and Different for the Access Developer Moving to SQL Reporting Services How to Migrate Access Reports to Reporting Services
	4. Access forms to Windows Forms .NET		What's New and Different for the Access Developer Moving to .NET How to Migrate Access Forms to .NET Windows Forms Northwind .NET - Complete Solution

Products

Here are links to the products we used in the sessions:

SSW Utilities

• SSW eXtreme Emails! - Allocate tasks, set priorities, assign due dates and get Progress Reports without re-entering any data and working in the familiar Microsoft Outlook environment.
• SSW Upsizing PRO! - prepare your Access database so you can convert effortlessly to SQL Server
• SSW Performance PRO! - isolates performance bottle-necks in your Access application
• SSW SQL Auditor - Identify and fix problems in database design
• SSW SQL Deploy - automatically perform Database updates as a part of your application deployment

Third-party Utilities

• nUnit (free unit testing framework for .NET)
• FMS Total Access Analyzer
• Rad Software NextGeneration - a code generator and software development tool for .NET
• Microtools - transform your Access forms & reports into manageable .NET forms and Crystal Reports.
• LookOut for Outlook - Super-fast email search plugin for Outlook

Contact us for more information about these products.

Acknowledgements

Adam Cogan
Jatin Valabjee
Andrew Weaver