I have been able to develop a single table DataBase for my music recordings using Access 2010 and so far only using SQL. This DataBase is a development from one I started nearly 20 years ago using FoxPro. I have somehow managed to use a many-to-many relationship twice that works in the DataBase.

For Foxpro I needed to use Visual Basic. I may decide for interest and for greater flexibility to construct in parallel the same SQL DataBase that I now have but using VBA.

Meanwhile it would be helpful to add in some Modules to my SQL version. For example a key press (say F5)to toggle between Form view and Datasheet view of the current Form with provision for currently not being on a Form. F5 for Form view and F6 for datasheet view would be just as good if a bit less neat.

Haveing such a module that works could start me off on my journey into VBA.