|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
|
Access AI Builder Write Custom SQL and VBA Code With AI Assistance Welcome to the future of database management with the revolutionary Access AI Builder. This cutting-edge template is a game-changer for both SQL / VBA experts and beginners alike. Imagine the ease of interacting with your database using simple, everyday English, and having an intelligent AI seamlessly translate your needs into complex SQL queries and/or VBA code. Whether you're looking to quickly generate reports, streamline data management, or empower your end-users with the ability to query databases without SQL knowledge, the Access AI Builder is your solution. This tool not only simplifies your workflow but also opens up a world of possibilities for efficient and effective database interaction. Get ready to transform the way you interact with your data, making database management more intuitive and accessible than ever before. New!
Videos
PrerequisitesThis is a developer-level template; however, one does not have to be an advanced developer to utilize it. If your sole intention is to employ this database for SQL generation and you do not aspire to become a developer, that is perfectly fine. You will simply need to correctly place the API key, which is shown in the Developer Guide video. Nevertheless, should you prefer to use this template as is, merely as a tool for SQL writing, you may do so. If your objective is to augment your databases and introduce additional functionality, the choice is entirely yours. You hold the power to unleash the full potential of this code, with the sky representing the only limit. Please note that you will need to acquire an API key from OpenAI. If you are attempting to integrate this into one of your existing databases, you should have a good, firm understanding of Microsoft Access VBA. This would be when I would consider a Developer Level project. If you are a beginner at Microsoft Access, it may be difficult for you. You can use this template "as is" by just dropping it into an existing database. But if you try to make changes to it or integrate it more deeply into your system, you're going to need advanced VBA knowledge. Sample DatabaseUnlike the majority of my templates, a sample for this particular database is unavailable due to the necessity of a paid API key for its functionality. However, I kindly recommend that you refer to the freely accessible TechHelp videos I have provided above. By following the instructions outlined in those videos and constructing the database independently, you will have the opportunity to secure an API key from OpenAI. That will give you a good indication for how well AI works with Access. This template just adds additional SQL functionality. Full Developer DatabaseOnce you have purchased the full developer database template, and obtained your OpenAI API key, you may come back to this page and download the full template. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit Access 2007 or higher. Be sure to watch the Developer Explainer Video (above).
Purchase TemplatePlease be sure to read the Before You Purchase section below before buying this template.
Features
Updates
In the first release of the innovative Access AI Query Builder, you'll discover the power of conversing with your database in plain English. This tool remarkably translates your spoken requests, like querying customers who are late on payments, into precise SQL. It's not just about simplicity but also about sophistication, handling complex queries with ease. Whether you're saving these queries, running reports, or performing custom database tasks, the Access AI Query Builder is designed to make SQL accessible to all, from database professionals to end-users with no SQL background.
The real magic of this tool lies in its ability to handle varied and complex database interactions. Demonstrated through examples, the Access AI Query Builder effortlessly deals with different scenarios – from simple customer queries to more intricate requests involving multiple tables like customers, contacts, orders, and details. The tool is not just about fetching data; it's also capable of executing action queries. A standout feature is its precision in merging tables and executing right joins, a typically challenging aspect in SQL. The results are not only accurate but also instantaneous, showcasing the AI's advanced capabilities and the tool's efficiency.
Wrapping up, the Access AI Query Builder is more than just a query tool; it's a comprehensive solution for modern database management. It's built for today's needs, requiring an OpenAI paid account and leveraging ChatGPT for processing requests. The package comes with an instructional video and extended features for developers, including setting up multiple AI bots for varied responses. This tool is a testament to the fusion of AI with database technology, simplifying SQL queries and opening up new possibilities for efficient and effective data management.
Sample CommandsHere are some sample commands I gave the AI Query Builder and it was able to successfully return good SQL. I encourage you to try lots of new ideas, and see what you can come up with. And remember, the AI isn't always 100% accurate, so double-check the results and if it doesn't seem right, just send the same command again.
Before You PurchaseA few important notes before you purchase this template:
Notes After Purchase
Possible Future Upgrade IdeasIf you have ideas on things you'd like to see added to this database, please post a comment below. If a particular feature garners enough interest or if I consider it to be a particularly good idea, then I will definitely consider adding it. Some ideas already suggested:
For internal use only. This template does NOT come with a royalty-free license. You may only customize the template for your business needs and for use within your organization at one location ONLY. You may not resell or distribute any form of this template to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a product you are reselling. Additional licenses are required if you plan on using this template with more than ten (10) employees or in multiple locations within your organization. Please keep in mind that most of my template databases are not designed to be finished products that are ready to go in a working environment. My templates are meant as starting points for you to customize for yourself so you don't have to reinvent the wheel. This requires that you have a basic understanding of Microsoft Access development. To work on most of my databases you should have completed my Access Beginner series and the first couple levels of my Expert series at a minimum. Most of my databases require knowledge of SQL and VBA as well. Keep in mind that most of my templates are not like off-the-shelf software. They're starting points for developers to be able to modify and use as their own. It really is going to be in your benefit to watch all of the prerequisite videos so you understand the database and how it works moving forward. This is not like QuickBooks where you just install it and use it. My templates are mostly designed for people who already have an understanding of how Microsoft Access works. If you would like to discuss customizing this template for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Developer Network. Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. If you have a problem with one of my databases, I will only support the unmodified database exactly as it's downloaded from my site. If you have modified it in any way, it may not be something I can help you with. You can post in the Forums, and I may be able to help you, but if the issue doesn't exist in my unmodified database, it's not something I can support. Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below. Keywordsmicrosoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #template, Access AI Query Builder, Microsoft Access SQL, SQL Query Automation, Database Management AI, Easy SQL Queries, AI-Powered Database Tool, Microsoft Access Tutorial, Natural Language SQL Conversion, User-Friendly SQL Interface, SQL Query Builder Software, Automated SQL Generation, Advanced SQL Queries, No-Code SQL Solutions, AI Database Management, Microsoft Access Enhancements, Simplifying SQL with AI, Access Database AI Integration, Efficient SQL Management, AI SQL Query Translation, Non-Technical SQL Queries
IntroIn this video, you will learn about the Access AI Query Builder template for Microsoft Access, which lets you generate complex SQL queries simply by describing what you want in plain English. I'll show real examples of creating and running queries using AI, handling joins across multiple tables, working with different types of queries such as select and update, and discuss how this tool can help both developers and end users interact with their Access databases without manually writing SQL. I'll also cover how the template communicates with OpenAI and what you need to set up for it to work.TranscriptNever write another line of SQL again, unless you want to, of course.Hey folks, this is Richard Rost with Access Learning Zone. I just released a new template I call the Access AI Query Builder. Basically, what it does is allow you to talk to the database in plain English. Say, "I want a list of customers who are 30 days late with their payments," and the AI will translate that into SQL for your database. And that's it. You can save it as a query, you can run reports on it, you can do whatever you want. This is a great tool for you to never have to write SQL again. You can even use it for your end users so they can talk to the database in English without having to know SQL. Let's take a look at some samples in action. Give me a list of customers sorted by last name, first name. Ready? Send to OpenAI, takes a second. Boom, comes right back with your SQL, there it is. It knows the field names and the table names in your database. You click the View Results button, and there you go. There's your query, nice and sorted for you. It saves it in your database as tempQ. There it is right there. So you can rename it and save it if you want to keep it as a query. Want something a little more complex? How about customers from Florida with a family size of at least three people? Ready? Go, there it is. There's your SQL. View the results. And it looks like just one person, the Anitroy from Florida with a family size of four. How about something a little more complex? Now, this database, if you're familiar with my templates, has contacts, customers, orders, and order details in it. So how about if we use two tables, customers and contacts? Let's say, "How about customers that have been contacted this past week?" That has to merge together the customer and contacts tables. And there it is, joins it all together. Joins are always the toughest thing in writing queries. Run the query. There you go, looks like there's three people. If you check the data, it's correct. I don't see the last contact date on here though. Let's tell the AI to add that. "Be sure to include the date last contacted." And go, let's see what it gives us. I can see right here it added contactT.contactdate to the SQL. And there we go, it's perfect. It honestly still surprises me how good the AI is getting. Yes, today's date is December 4th, 2023, so these are all people that have been contacted this week. Let's do something with three tables. Now we've got orders and order details. The details are the line items. So, in order to do that, if we want customers with their order totals, it's going to have to join three tables together. Let's see if we can do that. How about if we say, "A list of customers with unpaid orders and what their total amount unpaid is?" Let's see what it gives us. There we go, pretty complex join. Let's see what the results look like. There you go. Yes, I checked, that is correct. If you look at me, for example, I should have a $360 unpaid order. Let's take a peek: customer form, go to orders. That one's paid, and that one's not paid. There you go. It works. I've tested these extensively; all the data I'm showing you is valid. How about action queries? Now, be careful with these. Add $50 to the credit limits for every customer in Florida. Again, let's take a look. I've got a credit limit of $5100. Let's run it. Actually, we've got to get the SQL first. Update customerT set creditlimit = creditlimit + 50 where state = "Florida". Run it. It says done. Let's take a look. Look at that, 5150. Pretty cool, huh? Again, we're talking to the database in English. The AI translates it into SQL, and then you can run it. You can use this as a tool for yourself. You can give it to your end users if you want. I'd recommend just giving them the select queries. Don't let them have it with action queries. But as you can see, it's a fantastic tool. If you don't want to have to learn SQL or write SQL yourself, you can just tell the database what you want. Now, in order to use this template, you will have to have a paid account with OpenAI. Basically, I'm using ChatGPT to get the information. We're sending the English request to ChatGPT, and it's returning the SQL to us. I cover how to set all that up. In this video, which is a free video, here's the link. You can go watch it. It's on my website and my YouTube channel. Before you buy my template, make sure you've got this working first, because this is required. Also, as part of the template package, I will include part two and the extended cut, which is normally for my members, showing you how to set up multiple bots. You can have a friendly bot, you can have a bot that replies like Mr. Spock, you can do spelling and grammar only, or like we're going to do here. That's basically what my template does. There's some extra stuff and some additional coding I had to write. I walk you through it in the explainer video for the template. A little something extra for the developers. But that's it. That's the AI Query Builder template from Access Learning Zone. You can find more information here or purchase your copy at this address right there. If you have any questions, feel free to post them down below or contact me on my website. Thanks for watching, and I'll see you next time. Bye. QuizQ1. What is the main purpose of the Access AI Query Builder template?A. To convert plain English queries into SQL for your database B. To backup your Access database automatically C. To create database diagrams D. To generate Excel reports from Access Q2. Who can use the AI Query Builder template to interact with the database? A. Only experienced developers B. Only end users with SQL knowledge C. Both developers and end users without SQL knowledge D. Only Microsoft certified professionals Q3. What feature allows the AI Query Builder to generate SQL accurately specific to your database? A. It stores queries in Excel spreadsheets B. It knows the field names and table names in your database C. It uses only a fixed set of generic table names D. It only returns static SQL statements Q4. What happens after you send a plain English request to the AI Query Builder? A. It displays unrelated data from the database B. It ignores the request and asks for SQL directly C. It generates the SQL, lets you view results, and save the query D. It emails the results to your inbox Q5. What does the AI Query Builder use behind the scenes to process English requests? A. Google Translate API B. A built-in Access macro C. ChatGPT from OpenAI D. A local keyword matching script Q6. Why should you be careful with action queries in the AI Query Builder? A. They cannot be undone and modify data in the database B. They delete all tables automatically C. They slow down the database performance D. They produce only select queries Q7. How can you share the AI Query Builder functionality with your end users safely? A. Only provide select query features to end users B. Allow full access to action queries for all users C. Hide the template from all users but admins D. Only allow access during office hours Q8. What is saved in your database when you generate a query with the AI Query Builder? A. The query is saved as tempQ, which you can rename if desired B. The query overwrites the database structure C. No query is saved automatically D. The query is sent to an external database Q9. What do you need to use the AI Query Builder template? A. A Microsoft Excel license B. An account with OpenAI/ChatGPT C. A dedicated Access server D. A Gmail account Q10. What additional feature is included in the extended version of the template as a bonus for developers? A. Creating custom forms automatically B. Setting up multiple AI bots with different personalities or functions C. Exporting queries to PDF directly D. Integrating with PowerPoint presentations Answers: 1-A; 2-C; 3-B; 4-C; 5-C; 6-A; 7-A; 8-A; 9-B; 10-B DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from Access Learning Zone introduces my new template called the Access AI Query Builder. This tool allows you to interact with your Access database using everyday English instead of writing SQL queries. For example, you can simply type a request like, "I want a list of customers who are 30 days late with their payments," and the AI converts your plain English into the appropriate SQL statement for your database. Once you have the SQL, you can save it as a query, run reports, or use the results however you like.This is designed not just for developers, but also for end users who may not be familiar with SQL, allowing them to get the information they need from the database just by asking in plain English. Let me give you some examples to show how it works. If you want a list of customers sorted by last name and first name, you simply tell the AI what you want, and it returns the correct SQL statement. The AI is smart enough to recognize your field names and table names, and you get the results, nicely sorted. The query is saved as tempQ in your database, and you have the option to rename or save it for future use. The tool also handles more complicated queries. Suppose you need a list of customers from Florida with a family size of at least three. The AI quickly generates the SQL and displays the correct results, as in this case, with a customer named Anitroy from Florida whose family size is four. The template handles relational queries involving multiple tables as well. If your database includes separate tables for customers and contacts, for instance, you might want to find customers who have been contacted in the past week. The AI automatically creates the necessary join between the customer and contacts tables, something that many people find particularly challenging with SQL. If you want to refine the results further, for example by including the date of last contact, just ask in English and the tool updates the SQL accordingly. You can also work with even more complex queries that involve three tables, such as customers, orders, and order details. If you request a list of customers with unpaid orders and the total unpaid amount, the AI builds a complex join and calculates the unpaid balance for each customer, verifying your data and confirming the results. Action queries are also supported, though these should be used with care. For instance, if you want to increase the credit limit of every customer in Florida by $50, you simply describe the action in English. The AI builds the correct SQL UPDATE statement, executes it, and you can verify the updated values in your data. This template provides a powerful tool for both developers and end users. You can use it for yourself or give select capabilities (such as select queries) to your users, while restricting action queries for safety. The main idea is that you don't need to know or write SQL if you don't want to--just tell the database what you need. To use this template, you will need a paid OpenAI account, as the solution uses ChatGPT to process your requests and translate them into SQL for your database. I will walk you through the setup process to ensure you can get started. I offer a free setup video that explains how to make sure everything is working before you purchase the template, and you can find it on my website and YouTube channel. It's important to make sure the system is functioning properly before buying the product. When you purchase the template, you also receive access to additional materials, including part two and an extended cut (normally reserved for members). These resources will show you how to set up multiple AI bots, so you can customize the interaction—such as creating a friendly bot, a Spock-like bot, or one focused on spelling and grammar corrections. The template includes some extra features and custom coding useful for developers, all of which I explain in detail in the video guide that comes with the product. To sum up, the Access AI Query Builder template is a powerful new tool from Access Learning Zone that lets you interact with your Access database in English, without having to write SQL. You can find all the details and purchase options on my website. If you have any questions, feel free to reach out to me on the site or in the comments. You can watch the complete video tutorial, with detailed step-by-step instructions, on my website at the link below. Live long and prosper, my friends. Topic ListUsing natural language to generate SQL queriesViewing query results instantly in Access Saving and renaming generated queries Creating queries with filters on specific fields Generating queries that join multiple tables Adding specific fields to query results Building queries with aggregate calculations Creating update action queries via plain English Integrating OpenAI (ChatGPT) with Access Setting up Access to communicate with OpenAI Demonstrating real-world query examples in Access |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| |||
| Keywords: templates access Access AI Builder Access AI Query Builder, Microsoft Access SQL, SQL Query Automation, Database Management AI, Easy SQL Queries, AI-Powered Database Tool, Microsoft Access Tutorial, Natural Language SQL Conversion Page Tag: whatsnew PermaLink Microsoft Access AI Builder |
