Redmond, WA 2014 Access Day Presenters
Thursday, November 6, 2014
TIPS AND TECHNIQUES FOR TAKING OVER A LEGACY MICROSOFT ACCESS DATABASE APPLICATION
Taking over someone else’s work is very challenging regardless of the technology. People have different styles, technical skills, and philosophies when creating software. Understanding someone else’s work, trying to understand the data, figuring out how all the Access pieces cross-reference each other can be very challenging. Taking over, then enhancing a solution can be very risky. At FMS, we’ve faced this issue for 20 years and have come up with automated processes and Best Practices procedures to quickly triage Access solutions, understand what’s going on, and identify ways to quickly improve Access solutions. Learn how we minimize the risk when making changes, and establish a foundation that supports maintainability and system administration over time.
Luke Chung is the president and founder of FMS, the world’s leading developer of commercial products for Microsoft Access with 12 products for users, developers, and system administrators. Located near Washington DC, FMS is celebrating its 27th year in business with tens of thousands of customers in over 100 countries. Luke supported Access since its debut, is a Microsoft MVP, and Access developer. He’s the lead author behind products such as Total Access Analyzer, Total Access Emailer, Total Access Statistics, and Total Visual CodeTools. He has also created custom solutions using Microsoft Access, SQL Server, Visual Studio, and LightSwitch for Windows, web and mobility platforms. FMS also has products for big data visualization used in the intelligence and law enforcement communities. He has spoken at conferences and user groups across the US, Europe, and Australia, and written numerous technical articles. Luke holds a degree in physical oceanography from Harvard.
FROM 0 TO 50, POWERED BY MICROSOFT ACCESS
Microsoft Access + SQL Server has been the heart of COMC.com’s innovation engine. Learn the tips and tricks that have helped COMC grow from their first employee to more than 50 employees across the US & Canada in just 7 years. See how Microsoft Access can drastically reduce the cost of building a commercial website.
Tim Getsch is the founder and CEO of COMC.com. COMC is making it safe & easy for people to buy & sell collectible online by pioneering online consignment. COMC sells more individual sports cards than any website other than eBay. Prior to starting COMC, Tim was a Program Manager on the Microsoft Access team for 6 years, and Tim has presented at numerous Access conferences and user group meetings over the past 12 years.
GREAT DATABASE DESIGN
All Access projects should start with great database structures. Do yours? Armen will present the database design techniques and naming conventions that J Street Technology uses in their projects. Slides and documents will be available to attendees.
Armen Stein is the founder and president of J Street Technology, a Microsoft Partner located near Seattle. J Street is a team of developers with expertise in custom Access desktop and ASP.NET web applications. Armen is a Microsoft Certified Professional and an Access MVP, and has spoken at many user groups and conferences, including Microsoft TechEd, Office DevCon in Australia, the PAUG Conference, and the UK Access User Group in London. Armen is co-author of Access 2007 VBA Programmer’s Reference (Wrox). His other interests include travel, photography, backgammon, movies, and driving his 1969 Ford Bronco in the sun.
A REAL, LIVE, WORKING 2013 WEB APP
Access Web Apps sound good in theory, but how does it work in the real world? Andy has been developing web apps since Access 2010 and he will demonstrate one of his live, production web apps, WaterfallCalc.com, which was developed for the mortgage banking industry. You’ll discover some of the pros and cons of designing web apps, pitfalls to avoid, workarounds for common problems and how to take advantage of this technology for your own needs.
Andy Tabisz is the owner of WorkSmart Database Masters, a Michigan-based technology firm focused on providing custom Access desktop, Access web app, ASP.Net and SharePoint solutions designed to increase productivity. Andy has been developing Access databases since 1994 (version 2.0) and has spoken at many Access and SQL conferences, including the show-and-tell at PAUG, Detroit SQL Users Group and SQL Saturdays in Rochester NY, Ft Lauderdale FL, Baton Rouge LA, Albany NY and Indianapolis IN. Andy enjoys traveling with his wife Marcia, and his interests include movies, golf and his non-profit JobsHelpAndHope.org. He also is a huge Dave Ramsey fan and an avid reader of business and marketing books.
ACCESS WEB APPS INSIDE OUT
Access 2013 web apps built on top of Office 365 open up new types of scenarios and opportunities for Access developers. In this session, Jeff will discuss how to build, deploy, and upgrade Access web apps and how you can utilize them effectively to solve your business needs. You’ll also learn about some of the newer features recently introduced to Access web apps to add power and flexibility. Jeff will also share some unique tips and tricks you can use in your own Access web apps, including how to utilize a hybrid approach to extend your web app with desktop capabilities.
Jeff Conrad is a Senior Content Developer within the Microsoft Office Creative Content team. Before recently transitioning into his new role of writing content for Access, Jeff was a member of the Access development test team for over 7 1/2 years. Jeff is a former Microsoft Access MVP and a published author on Access and Access Services. Jeff has authored three Microsoft Press books on Access so far: Microsoft Access 2013 Inside Out, Microsoft Access 2010 Inside Out, and Microsoft Office Access 2007 Inside Out. Jeff has also been a technical reviewer on other Access books from other authors. He has given presentations at local Access user groups, TechReady, TechEd, and Microsoft’s SharePoint Conference. Jeff is also active in various public online forums and newsgroups helping to answer customer questions concerning Access. In addition to his busy work schedule, Jeff maintains the Access Junkie website with information and resource links for people needing guidance with the Access database program.