Wednesday, December 14, 2016

If You Still Need it, Here's Even More Proof of Life for Our Lovable Little Friend -- Access

This means Businesses moving to Office 365 can continue to use the most popular Relational Database Design Tool in the world without jumping through hoops to do so.

Obviously, it won't happen overnight, so your patience is still needed, but as the announcement says:

"How soon you'll see Access as part of your installation depends upon the Office 365 update channel your admin designated for your subscription. For Access users with Office 365 on the Current Channel, you'll see Access added to your installation in December 2016 or January 2017. For Access users with Office 365 on the Deferred Channel, you'll see Access added to your installation in June 2017. To find out what update channel you're on with Office 365, go to File > Account within one of the desktop applications. Your update channel is listed above the version number."

Those of us in the MVP community have been crowing publicly about the changes we see over in Redmond for a while. Proof of the validity of that optimism is rolling out on a regular schedule these days.

Bookmark Office Support at MS to keep up-to-date with the enhancements coming our way.

Saturday, November 19, 2016

Free Stuff From Grover Park Consulting

Everybody likes Free Stuff.

I have just published one more free application on my website, GPCData Downloads.

This one is an Access Web App (AWA). It's a demo version of the same AWA I use myself.

I track:
  • A1C (Quarterly)
  • Blood Glucose (daily)
  • Blood Pressure (daily)
  • Pulse (daily)
  • Weight (daily)
You can use these same categories, or add your own.

I also track:
  • Daily Exercise by type and location
  • Duration of activities
  • Mileage, when appropriate
In addition, it includes tracking of
  • Medications
  • Medications Taken
The other function included is tracking of:
  • Calories consumed
  • Carbohydrates consumed
I have added a basic "dashboard" function to the basic testing to show max and min values for tests along with average for some, where appropriate. These are color-coded.

Please feel free to download and deploy this AWA to your own Office 365 Site. You can obtain an O365 site for as little as $5.00/month.


Because the data is stored in a SQL Azure database, you can link to it for reporting from Microsoft PowerBI. Create a nice-looking dashboard to share with your own medical team from their browser! 

Monday, November 7, 2016

Microsoft MVP Summit 2016 -- The Future is Brighter Than Ever

At the annual Microsoft MVP Summit in Redmond, getting recharged by the A-Team. We're under NDA for all content; however, it's no secret that the general atmosphere, mood and especially the outlook for our favorite lovable little Database Application are so different from what we're used to that I can't help smiling all the way through the sessions.

Access is not just alive; it's growing again.

Saturday, October 29, 2016

What People are Downloading From

I recently looked up statistics on which of my free demos and downloads have been most frequently downloaded from the GPC Data Downloads Page over the last ten years.

The winner, by a fairly small margin, was the Access 2007 version of  WorkTrack, which is a small tool I originally built (using Access 2003 at the time) to track my own personal project time and billing. When I add in the A2010-A2016 versions and the old A2003 version, it leaps out in front by a significant margin, almost two to one over the next most often downloaded demo, ContactManager. These versions are in first, third and seventh place overall by number of downloads in the ten years of data available. Contact Manager is in second place overall.

It seems people are interested in simple, easy to implement and manage project tracking, and also the ability to track their contacts -- with Access. It does make sense, when you think about it. Anything else we do is fairly custom for the type of business we're in. Most of us, though, want to keep track of who we call, email and meet with, along with the work we do.

So,  with that in mind, I recently overhauled the WorkTrack demo. I cleaned up some code, implemented better error handling, and added a Change History function. The Change History function records all new and modified data in all forms, by user who made the change and by date and time of the change. It doesn't record deletions, which is in hindsight an oversight. I'll get back to that later.

So, if you haven't visited lately, please come on over and kick the tires.

And please let me know what you think. There are feedback links on most pages.

Sunday, October 23, 2016

Shopping For Shades

The future (of Access) is so bright I'm going to need them.

Although the Access Web App (AWA) has lost a bit of its luster, there are new contenders on the rise. Specifically, Power BI and Power Apps. Or should that be PowerBI and PowerApps. I guess that little detail will be clarified as we move along.

First up, Power BI. I had known about it for a while, but I got a real solid introduction at the recently completed Seattle Give Camp 2016. If there is Give Camp weekend in a city near you, I'd recommend you get involved. It's a great chance to give back to the community by helping a local non-profit with a software solution. But for me, an even bigger boost is rubbing shoulders with the young, smart, diverse volunteers who show up and put forth an incredible effort.

Harit Kalathia, one of those young, smart developers provided a Power BI dashboard for our non-profit's Access database. His Power BI dashboard shows all of their Key Performance Indicators (KPI's) on a highly visual, interactive layout. It really opened my eyes as to what can be done with Power BI, but even more than that, how to make it happen. I was hooked.

Sign up for a free Power BI account and go for it yourself.

Being an old-timey Access guy, it took a bit to get used to the new environment, but I found it reasonably easy to figure out, especially since I had Harit's dashboard as a template to guide me. I soon had a two-page multiple graphic dashboard for one of my own Access Web Apps. That's right. I was able to connect directly to the SQL Azure database behind my Diabetes Tracker AWA and pull the data from it into a series of graphics and tables that summarize nicely the important metrics I track: Fasting Blood Glucose, Blood Pressure and Weight.

You may be amused to note that I track Blood Pressure with both feet flat on the floor and with my legs crossed. I discovered that there can be as much as 10 points difference between the two. Most medical practitioners measure your Blood Pressure with your feet flat. I assume they consider that the more accurate way to measure it. It's part of my obsession with data that I track both, I guess.

More than that, Power BI let me publish the result to a URL that I sent to my Primary Care Physician. He was able to launch the Power BI in his own browser and see up-to-the minute metrics that he normally measures every three months in his office.

Did I mention? I am hooked on Power BI.

PowerApps are the other new entrant into the arena of web-enabled tools coming online. It's a newer, less mature technology, and there's a long way to go before I will be ready to call them a reasonable alternative to anything currently possible with Access or Access Web Apps. However, they do solve one big problem with AWAs: the lack of a decent smart device presentation. I've long been a fan of AWAs. As you might know, I helped write a book on the subject. However, the presentation of any AWA on a smart phone is inadequate for all but the most simplistic of functions. PowerApps are designed out of the box to do that.

I won't try to promote them until I see enough progress to make that a reasonable thing to do. In the meantime, I urge you to become informed, try them out if possible, and prepare for the future.

And, as ZZ Top would agree, get yourself a decent pair of Cheap Sunglasses.