It’s very strange how Microsoft Access database systems and processes constantly repeat themselves and once again I’m working on some VBA code to communicate with Microsoft Outlook (Email and contact management system). Here you can see a quick video of such a simple but effective utility I offer (for only the cost of a couple of pints of beer!) – check it out… Microsoft Access Database Tutorial VBA Code Task Tool To Outlook The Task Tool utility was built to demonstrate […]
Tag Archives: ms access database
With the release of Access 2010 and better still, version 2013, publishing your Microsoft Access database on the web couldn’t be easier. Check out this short three and half minute video tutorial showing how you link and synchronise between SharePoint (online Access Services) and your ACCDB database file within Microsoft Access. How to Publish An Access Database To SharePoint – MS Access On The Web Just a few points to be aware of when considering migrating your database live on […]
I often see many poorly designed Access forms that just make it hard and clumsy to navigate and use. One particular element (and there are many) is the lack of area space for a text box control like comments or notes that require some intervention in order to edit the content properly. Check out this Microsoft Access tutorial provided by ‘599CD Computer Training’ who provide some good and free video tutorials about Microsoft Access databases. On this occasion, it’s the […]
Oh the paperwork! Having spent a lot of time designing, developing and implementing your MS Access database you really should consider the housekeeping – so how to document a database? You may feel that this task could be avoided altogether but what happens if: You are no longer wanted and someone else inherits your baby? You become all too important (promotion) and someone else needs to take over the responsibility? The business has grown and you don’t have the time […]
I wrote an article last year of my 10 key properties to Access form design which is just the beginning to mastering an ms access database that help to control and improve the look and feel to your application. I’ve decided to add it here in my blog as this has recently come back as a discussion in a recent training course that proved very useful to front-end database designers within this powerful application So here’s it is… Access Form Design: Discover […]
By default, when installing Microsoft Access 64 bit it in fact installs the 32 bit version and you have to choose the right version making sure you have the right operating system The following link explains more of the main differences between Microsoft Access 64 bit and 32 bit versions Choose the 32-bit or 64-bit version of Microsoft Office Keep upto date with my Facebook page and why not ‘Like’ it too.