Access Europe – Domenico Ruggiero (Orchestrating Office: Amplifying Access with Multi-Application Automation)

This Access Europe meeting will be on Wednesday 4 June 2025 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:30 (7.30PM)

The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST

Please note that the UK will be on Summer Time (UTC+1) for this meeting. For local times, please check World Time Buddy

You can click the button below to download a small calendar (.ics) file and add the meetings to your Outlook calendar. This will add a recurring appointment to the first Wednesday of each month.

Outlook Calendar (.ics)

————————————————————————————————————————

Topic outline:

In today’s data-driven world, database solutions must do more than store records: they need to deliver actionable insights, high-quality documents, and dynamic presentations at the click of a button. In this session, you’ll discover Advanced Office Analysis & Automation (AOAA), a proven framework that empowers Microsoft Access to coordinate seamlessly with Excel, Word, PowerPoint, Outlook, SharePoint, and SQL Server — leveraging each application for what it does best while sharing data fluidly between them.

In this session, Domenico Ruggiero will be discussing multi-app solutions that involve Access and SQL Server as a foundation for serving up exports to Excel / PowerPoint / Word.

Why Attend?
• Real-World Case Study:
Explore the CSI Cost Management Report Automation, where a weekly, 4–5 hour manual process for 40–50 projects (later over 150) was transformed into a fully automated workflow named
“Rod-Bot”. Using an Access front end connected to SQL Server and templated Excel workbooks, each of 160+ reports is generated, validated, and queued with progress notifications,
thereby freeing stakeholders to focus on analysis instead of assembly.

• AOAA Principles:
Learn how to apply modular, reusable VBA-driven logic and proven methodologies to orchestrate multi-app solutions that adapt as your inputs and requirements evolve.

• Technical Deep Dive:
See best practices for:
o Configuring Access to work with templates with a non-coder stakeholder’s flexibility to make changes.
o What standardized templates look like in Excel, Word, and PowerPoint.
o VBA code for building batch distributions of emails and attachments through Outlook.
o A custom email notification (UI based) for Access checking for unread Outlook inbox emails.

Who Should Attend?
Access developers, Office power-users, and IT professionals eager to elevate their applications beyond standalone silos — leveraging the full Microsoft Office ecosystem to deliver richer, faster, and more accurate solutions. Join this Orchestrating Office presentation and walk away with actionable techniques to harmonize your Office applications, turning disparate tools into a cohesive, productivity-boosting symphony!

Background Info:

Domenico Ruggiero (AKA The Software Maestro) is a high-performing, ambitious and self-motivating individual with a B.A. in Aerospace Engineering from the University of Florida and an M.S. in Industrial Engineering with an emphasis on Engineering Management from the University of Central Florida.

He has over 20 years of experience in engineering, project management, operations, and software development with a history of repeatedly implementing analytical methods, automation scripts, and innovative integrated solutions for NASA programs and many other clients.

Domenico possesses a powerful combination of business and operations experience, a strong educational background, and an analytical mindset.
In recent years, he has become an expert in the development of advanced VBA-enabled, customized analytical models and data automation tools using many of the MS Suite of products.

Website: Meet the Software Maestro | the-software-maestro

======================================================================

IMPORTANT NOTE:

All sessions will be recorded and later uploaded to the AccessUserGroups channel on YouTube: AccessUserGroups.org – YouTube.

If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off.

======================================================================

We use Zoom as our meeting application.

Please click the link below to download Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link or phone number

Join Zoom Meeting

If you are asked:

Meeting ID: 924 3129 5683
Passcode: 661210

Dial by your location:
+1 669 900 9128 US (San Jose)
+1 253 215 8782 US (Tacoma)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 346 248 7799 US (Houston)
+1 646 558 8656 US (New York)
+43 12 535 502 Austria
+32 1579 5132 Belgium
+359 3 257 1633 Bulgaria
+385 1300 0988 Croatia
+420 5 3889 0161 Czech Republic
+45 32 70 12 06 Denmark
+358 9 7252 2471 Finland
+33 1 7037 9729 France
+49 69 7104 9922 Germany
+30 211 198 4488 Greece
+36 1 779 9126 Hungary
+353 1 653 3898 Ireland
+39 069 480 6488 Italy
+352 2786 4277 Luxembourg
+356 2778 1288 Malta
+31 20 241 0288 Netherlands

April 01, 2026 6:00 pm - 7:30 pm

View Event Join Meeting

Access Europe – Domenico Ruggiero (Orchestrating Office: Amplifying Access with Multi-Application Automation)

Get Zoom

Join Zoom Meeting

Meeting ID: 924 3129 5683 Passcode: 661210

Meeting ID: 924 3129 5683
Passcode: 661210