It’s been a while since I’ve written a #tsql2sday post, but thought that this month’s topic was worthy of me hoping into the pool with the #sqlfamily. This month the subject is “Automation”. chosen by Hemanth D. (Blog | @SqlChow). If you want to read the opening post, please click the image above. I’m lover of software automation and been a fan since writing my first macro in Excel when I was in high school. I loved anything that makes it easier for you to get more done with less. Back in the 2000’s I got introduced to SQL 2000 and DTS and it changed my world. My first package I created was awesome and so exciting it took data from database and put it into another one and then truncated the table, once I scheduled it to run I was able to not worry about handling that task anymore and sleep peacefully. Since then I’ve found my passion and made a living improving businesses through process improvement using automation.
Thanks for attending my session on best practices for automation business processes with Kapow at the 2013 Kapow.Wow User Summit. As promised in the session i wanted to share my slides for all.
I’ve been using Microsoft Access since Access 97 it’s a very powerful tool is you use it right. You can use it for everything from personal Baseball card inventory control to managing home inventories; even fortune 500 companies use it to manage million dollar systems. As I said if you use it right it can be quite a powerful tool built on some amazing framework. Recently a friend who’s getting into access asked me if I could provide him some resources so that he can get better familiar with the tool. Below is a list of resources I put together for him.
Northwind sample database relationship view
MS Access Blog Resources:
Some Really Good Books To Start With:
- Access 2010 Programmer’s Reference – http://amzn.com/0470591668
- Access Cookbook, 2nd Edition – http://amzn.com/0596006780
- Access 2007 Pure SQL: Real, power-packed solutions for business users, developers, and the rest of us – http://amzn.com/0615297927
Also If you’re looking for some templates visit: http://office.microsoft.com/en-us/templates/results.aspx?qu=access&av=zac. I highly recommend checking out the Desktop Northwind 2007 sample database it can show you the full power of this product.