Not Exactly Technical but worth checking out
Posted March 9th, 2008 by Peggy BakerIf you are interested in keeping on top of MS Access and its road ahead, you might like to read this blog:
I was looking for information on Access 2007 service packs, performance improvement, etc., and turned to the semi-official Microsoft Developer blog. There is a posting from Bill Gates on the impetus to move Access functionality to the web with Sharepoint. Looks like the authors post every week or so.
Die database, die! Five reasons why Access has not disappeared.
Posted November 17th, 2007 by Steve BackmanI just started a data management assessment for a new client with my colleague Emily Graham. The organization uses a dizzying array of contact and process management tools from rolodex to high end commercial nonprofit CRM software. A custom-developed Microsoft Access database sits squarely in the middle.
Microsoft Access error: "The database has been placed in a state by user..."
Posted November 16th, 2007 by Steve BackmanDeleting data in grids (sub-forms)
Posted January 7th, 2007 by Steve BackmanOne of Access' best features is how easy it is to add related data sets. Forms frequently have embedded sub-forms or grids. Typically there are buttons for adding or editing rows in the sub-form If there is not a specialized button on each row for removing that row, you can still easily do so as follows. In a sub-form, there is a left-most grayed column, thin and empty. This is the row selector column. If you click next to a row in this left most column, the form responds by putting a right-facing triangle in the column, indicating you have selected that row in the sub-form.
Creating off line data extracts
Posted January 7th, 2007 by Steve BackmanOften in an Access database, lists are presented either as Queries (data views) or Reports. These may suffice for many purposes, but it is also straightforward to then export them to Word or Excel. As with other things Microsoft, in fact, there is more than one route to doing this. All start by previewing the list on the screen.

