Showing posts with label Access. Show all posts
Showing posts with label Access. Show all posts

Friday, 30 August 2013

Another video - Splitting an Access database

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.

Tuesday, 13 August 2013

Almost my first video on Youtube

Sometimes things don't go quite as I intend. A little while ago, someone approached me with a potential project. Unfortunately I was too busy at the time to take it on.

The idea had tickled my fancy. It bubbled away in the back of my mind and as I had odd moments I created bits of it, as what I would describe as a proof of concept. It was a useful exercise in that it has reminded me of a few things, taught me some things about what Microsoft Access is good at and some things it is not so good at. Inevitably, there are some things I would do differently if I did it again. That's all right, because after all it was only a proof of concept, and there was no real input in the form of "requirements" anyway.

Having produced the thing, then I wanted to show it to an acquaintance. I messed about with a few things and after a couple of iterations, produced this:
SOPAG - A simple Access Application

Having produced the video, and decided to write a "business related blog" it seemed appropriate to share it here.

I wouldn't claim either SOPAG, or the video are marvelous, but I've learned a lot from both of them. In fact, I have set up a little project to take them both a little further.

But that is for the next instalment!