What are the major differences between Access and Power Apps? When to use which? Join us to find out, and to get some of the latest news on the growing integration of Power Apps with Office products.

Maria Barnes runs Barnes Business Solutions, Inc. Barnes Business Solutions, Inc provides 30 years of Software Design and Programming Expertise, specializnig in Access and SQL Server databases, Microsoft Office integration, PowerApps, and solutions for small and mid-size companies. She is the chapter president for the AcessUserGroups.org Lunchtime user group and has been a Microsoft Office Apps & Services MVP (specializing in Access) for the past 3 years.

Download the presentation materials

Watch the recorded video of Access versus Power Apps on our YouTube channel

IMPORTANT: This presentation is at 10:30 AM Mountain Time

Query performance is a critical aspect of most database applications. Nevertheless, performance problems are often only addressed as an afterthought to application development when it is more difficult and labor-intensive to fix those issues.

Philipp will present fundamental aspects of database performance and will discuss some simple performance tuning rules that are basically applicable everywhere. These rules already have a huge effect with plain Microsoft Access applications. The effect will be magnified when applied to Access applications with SQL Server backends linked via ODBC.

Philipp is working as an independent consultant with Microsoft Access, SQL Server, VB.Net for many small businesses from many different industry sectors. He also writes about these technologies at his website codekabinett.com and publishes videos on the codekabinett YouTube channel.

Watch the recorded video of Access Database Performance – With and Without SQL Server on our YouTube channel

What are Stored Procedures, and how can they make your Access/SQL application even more awesome? Aaron Kogan will be presenting on SQL Server Stored Procedures. More specifically, how to create them, when to use them and how to integrate them into your Access project.

Aaron Kogan got his start with IT in the late 1900's using GPS & GIS to map Haleakala National Park on Maui, where he currently lives. He started using Microsoft Access when it was still installed using 24 3.5" not-so-floppy disks. During the early part of his database software development career he worked in the conservation sector for The National Park Service, The Nature Conservancy and several other Hawaii-based agencies. Since 2003, Aaron has been the owner/operator of SLM Data LLC, developing database software for clients across many industries. Aaron was a DAAUG board member while he lived in the Denver area from 2008 until 2012.

Watch the recorded video of Just Sproc It! on our YouTube channel