New Article: Data Analysis with Microsoft Access

September 2nd, 2010

 

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 on the data in ways that Excel doesn’t readily provide.  This can come in handy as part of an application but it’s also useful for quick analysis of new information.  I found a new example of this the other day when I was looking over the website statistics for Drewslair.com …

Read more in -  “Crunching the Data:  Data Analysis with Microsoft Access

JobSearch 2010 – Your Personal Job Search Assistant

August 28th, 2010


JobSearch 2010 is your personal job search organizer where you can manage all of your information with 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 lose track of an opportunity again or be at a loss for the information you need on an interview with this free software from Drewslair.com.

The beta version of JobSearch 2010 is now available for download and testing.  If you’d like to try it out and give your input on how it works for you, you can see the full details with screenshots at

http://www.drewslair.com/jobsearch2010.shtml

or e-mail beta@drewslair.com with questions.

JobSearch 2010 - Run a more effective job search with this free software from Drewslair.com.

In addition to the free download, I will be starting a series of articles detailing the development process for JobSearch 2010 for those interested in learning more about programming and software development.  So keep checking back because there will be more to come soon!

Looking for Beta Testers

July 5th, 2010

My latest project on Drewslair.com is JobSearch 2010, a program designed to help job seekers organize their searches and more effectively follow-up on opportunities. The program will enable users to gather information on job opportunities, companies, contacts and job search activities in one database where the information can be easily referenced and reported on. The program will feature user-friendly data entry as well as flexible search capabilities and reporting for individual leads and the search as a whole.

With this in mind, I am looking for beta testers who would be interested in evaluating the program both in terms of operation and usability. The ideal testers will fall into one or both of these groups:

  • Job seekers who are fielding multiple leads from different sources, preferably leads requiring multiple activities such as the sending of resumes, follow-up contacts and one or more interviews
  • Usability experts or people with software quality assurance experience

I’m not offering any compensation for testing this application or reporting issues although I do consider it an opportunity for professional networking with people who are willing and able to provide significant input into the design of the program. Once testing is complete and the program is available for download, those who participate in the testing and continue to use the program will receive full and preferential support. As the program is intended for the home user who is looking for work, the finished program will be offerred as a free download.

In order to run and test this program, you must have access to a personal computer on which you are authorized to install software and on which you can perform job search activities. The computer must have the following:

  • 512 MB of RAM
  • 3 GB free hard disk space
  • Windows XP Service Pack 2 or later

If you are interested in participating or would like more information, please contact me at acomeau@drewslair.com.

I can’t believe I forgot that …

May 9th, 2010

Reviewing the Programming Microsoft Access series, I suddenly realized I’d written nothing about enumerations.  One of my favorite tools in VB and I completely forgot about it.  Of course, they weren’t even included in Access 97 VBA so I’ll just assume that had something to do with it …

I also found that I’d linked to the wrong demonstration database so I’m glad it occurred to me to run through the series again.  I’ll probably take the time to write up a couple of new chapters while I’m at it.

Moving beyond Microsoft Access

May 7th, 2010

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 article for the site and here it is …

Getting in Sync - Using recursion to compare directories in VB.NET.

It was an interesting project for the week; not only in writing the program but deciding how to present the information and files on the site.  I’ve been wanting to add some more  advanced content for awhile and I think this article came out pretty well.


My project  for this weekend is reviewing the Programming Microsoft Access series that I posted a couple months ago.  Last night, I happened to think about them and started wondering if the articles were enough.  So far, the review’s going well.  As always, I welcome your input!

Sorting it all out …

April 28th, 2010

I wrote awhile back about how I used Outlook to keep track of things I’m working on and store reminders for project ideas that would be great to work on someday.  I’m still getting the hang of it but I’m a little closer.  The Outlook calendar is a great tool.  I hadn’t used it much before and remember a time when I didn’t see  the point because it wasn’t quite as portable as a paper planner.  I can’t seem to keep up a paper planner, though, and I pretty much start and end every day at the computer now so the Outlook calendar is handy for keeping myself on track, even when it comes to something as simple as remembering to do a daily review of where I stand on various projects or leads.

Right now, I have a few projects that I’m jumping between, including paid work and personal projects.  A few weeks ago, I started planning a series of articles on Windows application design before  I got sidetracked preparing for some upcoming work.  This sounds really geeky but I actually enjoyed coming up with a new format for a program specification and writing up the spec for a demonstration program to go with that series. 

Then there’s the time I spend in continuing study of programming subjects and software to keep the skills sharp.  Microsoft Office 2010 is on its way and Visual Studio 2010 was just released.  I’ve barely had the opportunity to work professionally with VS 2008 so I have a professional evaluation copy of that installed on a virtual machine and I’ve  been working through a lot of exercises from my earlier .NET training for comparison’s sake.  I thought about buying it for home use before it went off the market but finally decided the free express edition would be enough for my use as I already own VS 2005.   I might get the 2010 version eventually.  The beta of Office 2010 is installed on that same machine and I spent a little time looking over Access 2010 to see how it compared to the 2007 version.

I have a long list of other projects in the hopper if I ever finish the ones I’m working on now.  It includes notes to check  out development tools like Adobe Air and SharpDevelop or ideas for writing projects.  I’ve compared it before to my Amazon wish list.  It’s the place where I can keep a reference to anything that catches my attention.  In Amazon’s case, it saves me money and bookshelf space.  In the case of my project list, it lets me make a note of things and then move on with what I’m working on without forgetting some good ideas.

Of course, I’ll never get to any of them if I keep talking about it here so … back to work.

Latest developments …

March 15th, 2010

I took a little break from writing after getting the last batch of articles online and promptly came down with the flu which put me out of action for another few days.  Then I decided to catch up with some ASP.NET study but I’m realizing now that my daily schedule just doesn’t come together unless I’m producing something so I know I need to continue on the Programming Microsoft Access series.  There’s a future series on application design which feels like it would be really fun to do but is kind of scary at the same time.

I’ve also been working on updating my online profile and promoting my professional services, including Microsoft Access application rescue.  Writing articles is nice but it doesn’t come anywhere close to paying the bills at this point.  So if you like what you see here and on the site and you or someone you know needs some programming done, drop me a line and let me see how I can help.

The Value of Choice

February 22nd, 2010

(A former boss of mine once said that he knew he’d written something good when he could go back and look at it six weeks later and still like it.  There’s some merit and a problem or two there but the idea stuck with me.  I was looking through some of my site archives this week and found the files from a weekly column I tried to start on the site in 2004.  Here’s an abridged version of one from March 2004 that I particularly like.  It’s not perfect but it has a certain spark to it.)

I went to McDonalds for lunch with a couple of co-workers earlier this week.  I suggested they super-size it while they still can after the news report I saw not too long ago that McDonalds is getting rid of their super-size option.  Evidently, the recent bad publicity engineered by the Food Police concerning the effect of fast food on people unwilling to make better nutritional choices has the company a little nervous about its bottom line.  Fortunately, the frivolous lawsuits aimed at fast food last year by people blaming the restaurants for their obesity were thrown out.  Various states are now rushing to pass legislation banning similar suits but bad publicity still costs money and Mickey D’s probably figures that people will be just as willing to buy larger selections separately when deprived of the convenient Feed Bag Value Option.

I didn’t super-size it myself although one of my co-workers did.  I guess I wasn’t feeling overly devout during this visit to the Church of the Golden Arches so I just ordered the large size of the Big Mac meal.  My doctor’s devotions, on the other hand, involve him charging me large amounts of money for a few minutes of lecture time about my weight so I feel obligated to give him something to complain about.  I can’t really explain the economics or logic involved in that transaction but it does result in me being able to eat Big Macs so I just accept it and chow down.  I swear those Big Macs used to be bigger.

I am well aware, as every other person with two brain cells to rub together should be, that McDonalds is an occasional treat rather than a daily solution.  Despite my relatively poor eating habits and the above bit of satire, I cannot tolerate a continuous diet of fast food as some people can.  I am also aware that the nutritional mischief I get into has its eventual consequences.  As a friend of mine once said, very simply; “We make our choices.”  Unlike those who choose the route of litigation and media-sponsored intimidation, I accept responsibility for mine.  If I add a dessert to a meal at my favorite restaurant or lounge on the couch eating Doritos in front of the TV, the choices involved are mine and mine alone.  The server at the restaurant, the store that sold me the Doritos, even the people who advertise the food bear absolutely no responsibility for the actions that I take of my own free will.

Unfortunately, it seems that more and more people in this society are unwilling to accept this responsibility or understand the concepts of free will and choice.  As I indicated in last week’s column, the freedom to make the wrong choices is vital to a person’s actual ability to make the right ones.  This is not as heretical as it may sound.  It simply means that when you act as the law or circumstance compels you to, it is not virtuous or moral beyond the obedience to the law.  When you make the correct choices independent of any law because your conscience and intellect require you to, that is true integrity. 

The mark of an intelligent and moral person is the ability to regulate their own behavior according to their beliefs in the absence of external restrictions.  In a larger sense, the fewer laws that a society passes which require the government to act as a parent, the healthier the society will be as its inhabitants are required to think like mature adults and take responsibility for their own behavior. The inability to grasp this seems to cross political lines as both conservatives and liberals demand that the government rule on their respective issues.  The mentality behind these demands not only limits the opportunity for people to be responsible for themselves but also takes a certain elitist and patronizing view toward the people it claims to protect. 

The lawsuits against the tobacco companies may have at least had some merit, the hypocrisy of a government that had been profiting from tobacco taxes for years notwithstanding.  Tobacco, after all, is an addictive product and there was evidence that the companies had manipulated the levels of nicotine.  Then we had the lawsuits against the gun manufacturers on the basis that they were somehow responsible for the crimes committed with their product.  Is anyone for suing makers of baseball bats?  How about Ginsu??  You can create a lot of mayhem with a knife that can cut through an aluminum can and still slice a tomato. 

I’m just waiting for the first lawsuit against a media company by someone claiming various consequences of emotional distress caused by a perceived bias in that company’s publications.  I suppose we might as well limit free speech while we’re at it.  That freedom of thought business is a dangerous thing.

Finally!

February 15th, 2010

Programming Microsoft Access is finally online!  The first 11 chapters are available on Drewslair.com and there will be more articles to follow.

I’m very interested in your  feedback.   I do what I can to make the material accessible but the more input I get, the better it will be.

Almost there …

February 12th, 2010

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 find when you step back and look at the material from an editorial standpoint rather than the writer.  So far, I’ve changed some examples, switched around a couple of chapters and found some typos and errors that would not have looked good on the site.  Basically, I’m trying to take my own advice from the chapter on algorithms:

“Throw everything you can at your code and try every way you can imagine to break it.  I know it’s tedious and it looks like it works so why tempt fate, right?  Trust me; finding a bug in your code and fixing it before it goes to the customer can feel a bit like having someone shoot at you and miss but it’s better than what you feel when the customer finds the bug.”