Скачать или смотреть AEU40: Orchestrating Office (Domenico Ruggiero)

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

Download a PDF of the slides used in this presentation from https://www.isladogs.co.uk/aeu-40.
All other files can be downloaded direct from Domenico's website: https://www.thesoftwaremaestro.com/si... (ZIP file - approx. 78 MB)

TIMES
0:00:00 Colin - welcome to the Access Europe User Group and this month's presenter Domenico Ruggiero
0:00:48 Intro by Domenico
0:01:17 Today's Program - Warmup / ShowTime / Encore / Takeaways
0:03:51 Objectives
0:04:52 Background
0:07:08 ShowTime - Meet the 'Orchestra'
0:08:50 Why use the Other Applications along with Access? Excel / PowerPoint / Word etc.
0:09:42 Why use Excel? Excellent for data analysis / charting / customised visualisations. Excel is NOT a database!
0:11:01 MS Project - excellent for schedules / not suitable for presentation purposes. Use PowerPoint for presentation & custom visualisations
0:11:45 Use the right tool for the task
0:12:03 Data Utliization
0:13:06 Don't Forget the Human Element in System
0:14:33 Optimize entire system for best results
0:16:06 Real world case study - problem / solution
0:18:37 Advanced Office Analysis & Automation (AOAA)
0:19:38 Technical Alternatives: AOAA / Python / Power Automate / .NET
0:21:05 AOAA - Development Stages
0:24:18 AOAA - Before / After
0:26:29 Summary: AOAA is a force multiplier!
0:27:02 AOAA doesn't do it all!
0:27:35 Technical demonstration to show process - Access / Excel / PowerPoint / Word
0:29:44 DEMO - load Excel data from Access & work with Excel named ranges summary data
0:39:01 VBA code: Access to Excel to PowerPoint
0:42:31 Create PowerPoint slides from Excel summary data using VBA code
0:43:29 Add conditional formatting - Excel to PowerPoint
0:45:27 Transfer Excel data into Word
0:46:35 In Word, use of bookmarks as 'equivalent' of named ranges - replace bookmark tags with data
0:50:59 Early/late binding - differences explained
0:53:21 Example using Word bookmarks - course catalog
0:58:17 Automated Course Catalog
1:00:25 Rachel: This concept is exactly what I need. My mistake has been trying to make Access put my reports and charts together, but after seeing this it makes way more sense to output the data to the program that handles the data best.
1:01:12 John: 'special binding' available in VBE_Extras add-in which combines benefits of both early & late binding
1:03:51 Summary of files that will be made available
1:06:36 Klaus has automated Access with numerous other apps Excel/PowerPoint/Outlook/visio & PowerShell
1:07:07 Eric has automated WordPerfect with Access (as he can't stand Word!)
1:07:38 Colin - Q: Has anyone used Dataverse with Access A: nobody had!
1:08:07 Dilbert cartoons - automation / efficiency
1:08:27 Colin: Thanks to Domenico for an excellent presentation
1:09:49 Next month - Wed 2 July - Pete Poppe - Faking 'non-normal' user interfaces with Normal Data
1:15:35 Klaus - question/discussion about treeview controls
1:18:02 Wed 6 Aug - Colin Riddington - provisional topic dependant on release date for forthcoming Access features
1:19:22 Brief demo of two Monaco improvements now in Beta channel
1:21:05 Final comments - see you all next month
1:21:15 End