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

The job I want uses Microsoft Access for data management, which uses Visual Basic for most of it's higher level functions, at least that's what I've been told.





rob05c  ·  3346 days ago  ·  link  ·  

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.

OftenBen  ·  3345 days ago  ·  link  ·  

Whose awesome?

You're awesome!