I have been working with Access for a couple of years now and while I have gotten good at deconstructing and reworking existing database to get it to do what I want I really want to move to the next level and be able to create dynamic useful databases for anything I can think of. The question is where do I start? There is so much info online that it can be overwhelming.
Here are several paths:
- Theory of Relational Database, the Relational Model, the Normal Forms, Database Normalization, the Set Theory.
- The SQL Language and its Access variant.
- Object-Oriented Programming, Visual Basic/VBA Programming, Algorithms.
- DAO Library Object Model, ADO Library Object Model.
- Programming with OLE2/COM/COM+ objects and servers.
- Ergonomy in Windows applications.