Category Archives: Microsoft

T-SQL Tuesday #050: Automation, Get Work Done While Sleeping

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.

Getting Started With Microsoft Access

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:

  1. http://msaccessdevelopment.blogspot.com
  2. http://accessblog.net/
  3. http://accessindepth.blogspot.com/
  4. http://accessexperts.net/blog/
  5. http://msmvps.com/blogs/access/
  6. http://blogs.office.com/b/microsoft-access/

 

Some Really Good Books To Start With:

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.