Skip Navigation LinksHome > events > Microsoft Access: Upgrading and Migrating to SQL Server and .NET > 2005AccessToSQLServerAndNET

About the speaker

Want to see more training topics?

See our variety of training topics

AdamCogan Adam Cogan is a Microsoft Regional Director, and Chief Architect at SSW. Adam has been developing custom solutions for businesses across a range of industries such as Government, banking, insurance and manufacturing since 1990 for clients such as Microsoft, Quicken, and the Fisheries Research and Development Corporation. His wealth of experience in the industry and unsurpassed technical knowledge will ensure attendees get the most out of these sessions.
The course [Microsoft Access: Upgrading and Migrating to .NET and SQL Server] was run by Adam Cogan from Superior Software for Windows which for me was a big selling point as I'd heard Adam speak before (and he was good). Overall a great event, one of the best trainings I have ever attended. Well done, Adam and team. Thomas Williams- Read more in his Blog http://dotnetjunkies.com/WebLog/thomasswilliams/archive/2004/12/15/36951.aspx
 

The Goal: To convert an Access application to .NET Windows Forms and Reporting Services powered by a SQL Server database.


The entire process of converting from Access to an enterprise level solution will be covered in two days, using a modified version of Northwind as an example. The attendees will approach the task as a real world problem where the entire project will be migrated in four steps (releases). Each step will be a logical extension of the last, allowing developers to stop their own development at a step where they will still have a functioning system, even though it may not necessarily be the best solution.

Book the course

Day 1 Day 2

1A: Making a Plan (2.5 hours)
  • About Presenters
  • Development Methodology - Extreme Programming (XP)
    • Tool 1: Short Releases
    • Tool 2: Microsoft Word
    • Tool 3: Unit Testing
  • Hands-on lab - Creating a release plan
1B: Converting Access 97 to Access 2003 (1 hour)
  • Converting to Access 2003
    • Why would you upgrade?
    • The issues
      • Uncompiled mdbs
      • Unused code blocks
      • Using referenced .mdbs and .mdes
      • Library mdes
    • Demo - Using tools to find issues
      • FMS Total Access Analyzer

Lunch (1 hour)

2: Upsizing to SQL Server (3 hours)
  • To Move or Not To Move?
  • Current Problems in Access
    • Corrupt data
    • Database users
    • Downtime during backups
    • Security
    • Missing records
  • What's new and different in SQL Server?
    • Architecture
    • Working with data
    • Scalability and performance
  • Demos
    • ssw Upsizing PRO!
    • Microsoft Upsizing Wizard
    • ssw Performance Pro!
    • ssw SQL Deploy
    • Lumigent LogExplorer
    • ssw SQL Auditor
  • Hands-on lab - Migrating Northwind from Access 2003 to SQL Server 2000

1: From Access to SQL Server Reporting Services (3 hours)
  • History of reporting
  • Report life cycle
  • Installing Reporting Services
  • Building a report in Visual Studio .NET
  • Report on any data source
  • Deploying reports
  • Hands-on Lab - migrating 4 Northwind reports from Access into Reporting Services

Lunch (1 hour)

2: From Access Forms to Windows Forms .NET (3 hours)

  • Current Problems with Access
    • Office upgrades
    • Corrupt databases
    • Slow forms
    • Large applications
    • Scalability
    • Deployment
  • What's new and different in .NET?
    • Form design
    • Form inheritance
    • Application design
    • Deployment
    • Visual Studio .NET
    • Programming - VBA vs VB.NET
  • Demos
    • Creating the Northwind Main Form in .NET
    • Creating the Northwind Orders Form in .NET
    • Orders form - the correct way
    • Northwind Orders - Converting to .NET the easy way!
  • Hands-on lab - Migrating Northwind forms to .NET

Detailed Session Descriptions:

Day 1

Session 1
Learn how to target the areas of the systems that should be converted to achieve the best result. How should development of this type of project happen? How should a project be managed? What methodologies are in place?

Upgrading an Access 97 database to Access 2003. What are the issues? With a demonstration using a modified version of the Northwind database.

Session 2
Upsize an Access 2003 database to SQL Server. A modified version of Northwind will be used as an example and the backend will be moved over to SQL Server, correcting a number of known issues concerning the data itself as well the database schema.

Day 2

Session 1
The advantages of moving Access reports into Microsoft's new SQL Server Reporting Services will be described, along with the process for importing four of the key reports from Northwind. Issues related to importing will be handled to produce identical reports. The reports will then be deployed to a report server to demonstrate the power of online reports using Reporting Services.

Session 2
Access Forms will be transformed into Windows Forms .NET in order to provide a more scalable and distributable application. The known issues during migration will be highlighted and the power of .NET will be leveraged to improve the interface performance.

Having moved to a Windows Forms .NET environment you will be shown how to make the application more accessible. Web services will be used so that the client does not need to be within an intranet to access the corporate database.

Session Dates

 

City

Dates
2Day.NET Training Canberra Thursday 11th Friday 12th November 2003
2Day.NET Training Brisbane Monday 29th Tuesday 30th November 2003
2Day.NET Training Sydney Thursday 2nd Friday 3rd December 2003 Sold Out
2Day.NET Training Adelaide Monday 6th Tuesday 7th December 2003
2Day.NET Training Perth Thursday 9th Friday 10th December 2003
2Day.NET Training Melbourne Monday 13th Tuesday 14th December 2003 Sold Out
2Day.NET Training Melbourne (Goldman Sachs Session) Thursday 16th Friday 17th December 2003
2Day.NET Training Sydney (Repeated Session) Monday 7th Tuesday 8th March 2004 Sold Out
2Day.NET Training Melbourne (Repeated Session) Thursday 10th Friday 11th March 2004 Sold Out
2Day.NET Training Brisbane (Repeated Session) Monday 14th Tuesday 15th March 2004
2Day.NET Training Sydney Wednesday 20th - Thursday 21st July 2005
2Day.NET Training Los Angeles Thursday 22nd - Friday 23rd September 2005 Sold Out
2Day.NET Training Seattle Monday 3rd & Tuesday 4th October 2005 Sold Out
2Day.NET Training Dallas Thursday 6th & Friday 7th October 2005
2Day.NET Training New York Monday 10th & Tuesday 11th October 2005
2Day.NET Training London Friday 14th October 2005 (1 Day Course)
 

Did you know that if you are unable to attend any of the above sessions, you can still grab all of the course materials?

Course Locations

New York, NY: Microsoft NY-NJ-CT District You are going to a site outside of SSW
London, UK: QA St. James House, 10 Roseberry Ave, Holborn London EC1R 4TF You are going to a site outside of SSW


System Requirements

Please note:

Course Materials

If you aren't able to make it to this seminar we have the complete set of course material used by the trainer, Adam Cogan, and the students.

For only $299.00US you receive:

So why wait? Order yours right now to start migrating!

Order Course Materials  

Acknowledgements

Adam Cogan
Scott McPhillips