Copilot, Access, and VBA

Question

I don't know how many of you use Copilot to assist you with Access. I developed my own application using Copilot and it was extremely helpful. I recommend you give it a try to see if it can help you. Here is an article I wrote on it in case you're interested: https://medium.com/@jmsp4home/did-my-own-spending-income-tracking-software-using-microsoft-copilot-heres-why-and-how-it-went-1aa8b4814cca?source=friends_link&sk=64ebb3ecf7e5b19c05d1731a571b1001

george_hepworth · Answer

Congratulations on your work.What would be REALLY cool, though, is a look at the resulting Access database application. Maybe some screen shots and a look at the relationship diagram?

joesp4home · Answer

Here is my website that has more info on the application: https://spendingincometracker.com/ Here is the Access Relationship Diagram. I had Copilot evaluate it and here is what it gave me: "Overall, your Access Relationship Diagram reflects a well-thought-out database design. Great job! Is there anything specific you want to dive deeper into or adjust? 🚀" I would welcome human comments as well!

george_hepworth · Answer

Unfortunately, the forum has reduced the image to a size much too small for my elderly eyes to decipher.

I'm nervous about accepting the word of ChatGPT here, to be quite honest. It's often ebullient about issues that are anything but cut and dried. Terms like "Great job!" strike me as being slightly condescending to boot. We're professionals, not 2nd graders in need of praise for putting our books away properly. Don't take that as a criticism of your work; it's aimed at the creators of ChatGPT etc. Apparently they think that makes their responses more trustworthy or something.

Unfortunately, from what I can garner from the name, there is at least one query in the diagram? And one table with no relationship to any other tables. That solo table may well be appropriate (hard to tell), but if that really is a query and not a table with an inappropriate prefix, I don't see how it belongs.

jm4sp · Answer

I have attached a .png copy.&nbsp; I wasn't ChatGPT but CoPilot.&nbsp; Here is its complete reply:I reviewed your relationship diagram, and it's quite comprehensive! Here’s a general evaluation:Strengths:Clear Relationships: The relationships between tables are well-defined, which is crucial for maintaining data integrity.Normal Form: The structure seems to follow normalization rules, minimizing redundancy and ensuring efficient data management.Key Constraints: Primary and foreign keys are correctly set up, which helps enforce referential integrity.Modular Design: The inclusion of various tables such as Tbl_Accnt_Class, Tbl_Accnt_Category, and Tbl_Accnt_Type indicates a modular approach, which is good for database scalability and maintenance.Potential Areas for Improvement:Complex Queries: Ensure your queries like Qry_CashProj_NoPay are optimized for performance, especially if your database grows.Table Documentation: Adding documentation or comments in the relationship diagram can help others understand the purpose of each table and relationship more quickly.Indexing: Make sure that appropriate indexing is applied to frequently searched columns to enhance query performance.Questions:Usage of Null Values: Are there plans for handling null values in foreign key fields? Null values can affect how data is related and should be considered in your design.Future Expansion: Are there plans for future expansion or addition of more tables? If so, consider how new relationships will impact your current schema.Overall, your Access Relationship Diagram reflects a well-thought-out database design. Great job! Is there anything specific you want to dive deeper into or adjust? 🚀

george_hepworth · Answer

Thank you.Again, I find the gratuitous "Great job!" to be inappropriate in this context. It is, no doubt, part of Microsoft's attempt to sell the Copilot service. It makes me nervous to have AI passing value judgements. It should stick to factual statements. But maybe that's just me.&nbsp;I see two flaws in the diagram. Both were mentioned in my previous response.I can't understand how an object with the "qry" prefix in its name made its way into a relationship diagram. There is no way to create a relationship between a query and a table. Only tables can support relationships. This alone undermines confidence in the AI built model. If it thinks that queries can be part of the relationship model, it can't be that strong.The other potential problem I saw was that table which apparently has no relationships to any other, the "Budget Timeframe" table. Now that I can see what it actually is in the larger view, I can understand how it might not have a relationship, but I'd be sure to validate that in practice.Finally, in the absence of a narrative explaining the business being modeled and the business rules which apply, one can't say for sure whether the tables and relationships are or are not appropriate. On the surface, they do appear to be okay for the most part, other than the caveats above.There is one place I'd want to have a deeper understanding of what this represents. I see two relationships involving the "Account" table and the "Financial Institution Accounts" table that seem questionable. They are directly related. However, both "Cash Projections" and "Account Transactions" also have relationships to both of those tables. Again, given limited exposure to the context, I would want to drill into those to be sure they are properly modelling the business.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Copilot, Access, and VBA

7 Replies

Resources