Anyone who develops Access applications knows you need to split your database. The data can live on a file share, or better yet in SQL Server, and your Access front-end is ideally copied to each user’s computer. Running the front-end locally will improve performance and virtually eliminate corruption issues, but how do you effectively push out a new version out to all your users? File share? Email? Script file?

In this session Kevin will give the first public demonstration of a new deployment service, the appLauncher for Access.

Hosted in Azure, the appLauncher deploys front-ends to your users with a single click, and deploying a new version is as simple as uploading a Zip file.

Kevin started working professionally with Access in version 1.0 and has been working with SQL Server since version 4.21. For 15 years he ran a small consulting firm in Colorado that specialized in creating custom data driven applications on Access and SQL Server.
In 2008 he joined the Microsoft Access Team as a test engineer, working on the Access 2010, 2013 and 2016 releases. Kevin is currently working for a large consulting firm building equity compensation systems for big tech companies.
In his free time he enjoys cycling, playing baseball and someday being able to travel the world again searching for the perfect pint of ale.

Access Studio has been developed to overcome many of the shortcomings of the Access QBE and introduce new features similar to those found in SQL Server Management Studio. It can be run as a library file to any existing project or the professional version can be run as a standalone application to manage multiple applications plus additional features. Features include:

•  SQL formatting – colour and layout
•  View of available tables and fields
•  Double click to insert table and field names
•  Ability to add line and block comments
•  Ability to see results of a select query in the same window (up to five)
•  Execute multiple queries at the same time
•  Execute a highlighted selection of code • Highlight searched for text

Chris is a qualified management accountant who was a finance director of a number of companies. His first introduction to programming was in the mid 70’s to create a production control program on an Apple IIe using UCSD Pascal.
After that, accountancy became his primary direction of travel until he started a business in the mid 90’s and needed to develop some bespoke solutions to meet the new company’s requirements. It was at this point he discovered Access 97 and has continued to work with it and its successors ever since.
In early 2000, he sold the business and moved into full time contracting/consulting primarily in the arena of resolving conflicts between different corporate systems which were creating losses in the business. To date he has identified around £1/2 billion of annual savings across many clients.

Create professional Word documents from scratch using Word Automation. Write data and text, format, save, and open the finished document with VBA. We often want to make datasheets look nicer and have many of them in one report. A great way to do this is by creating a Word document with lots of pages and tables.

•  Make a new Word document, set margins, and define styles
•  Create a Word table with data from a recordset
•  Get comfortable with the Word object model
•  Write and format text in paragraphs, tables, headers, bookmarks, captions, and hyperlinks
•  Learn how to use and set ranges
•  Create a Table of Contents, and List of Tables
•  Define header with dynamic text to show at the top of each page
•  Insert, position, etc. images in Word documents

Crystal Long has been using and developing with Access a long time, and Word even longer since it was available in the DOS days. She connects 1-on-1 and guides developers as they're building applications, and teaches in virtual classrooms.
On her website, MsAccessGurus.com, you can find free code, tools, videos, and articles. On her YouTube channel, LearnAccessByCrystal, you'll find lots of Access videos and some about other Office topics. On forums, she is 'strive4peace'. She is also a long-time Access MVP.

This session will demonstrate ways of annotating downloaded static Google Maps to personalise these for your clients. Topics to be covered will include the use of:

•  Marker points e.g. to mark client locations or nearby places
•  Lines joining 2 or more points e.g. to indicate routes between locations
•  Circles around a location e.g. to show places of a specified type within a specified distance
•  Boundary shapes e.g. to show postcode or regional boundaries

All annotations are added as additional map layers using code as part of the URL used to generate the map. The session will also explain how to overcome issues caused by the 2083-character URL limit using the current web browser control based on IE (whilst we continue to wait for the new Chromium Edge browser control).

Access developer for over 20 years starting with Access 97. Many years teaching in secondary schools including responsibility for data analysis. I initially created Access apps for my own use and later for all staff in a number of UK schools.

My website Mendip Data Systems include many Access articles, example apps, sample code and security challenges, together with commercial applications for businesses, schools and developers. My focus is on stretching the boundaries of what can be achieved using Access.

A programmer since 1983, VBA since 1998, for several years Alessandro was consulting for the United Nations in different countries (Italy, Afghanistan, North Korea, Ethiopia, Austria), creating dozens of Office applications, from simple automation tools to corporate level, multiuser, Oracle based applications.
Since 2014 he lives in Frankfurt where for five years he worked as a VBA developer for the European Central Bank.

Since 2010 Themes are included in Access. They are not only about color properties like Background 1, Lighter 40%... but you can do things like changing all colors in a database with a single click! Since MSFT does not provide any slick tools for Themes, Peter has developed the free database ThemeMaker and the commercial add-in ApplyStyle for this purpose.

•  Introduction to Themes, why they are good and why they never became popular
•  How ThemeMaker db improves the use of Themes
•  How the ApplyStyle add-in gives old Northwind a 2016 look
•  Analyse used fonts, colors and pictures in the existing db
•  Creating a new style for a different look
•  Update all pictures/icons as Shared pictures
•  Simply add icons to buttons
•  Automatically create a template form with selected properties

The result is a consistent, centrally controlled design that can be applied to the entire database or any part of it with a few mouse clicks.

Peter is an Access developer, who has worked with Access since version 2, intersperced with CAD/CAM developments and macro programming on multiple version of Unix. He has developed an Access based manufacturing system for control desk panels incorporating a COM package for nesting, calls to graphics packages to incorporate color images and output of CNCcode.
He aims to try and dispel many of the myths about Themes in Access and provide tools to make their use easier.