Denver CO 2014 Access Day Presenters
Wednesday, October 8, 2014
POWER TIPS FOR ACCESS FORMS AND REPORTS
Have you ever wondered what techniques you should use to perform many of the development tasks required to build an Access application? This session shows you best practices and the tips you should know in order to build forms and reports that are flexible, powerful, and that optimize performance. During the session you’ll be exposed to power techniques every developer should have in their toolkit when working with each of these objects. You will leave with sample code in hand, and you will be ready to apply the techniques that you learn to your own Access applications.
Alison Balter is a leading author of Microsoft Access books and SQL Server books, including Access 2013 Absolute Beginners Guide, Alison Balter’s Mastering Access 2007 Development, Teach Yourself SQL Server 2005 Express in 24 Hours, a developer video training series on Access 2013, and a user video training series on Access 2013, all for SAMS Publishing. She also authored an Access Developer video series for Experts Exchange where she also has published numerous articles.
Alison is a highly experienced developer and independent trainer. She loves to take highly technical material and explain it in a way that everyone can understand. Alison develops applications using Access and SQL Server. She specializes in teaching others how to develop Windows and Web applications. During her 27 years in the computer industry, she has trained and consulted many people in corporations and government agencies, including Southern California Edison, Shell Oil, Cisco, University of Southern California, and Massachusetts Institute of Technology. On a personal note, Alison enjoys spending time with her husband Dan, and children Alexis and Brendan. They all love to travel, ski (snow and water), and hike. Alison also likes walking, yoga, and weight lifting.
LIFECYCLE OF AN ACCESS 2013 WEB APP
Access 2013 web apps allow you to quickly build cloud based data-centric apps, but what happens when the client starts asking for more functionality? In this session Kevin will show you how simple it is to create an Access 2013 web app and then how it can be customized over time to add new features and functionality. Finally we will look at some new tools to help manage deploying and upgrading Access 2013 web apps.
Kevin Bell is a test engineer on the Microsoft Access team in Redmond Washington. Prior to joining Microsoft in 2008, Kevin was a partner in a consulting practice that specialized in building custom software solutions, primarily with Microsoft Access connected to a SQL Server backend. Over a 15+ year consulting career he has created a variety of applications from a management system for a small drapery shop with a handful of users, to a compliance tracking system for a large insurance company with hundreds of users in multiple locations.
Like many Access Developers, Kevin’s career with Access started by accident. While working in Melbourne, Australia for an illumination engineering firm, he started modernizing the company’s testing reports using Microsoft Excel. Excel offered a rich presentation layer, but it wasn’t very efficient at managing large amounts of data. Databases at the time lacked graphical capabilities and Microsoft’s newly released Visual Basic lacked database support. Then Access 1.0 arrived, combining the best elements of all three, and Kevin was hooked.
Over the years Kevin has been a member, officer and frequent presenter at the Denver Area Access User Group and now regularly attends the Pacific Northwest Access Developers Group. He has also presented at the UK Access Group National Seminar, and at the Portland Access User Group Spring Conference.
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.
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.
ACCESS WEB APPS - OKAY, NOW WHAT?
So you’ve created an Access Web App – what else can you do with it? George will explain how Access Web Apps can integrate into the broader Office and Office 365/SharePoint ecosystem. We’ll start with an Access Web App developed using the beloved Northwind database sample, and we’ll look at some recently-added features, like embedded Office Apps. We’ll then see how we can build Apps for SharePoint and Cloud Business Apps using the Access Web App back-end. Finally, we’ll build a new Universal App (Windows and Windows Phone 8.1) using that same Access Web App database.
George first encountered Microsoft Access when using the early versions of Office to teach Statistics and MIS in the early 1990’s. It’s been true love ever since! George has worked as a software developer for the past twenty years, including twelve at Microsoft (in just about every group other than Office). He is currently an independent consultant living at 6700 feet in Castle Rock, Colorado, working primarily on .NET applications. George has spoken at the Denver Area Access User Group, the Denver Visual Studio User Group, the Colorado SharePoint User Group, and Access Day in Irvine, CA.