When I’m making something I sometimes learn new things. They say “you should never stop learning”. I agree with “them”, whoever they may be.
While I was working on the SOPAG project, I investigated “splitting” the Access database into:
- Logic and presentation, and
- Data (database definitions and data values)
Components. I knew this could be done, but I had not spent much effort on it before.
The splitting itself was a straightforward enough exercise. Most of the work is done by Access itself. However, you might want to confirm that all the decisions it has made are sensible!
I decided to document the results for my own benefit, and then decided to convert a scrappy Powerpoint presentation into something a little more presentable to upload to YouTube.
Here it is: Splitting an Access database
I had fun doing the work to find out how it worked, and fun making the video. I hope you get something from watching it.