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…
All posts in Microsoft Access
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…
Moving beyond Microsoft Access
My latest project came out of left field. Last Saturday, I was going through some archive files and wanted a way to quickly compare all the subfolders and files in two different directories. Not having a program to do it, I decided to write one myself in VB.NET. I decided it would make a good…
Almost there …
I’m managing to get my fingers to keep working despite the latest cold snaps and have finished the first draft of “Programming Microsoft Access”, the series on Visual Basic for Applications that I’ve been working on for the last couple weeks. Now I’m going through the chapters and revising as needed. It’s amazing what you…