Several Microsoft Access schema, forms, and reports changes force a Microsoft Access version upgrade and data migration with the final step being a Microsoft SQL upsizing project. The technology used: Microsoft Access, FMS tools (www.fmsinc.com), Microsoft VBA, Microsoft SQL Server.
Automation reduces a two days, two person, labor intensive process, which wasn't enjoyed by anyone, to a 5 to 10 minute process. At the end of the day, the professionals that used to gather, organize and build the presentation were freed up to do other things. The technology used: Microsoft SQL Server, Microsoft Task Scheduler, Microsoft SSIS, Datawatch Data Pump, Microsoft VBA, and Microsoft Excel.