Forum Discussion
JM4SP
Nov 06, 2024Copper Contributor
Copilot, Access, and VBA
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
7 Replies
Sort By
- George_HepworthSilver Contributor
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?- JoeSP4HomeCopper Contributor
Here is my website that has more info on the application: $IT 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_HepworthSilver Contributor
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.