Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Captain's Log    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Access as an AI Agent?
Richard Rost 
          
10 months ago
What if Microsoft Access could act as an AI Agent that actually does things in your database?

A number of students have emailed me recently asking if I have more projects planned involving Access and AI integration, and the answer is absolutely yes. One idea I've been working on is showing you how to turn Microsoft Access into an AI agent.

If you're not familiar with the term, an agent is basically AI that can take actions - not just give answers. Instead of asking, "What's this customer's phone number?" and getting a reply, you could say something like, "Mark order 14525 as paid," or, "Add a follow-up for me to call John Smith next Thursday," and it would actually do it. Behind the scenes, it could write and execute the SQL to add the record, or send an email, or update your database automatically.

I've already built a few AI tools for Access, like my AI Builder that can write SQL or simple VBA for your database. But this would take it a step further: giving the AI a defined list of commands it's allowed to execute - things like look up a customer, add a contact, cancel an order, remove someone from the mailing list, or send an email.

So the question is: would you be interested in seeing me build an Access AI Agent? Maybe first as a template, and if there's enough interest, a full seminar.

Would you use something like this?
Richard Rost OP  @Reply  
          
10 months ago

Kevin Robertson  @Reply  
          
10 months ago
I am voting YES for the AI Agent. Sounds like it could be really neat.
Ray White  @Reply  
      
10 months ago
Bring it on AI
Brent Davis  @Reply  
     
10 months ago
You bet!!!!
Donald Lader  @Reply  
      
10 months ago
What are you waiting for? Engage!
James Hopkins  @Reply  
     
10 months ago
I am voting YES for the AI Agent. Sounds like it could be an great add-on the any database system.
Tyrone Singletary  @Reply  
    
10 months ago
Yes for the AI Agent
Abraham Breuer  @Reply  
     
10 months ago
Go for it it will be brilliant.
Michael Olgren  @Reply  
      
10 months ago
I am clearly in the minority here. For a detailed explanation as to where I stand I’d recommend watching Adam Conover’s YouTube on the AI bubble. That, and anything by Ed Zitron.
Richard Rost OP  @Reply  
          
10 months ago
Michael how about a quick paraphrase?
Michael Olgren  @Reply  
      
10 months ago
Basically the AI companies aren’t making money even after 5 years and billions of investment. Add on top of that the energy problem- not enough for the expansion they’d like and predict.
Richard Rost OP  @Reply  
          
10 months ago
Didnt the search companies have the same problem in the early days? Lots of money spent, little profit, and everyone wondering how they'd ever monetize it - until they figured out ads.
Michael Olgren  @Reply  
      
10 months ago
Ed Zitron covers that. How do you put ads in AI? Just listened to him talking about Sora, and how ppl trash it in comments under its output. However- not sure I totally agree w Ed there because I think the general public is beginning to be ok with crappy production. Just look at Skibity Toilet.
Richard Rost OP  @Reply  
          
10 months ago
There's no question that production values are definitely suffering with the ubiquity of AI-generated slop. However, as far as putting ads in AI, I will say that I've had more than a couple of people sign up for my lessons and have told me that GPT recommended my website. So it's just like search was in the early days, where it's mostly organic for now, but I can see companies in the future paying to have their services recommended by AI.
Kevin Robertson  @Reply  
          
10 months ago
OpenAI is apparently exploring a "Sign in with ChatGPT" feature, which will let users access websites with their ChatGPT accounts, similar to Google or Facebook logins.

https://aigptjournal.com/news-ai/sign-in-with-chatgpt/
Richard Rost OP  @Reply  
          
10 months ago
Too many sites doing this now. Ugh.
Michael Olgren  @Reply  
      
10 months ago
Giving your user name and password to an AI- what could go wrong? 😂🤣
Richard Rost OP  @Reply  
          
10 months ago
Michael you don't have to do that if you want. I picture having an AI built into my database where I can say "make me a reminder for tomorrow at 3pm to email Michael about that thing we talked about last week." And it would just do it. Like an AI database assistant. Think of it like Alexa for Access. :)
Matt Hall  @Reply  
          
10 months ago
I would be super interested in this, especially if it was a local agent.
Kevin Yip  @Reply  
     
9 months ago
One task Access may need AI for is address verification.  Street addresses have highly irregular structures due to their often free-form nature.  For instance, these two addresses:

4978 N. University Dr., Lauderhill, FL 33351
4978 North University Drive, Fort Lauderdale, FL 33351-2468

are in fact one and the same, yet they have different street addresses, cities, and zips.  This can trip up traditional database searches.  We need some kind of AI technology, just like what we see in Google searches, to get accurate info.

Anyone who has managed an address database (like I have) knows that it's difficult to catch user entry errors such as duplicate addresses (like the above example), incorrect zip codes, etc.  Incorporating AI into your data entry application could fix all that.
Richard Rost OP  @Reply  
          
9 months ago
Kevin excellent idea for a lesson.
Donald Blackwell  @Reply  
       
9 months ago
Kevin Yeah, one of the things I put time into for my biggest project was just U.S. Zip Codes. I've thought about breaking it down further for addresses, but nothing I"m doing needs it so it really would be overkill for now. But it jumps straight from the address field to zip code and then when that's entered, it gives a list of valid cities to choose from for that zip code. My next step on that front is adding in Canada post codes but it's not a priority yet.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Captain's Log.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 8/7/2026 11:28:26 PM. PLT: 0s