Saturday, August 29, 2015

2015 Microsoft MVP Virtual Conference for Access

Julian Kirkness, Brent Spaulding, Crystal Long, and Pat Wood discuss Access Web Apps on the Microsoft video channel. This also includes demonstrations of linking to SQL Azure from Access, Excel, and SQL Server Management  

NOTES:  This video is ranking no 2 from the conference

and a few more photos from the slide decks



Saturday, August 22, 2015

Digging Deep Into The Past

Many years ago I was very good at persuading Alta Vista and other search tools at the time to visit my Access web sites.  In sub folders on the sites I even had 10,000 pages devoted to getting link fees from CD Rom and book sites. Each of these pages said little more than If You Want to Hear the Music of The Bla Bla Band, Click here. These pages brought in 500$ a month till Mr Google came along and ignored them.

Hippos at Werribee Zoo
In those days I also had many good Access Articles articles organized to attract the search engines (they were called landing pages) across about 3 different domains. I found a few of them the other day and whilst they are a little old, they are worth bringing back from near extinction to my new site  See if these links get you interested.

A nice introduction into Lookup tables by Doug Thatcher called Lookup Tables – Improve data quality in your database

A simple article by Nirmala Sekhar called Track All Changes Made To A Database

and three pieces by your erstwhile editor entitled Exploring Your Data With Subdatasheets
plus SubDatasheets In Access 2000 
and an article that has been part of many of my jobs called    

Cleaning Up An Access Database

Friday, August 21, 2015

Building an Access Database from a Spreadsheet

A number of the Microsoft Access projects that I have been involved with are rescue missions for spreadsheet systems that have outgrown themselves. When I examine these systems they tend to have characteristics such a 12 individual monthly spreadsheets, one yearly spreadsheet that draws the results from the monthly sheets and maybe even another set of weekly report sheets jumbled into the system as well. Once these interlinked spreadsheets hit their second or third year, all the monthly spreadsheets have changed in design and the old information is only accessible by by a lot of manual cutting and pasting.

With good design and a few compromises, you can turn these into database systems that have easier navigation for input for users, report equivalent output and they do not require spreadsheet skills to run. This article tries to capture the techniques that I have used over the years to get these conversion projects up and running smoothly

FYI: I am currently working through my old content that didn't make it into the conversion.   This is one of those stories.  Apologies for lack of content lately, life's deck of cards haven't been so good lately. 

Monday, August 17, 2015

Rosetta and New Horizons

Recently man has visited Pluto and tracked a comet  << Fixed link. See if these articles will whet your appetite on these magnificent achievements.