I asked ChatGPT to give me a list of ideas for articles about Microsoft Access, just to see if any of them would be cool for me to write.
It gave me a list of 10 articles. One of them was "10 Advanced Microsoft Access Techniques to Streamline Your Workflow." OK. Interesting.
So I asked ChatGPT what 10 techniques it would recommend. Most of them were very vague, but one of them came back as: "Use the Data Collection app: The Data Collection app is a new feature in Access that allows you to easily collect data from multiple users using a web browser. You can use it to create surveys, quizzes, and other forms that can be completed online."
I then told GPT: "the data collection app is no longer available in microsoft access."
It responded with: "You are correct! The Data Collection app was a feature that was introduced in Access 2016, but it has since been removed in more recent versions of the software. I apologize for the error in my previous message. Thank you for bringing this to my attention."
Now, I'm curious to know whether or not it will REMEMBER that correction in the future. It may remember it if I log on and ask again, but I wonder if it will remember that for everyone else.
So... if you feel like playing this game with me, log on to ChatGPT and ask it: "What are 10 Advanced Microsoft Access Techniques to Streamline Your Workflow?"
Let me know what it says, and if the data collection app is mentioned. :)
Kim Nielsen
@Reply 3 years ago
Hi Ross;
I tried your question on chatGPT and this is the result;
1. Macros: Automate repetitive tasks with macros and reduce manual data entry.
2. Relationships: Create relationships between tables to improve data integrity and reduce duplicates.
3. Queries: Use complex queries to extract specific data from multiple tables.
4. Forms: Create custom forms to enter and edit data with ease.
5. Reports: Design professional reports to summarize data and make it easier to analyze.
6. Subforms: Display related data in a form by adding subforms.
7. Pivot Tables: Create interactive pivot tables to quickly summarize data and highlight trends.
8. VBA (Visual Basic for Applications): Write code to automate complex tasks, add custom functionality, and manipulate data.
9. Modules: Store reusable code in modules and improve code reuse.
10. Data Access Pages: Publish Access data to the web and make it accessible to a wider audience.
I also asked it to write a VBA code to compare a serial number from one table to another table and find the last date on it and this what it returned;
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim lastDate As Date
Set db = CurrentDb
Set rs = db.OpenRecordset("SELECT MAX(Date) AS lastDate FROM FillTable WHERE SerialNumber = '" & Me.serialNumber & "'")
If Not (rs.EOF And rs.BOF) Then
lastDate = rs!lastDate
End If
rs.Close
Set rs = Nothing
Set db = Nothing
Me.lastDate = lastDate
What are your thoughts, I havent tried the code yet in my database yet.
Thanks
It's not bad, but you can see it's out of date. Access hasn't had PivotTables or Data Access Pages since like 2013. The definition of Modules is a bit weak. It's comparison code is a little weird. I see what it's doing, but I would have approached it differently. In any case, this is still pretty solid. In another 5 years, AI is going to be scary good.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
ChatGPT 15 Names.
