AI Query Builder 1.1 Update

v1.1 Update: Data Types, Specify Tables & Queries

S M L XL FS | Slo Reg Fast 2x | Bookmark

It's only been a couple of days since I released version 1.0 of my Access AI Query Builder, and I've already received a ton of feedback from those who purchased it. There were a few features they really wanted to see added, so I took the time this morning to include those.

New Features

Data Type Specification: Now, you can tell the AI specific data types, like identifying LastAmount as a currency
Specify Table & Query Inclusion: You can now specify which tables and queries are sent to the AI
Automated Field and Table Recognition: The AI now automatically recognizes field types, table, and query names, enhancing SQL accuracy and minimizing errors.

Learn More

To learn more about this update, visit the Access AI Query Builder page.

Subscribe to AI Query Builder 1.1 Update
Get notifications when this page is updated

Intro

In this video, I will show you the new features added to version 1.1 of the Access AI Query Builder for Microsoft Access. We'll look at how you can now specify data types for your fields so the AI can generate more accurate SQL queries, and how you can choose exactly which tables and queries are included when sending information to the AI. I'll also demonstrate the benefit of using helper queries like OrderDetailQ for calculated fields, and walk through a sample scenario to illustrate these improvements.

Transcript

Hey folks, this is Richard Rost with Access Learning Zone.

It's only been a couple of days since I released version 1.0 of my Access AI Query Builder, and I've gotten a ton of feedback from the people who purchased it so far. There were a couple of things that they really wanted to see added, so I took the time this morning and added those features.

I added the data types so that now, if you have a field where the AI might not be able to figure out what the data type is, the database will send the data type list to the AI so there's no confusion. For example, if you have a field like Last Amount, you can tell the AI this is a currency value instead of just a number or a text field.

I also added the ability for you to specify which tables and queries to include. You can add queries to the list that will be sent to the AI so it knows what your fields are.

For example, in my tables, I have OrderDetailT, and the order details basically just have the quantity and the unit price, but I don't multiply them together. If you're familiar with my database, I do have a helper query. I have a helper query right here called OrderDetailQ, where it multiplies those together for ExtendedPrice. This makes it so that you don't have to include the order details with each order.

If you're familiar with my TechHelp database, I've got Orders and OrderDetails. In the OrderDetail table, it just stores the quantity and the unit price; there's no math in here. To get the line total, you have to multiply those together, which is why I have this query OrderDetailQ, which basically is all the details from the detail table, but adds this calculated field over here for ExtendedPrice. It's just one less step that the AI has to do.

Now, in my tables to include, you can see it automatically creates this list of tables, and then you can come in here and specify which ones you want to include in what gets sent to the AI so it can consider the field lists. For example, you don't want to send it your BotT table; that's just for this database. You don't want to send it the table lists or the query list because those are the tables that contain the lists of tables and queries to go to the AI. I'm only going to send Contacts, Customers, and OrderT.

Then, in my list of queries to include, you can now send it any queries that might have information the AI could use, like I'm just sending OrderDetailQ. If you have other queries where you do some fancy calculations, you can send those to the AI now as well.

Now, if I come in here and say, "Give me a list of customers with paid orders totaling $1,000 or more," and then send it to the AI, there it goes. There's the SQL; you can see it's using the OrderDetailQ now. If you view your results, there's your list of results.

I did check these. Let's spot-check one of them. Let's go to the customer list. Let's find a Mr. Spock. There you are. You should have a paid order over $1,000. Yep, there you go.

So, there are your updates. If you look at the tables and field list, here it is. You can see each one of them has the type of data after it, CustomerT. I also include the table names now too, so there's no ambiguity. Sometimes it was mixing these up. OrderT.Notes is a memo field. OrderDetailQ.Quantity is a double, and so on. The AI can use that to generate the proper query listing.

There you go. Those are the most requested features so far.

I do have to remind you, every time I make an update, the price goes up. If you've already purchased this, you're good. You're grandfathered in. You can download the update at no extra charge. If you haven't purchased this yet and you're thinking about it, now's the time to do it because every time that version number goes up, the cost goes up as I add more features.

If you want to get it, get it now. Here's the link down here. I'll put a link down below you can click on. If you have any questions or comments, post them down below.

Live long and prosper. I'll see you next time.

Quiz

Q1. What major addition was made to the Access AI Query Builder regarding fields and AI understanding?
A. Color-coding for different table types
B. Sending the data types of each field to the AI
C. Automatic report generation
D. Scheduled backups for query results

Q2. Why is it helpful for the AI to know the data type of a field?
A. It prevents users from editing protected fields
B. It avoids confusion about how fields should be treated in queries
C. It makes the database run faster
D. It lets users sort tables alphabetically

Q3. What new ability was added to decide what the AI can reference when building queries?
A. Locking queries so the AI cannot see them
B. Including or excluding specific tables and queries to send to the AI
C. Automatically hiding sensitive customer information
D. Restricting queries by user permission levels

Q4. What is the purpose of the OrderDetailQ query in the example?
A. To filter out cancelled orders
B. To store text notes about each order
C. To calculate ExtendedPrice by multiplying quantity and unit price
D. To display only orders from the last 30 days

Q5. When sending tables and queries to the AI, why would you exclude tables like BotT?
A. These tables are only for internal system use and are not relevant to query building
B. They contain only numeric data
C. They are too large and slow down the process
D. The AI cannot read tables with special characters

Q6. How does versioning affect pricing for the Access AI Query Builder?
A. Price drops every time a new feature is added
B. The price increases with each version update
C. The software is free for all updates
D. Only yearly subscribers pay for updates

Q7. If you have already purchased the tool, what happens when a new update is released?
A. You have to pay a small fee for the update
B. You must uninstall and reinstall to get the update
C. You can download the update at no extra charge
D. You will lose previous data unless you upgrade

Q8. Why is it important to include the table name with the field when sending information to the AI?
A. To make the database more colorful
B. To avoid ambiguity between fields from different tables
C. To improve sort order in Access
D. To increase file size

Q9. What happens if you send calculated queries (like OrderDetailQ) to the AI?
A. AI ignores calculated queries
B. AI can leverage calculations, making query generation easier
C. AI deletes those queries from your database
D. AI converts all queries to basic tables

Q10. What did Richard encourage viewers to do at the end of the video?
A. Wait for a big sale before purchasing
B. Get the tool soon before the price goes up further
C. Download the free version to test it out
D. Email tech support for a demo

Answers: 1-B; 2-B; 3-B; 4-C; 5-A; 6-B; 7-C; 8-B; 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.

Summary

Today's video from Access Learning Zone focuses on some important updates I have made to the Access AI Query Builder, based on feedback and feature requests from the first group of customers. It has only been a few days since version 1.0 was released, and already I have received suggestions for improvements that could make the tool even more effective and user-friendly.

One of the main features I have added is the ability to include data types for each field. Previously, the AI could sometimes be unsure about the kind of data stored in a particular field, which might cause confusion. Now, the database sends a list of all the data types to the AI. So, for example, if you have a field called Last Amount, you can make it clear to the AI that this is a currency value, rather than just a general number or a text field.

Another significant update is allowing you to specify exactly which tables and queries are included when working with the AI. You can now decide which tables and any helper queries should be sent for processing, ensuring the AI has the correct list of fields. This is especially helpful if you have queries that perform calculations or prepare data that the AI should reference instead of trying to construct those calculations itself.

As an example, let me discuss how this works with the OrderDetailT table in my TechHelp database. The table itself just contains basic data like quantity and unit price. It does not have a total or calculated field for each row. However, I have a helper query called OrderDetailQ that includes a calculated field called ExtendedPrice, which multiplies quantity by unit price. This makes it much easier for the AI to understand and use the actual value needed for things like order totals, without having to rebuild the calculation every time.

Now, when you prepare your list of tables to send to the AI, you can automatically generate a list and then select which ones are relevant. For instance, you might only want to include Contacts, Customers, and OrderT, while excluding tables that are just for internal database management, like BotT or tables that just record which tables should go to the AI. The same applies for queries. If you have helpful queries, like OrderDetailQ, or any others that handle calculations, you can include those as well.

With these enhancements, you can now provide much more targeted and helpful information for the AI to use when generating SQL. For example, you can request a list of customers with paid orders totaling $1,000 or more. The AI will use the included OrderDetailQ query, generate the correct SQL, and produce accurate results.

I also double-checked the returned data, verifying it with sample customers, and confirmed that the results are accurate.

Additionally, when you look at the lists of tables and fields, you will now see data types listed next to each one, making it clear to both you and the AI what each field is designed to hold. Table names have also been included everywhere to prevent any confusion, especially when fields across different tables have the same name.

These features have been requested the most by users so far, and I am glad to make these improvements. Remember, every time I update this tool and add features, the price does go up. If you already purchased it, you are covered and can download the latest version at no extra charge. For those who have not purchased yet, now is the best time to do so, as the price increases with each update.

If you are interested in getting the latest version, you can find a link for more information on my website. If you have any questions or thoughts, feel free to reach out in the comments.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Adding field data types to AI Query Builder

Specifying which tables and queries to include

Including helper queries with calculated fields

Creating a list of tables for AI consideration

Creating a list of queries for AI consideration

Demonstrating AI-generated queries using selected queries

Verifying results from AI-generated SQL queries

Displaying table and field names with data types for AI