top of page
Writer's pictureRobert Hopkins

Coding can be fun, and a pain at the same time too...

Microsoft Access can accomplish a lot with minimal code, thanks to its integrated database platform that includes tools for form design, window development, and report generation. Its flexibility allows for graceful modification of both input and output, though it has some quirks that can make it challenging to navigate—especially if proper documentation is lacking. Without clear guidance, locating specific bits of code within Access can be tricky.


Access uses an object-oriented programming (OOP) approach, which makes handling user-driven events simpler. However, it still has a learning curve. My experience with various versions of Visual Basic (VB3 through VB.NET) helps, as VBA (Visual Basic for Applications) is essentially another form of Visual Basic.


The form layout tool in Access, however, is a bit clunky. Aligning elements like text fields and buttons is cumbersome, and I’m still figuring out how to add objects easily—something that should be more straightforward.


I haven’t yet explored the reporting features, as my main focus right now is on data entry. I'm also interested in understanding how record locking is handled to prevent conflicts, which is another aspect I’ll need to investigate.


Despite the challenges, I’m enjoying learning Access and discovering its capabilities!


11 views

Recent Posts

See All
bottom of page