News, views and articles from our membership
MS Access databases are great for quick data synthesis applications. The ability to create, populate, and then extract data can really simplify situations where consolidation of information is the eventual goal. A little while back, we put in place a tool that makes life easier for our project management office function. The following describes the situation and how MS Access was leveraged.
Continue Reading: MS Access on the Fly »
One of my clients recently had the need for a management report that presented project information. These data included project milestone dates, along with some basic project data. The client's database maintained the main project data and milestone dates in separate tables, where the milestones were in a many-to-one relationship. The objective was to create a new table with one row per project containing a combination of project descriptive data and milestones.
Continue Reading: MS Access: A Simple Pivot Table »
This article explains how to retrieve a recordset from a database and place it in an Excel worksheet, using an ADO connection to pass SQL strings.
Continue Reading: How To Retrieve Data From A Database To Excel Using VBA, ADO & SQL »
Follow Us