In the modern world, our daily activities follow and leave a rich trail of electronic data from e-mail and text messages to credit card transactions and medical records. At its simplest, the data could be an address book or contact list stored in a text file while more complex information such as a store’s inventory…
All posts in Microsoft Access
Data Analysis with Microsoft Access
Tackling the Data One of the strengths of Microsoft Access is its ability to import and link to data from different sources. With Access you can also query and report on the data in ways that a spreadsheet program like Excel doesn’t readily provide. This can come in handy as part of a database application…
Removing Duplicate Records in Microsoft Access
Occasionally, you might have a table in Access that contains duplicate records. Maybe it was imported from one or more sources or perhaps it was not setup with the necessary key to ensure unique records. Whatever the reason, now you want to make sure that the records in the table are unique. Fortunately, Access offers…
Data Analysis with Microsoft Access
One of the strengths of Access is its ability to import and link to data from different sources. Excel does this too but with Access you can go on to query and report on the data in ways that Excel doesn’t readily provide. This can come in handy as part of an application but it’s…
Microsoft Access for Beginners / JobSearch 2010
I’ve started to see some sales of the eBook version of “Microsoft Access for Beginners” and was happy to hear from one of the readers today, despite the fact that he was reporting a problem … It seems there was an issue with the Access 2007 / 2010 version of the program that I believe…
Bringing things up to date …
Every so often, I remember that I have a blog attached to the site and I make new promises to myself to keep it up to date but it doesn’t seem to happen that often. 2011 was a busy year for me which was one reason I didn’t update the blog much. It’s easier to…
Switching between Access 2010 windows
A visitor to the site asked about using ALT-TAB to switch between open Access windows. This refers to the “Windows in Taskbar” feature which was available in Access prior to Access 2007. You could set Access to display a button for every open Access window on the Windows Task Bar and use the standard ALT-TAB…
JobSearch 2010 Update
JobSeach 2010 is now out of beta testing and version 1.01 is available for download. If you’re looking for a job or know someone who is, this is a great tool that can help you maximize your search. JobSearch 2010 includes contact management, lead tracking and flexible reporting all in one program … and it’s…
New Article: Data Analysis with Microsoft Access
Most of the articles I’ve written on Microsoft Access have been about designing database applications that are meant for regular use. One of the strengths of Access, however, is its ability to import and link to data from different sources. Excel does this too but with Access you can go on to query and report…
JobSearch 2010 – Personal Job Search Assistant
JobSearch 2010 is a personal job search organizer that enables you to manage all of your information in one easy to use program. With this tool, you can maintain complete detail on each lead and have it all instantly available at the click of a mouse or offline through one of the available reports. Never…