a thoughtful web.
Good ideas and conversation. No ads, no tracking.   Login or Take a Tour!
comment
rob05c  ·  3586 days ago  ·  link  ·    ·  parent  ·  post: Anyone know Visual Basic?

Ah, you want Visual Basic for Applications, or VBA. The VBA language is similar to VB, but it's designed for working within programs, like Microsoft Access and Microsoft Excel. Here's an Access VBA book and Here's a tutorial.

I definitely recommend looking into specifically VBA. It's more directly applicable to what you want to do in Access.

That said, Access supports a limited version of SQL, which I highly recommend over VBA, if at all possible. SQL will get you much farther, both in Access and the rest of the database world.

Here's a tutorial on SQL in Access. Though any generic SQL tutorial should be fine. You just have to be aware Access doesn't have some of the more complex SQL commands.

Also, if you're writing an external program to get data from Access, most programming languages have Access libraries. Here's a Python ODBC library (ODBC can talk to Access), and here's a C# tutorial.