In Microsoft Access 2010 one of the new features is to save data as PDF format files. You can also do this by using Microsoft Access macros. Click on the ‘Create’ tab. Click on the macro button on the top right hand side. At the right of the screen you will see a window for the [...]
An MS Access macro is a great tool for automating our databases. We can use Microsoft Access macro actions for many tasks. In this demonstration I am going to open a report by using a macro. The MS Access macro designer has three main columns 1. Macro Name 2. Action 3. Comment Enter the name [...]
One should always use the right tool for the right job. If you want to store large volumes of data and have many users then think if Microsoft Access databases are the best way to go. Microsoft Access databases tend to be better suited to small systems with around ten or less users. For anything [...]
A database is a collection of information. A Microsoft Access database provides a mechanism for storing, retrieving and manipulating that information.
When entering data one can occasionally misspell a word or two. We are all used to having a spell checker at hand when typing a Word document for instance. Why should a spell check be limited to Word documents? Surely it would be of benefit if we could incorporate something similar in an Access database. [...]
In today’s ever changing world it is important a business has the correct tools to improve efficiency. If you are a small to medium sized business you may find you are not being as productive in some areas as you would like. There are many aspects of a business that can be automated…..it could be [...]
Over the years MS Access has not changed much in terms of it’s interface and the basic building blocks it contains. I started off using Access version 2. This was a good version in many respects, but was prone to being unstable when handling large amounts of data or users. The Jet database engine has [...]
Microsoft Access is alive and kicking and is available in it’s latest incarnation “Access 2007″. It is unclear just how many companies have switched to it or Office 2007 in general, but I suspect the take up is slow. Personally I am not keen on Access 2007 because it seems too much of a radical [...]