Access Database Tutorial

Using a  Microsoft Access  database provides a rich set of tools and features that users at all levels tend to chug away entering data, running reports and build new objects and give little time (if any) to some basic housekeeping including the very basics of backing up database files. There are various strategies and methods that can be applied to your  Microsoft Access   database and this blog post will highlight some of the options for you. Backing up your database should be practiced for obvious reasons, but this should also be applied with good failsafe measures too when restoring or recovering lost or corrupted data sets (which can happen from time to time). Is there a high-level and technical skill required here? Of course not, it just needs a good plan, applying some common sense and implement simple strategies – whether you are a large corporation or small medium sized business! Take from the following options below and even considered using multip...

Microsoft Access Database : The mindset of the VBA programmer From my new VBA book due out soon, here’s an extract about the mindset of the  Microsoft Access  database VBA programmer… We need to start by establishing a frame of reference as to what we should expect when we are writing VBA code. Consider the scenario where you command a child to “ open the door .” Think about all the individual actions that it takes to accomplish that one statement. The child has to approach the door, align the hand with the door knob, move the hand and grasp it around the door knob, and then twist and pull the door knob while swinging the arm in an arc motion. We don’t have to command each specific step, and indeed life would be very tedious if we constantly had to issue commands at such a micro level of detail. However, somewhere along the line, the child had to learn what it meant and all the steps in the process to open a door. The child didn’t have to be told for each step and pr...