Скачать или смотреть AEU37: AI Assistants – Bring your knowledge to the smartest AI models (Alexander Denz)

Description:
In this session Austrian developer, Alexander Denz, demonstrated how you can build AI assistants and integrate them as add-ins into your Access applications. You can also build custom ribbons or let the AI assistants help you in the VBA editor.

A PDF of the presentation slides and free module code are available to download from https://www.isladogs.co.uk/aeu-37/

NOTE: The host had some audio issues, especially towards the end of the session. However, these issues did not affect the actual presentation.

TIMES
0:00:00 Colin - welcome to the Access Europe User Group and to this month's presenter Alexander Denz
0:00:42 Intro by Alexander
0:00:50 Start of presentation - background info
0:02:03 First generation of AI Add-Ins
0:02:57 Outline of the Add-In
0:03:31 DEMO: Add-in - Ribbon Part - expand text from prompt / modify text style / translate text / custom prompts
0:05:37 Use of OpenAI Client to obtain information
0:06:35 More features - shorten text
0:07:15 Settings page to customize add-in
0:08:56 Customize language settings - edit XML
0:11:56 VBE - explain code
0:13:32 VBE - complete code including with prompts
0:16:58 VBE - optimize code
0:18:29 VBE - add comments
0:20:14 VBE - custom prompt
0:23:08 Using AI in a form - AI chat response done using class code
0:26:21 SDOpenAI Add-in Prices for Access/Word/Excel/Outlook (classic): single user license €59.90; server €239.90 (unlimited users)
0:28:07 Questions on first generation add-in
0:28:35 Q1: Neil - can you ask it to apply your own code standards/naming convention etc? A1: partly using custom prompt. Mostly requires second generation add-in
0:29:03 Q2: Chris - thought examples demonstrated were good but fairly simple. How well can code generate more complex requirements? A2: Use more advanced language model (e.g. o1-mini) for more complex tasks - but these cost more
0:30:24 Q3: Tim - can you instruct the add-in to use error handling by e.g. vbWatchdog or MZ-Tools? A3: Quick test - didn't work. Repeated with more advanced LLM - same outcome. Again would work with 2nd generation
0:34:22 Q4: Neil - asked about max tokens. A4 - tokens are used by OpenAI to charge for use of LLM depending on model used See https://platform.openai.com/docs/pricing
0:35:50 Second generation of AI Add-Ins - AI Assistants are custom vector databases - uses a selected LLM but also knows your data (which is NOT shared)
0:37:57 SDOpenAI Assistant is a toolset to build any AI driven function in a ribbon or the VBE : Timeline phases 1/2/3 explained
0:39:28 Main application - define assistants and give them your knowledge, describe behaviour, manage user rights and settings
0:39:59 DEMO - Main app - set user rights, create assistants, set properties & add files for knowledge base.
0:43:07 Use AI assistant with chat window in Access
0:43:59 DEMO Add-In - Ribbon Part - text translation / ribbon settings / VBA settings
0:49:55 DEMO Use add-in with the VBE - examples generating code in new module / run function using specified model
0:52:17 DEMO - create / run queries / generate answers using Assistant
0:56:20 Assistants - Prices - one time payment for main application & add-ins + annual costs related to accessing latest updates in AI models
0:57:34 Special offers - 40% off in March 2025; 20% off until Dec 2025 - use order code AEU37
0:58:31 Questions on second generation add-in
0:58:48 Q1:Neil - are Assistants an AI query with a pre-defined prompt which can by customised to the ribbon? A1: assistants add to the LLM by teaching it your own knowledge / code base / naming convention etc
0:59:43 Example given for clarification using Database Assistant in context of text file with database structure. Module code provided to generate this file for your own databases (see download link above).
Run SaveSQLDBStructureToFile function. Used in conjunction with additional DB information text file
1:02:17 Q2: Chris - asked for clarification about annual costs (minimum for one year). A2: Annual payments required to receive the latest updates but app will continue to work without this.
If you distribute apps created using AI Assistants, your clients would also need a main application license to make use of this.
1:05:48 Q3: Ben - when will AI be able to desgn a form? A3 - not for a while!
1:06:00 Thanks to Alex for an excellent presentation. Reminder of download link
1:06:52 Next month's presentation will be by former MVP, Anders Ebro, from Denmark - Class Modules: How, why & when to use them in the real world
1:07:47 Further question- Q4: Chris asked Alex whether AI will ever be able to convert an Access VBA app into a web based HTML app? A4: Probably not in the near future.
However, AI tools such as Claude & Google AI Studio can be used to access your forms / screen and allow interaction. The abilities of AI will continue to improve rapidly
1:09:31 Final comments from Alex and Colin. See you all next month.
1:11:26 End