Access for Dummies

20140122-145320.jpg

Over the years I’ve had a lot of interaction with Microsoft Access. I’ve certainly entered a ton of data when I first started out and generated pre-made reports. However, it wasn’t until now that I really dove into the program to the point where I could create my own database from scratch and query my own information. To learn more about Access, I signed up for a series of free courses offered by my employer. If your employer offers these kind of services, I highly recommend you take advantage of them! If they don’t offer it, there are a lot of online options and Access For Dummies is a big help too.

For those of you who don’t think you need to know how to use Access, ask yourself the following…

Do you have large amounts of data?
Do you have no data?
Do you need to know specific things about the data you collect?
Do you need to save time and money?
Do you have multiple people who need access to the information you collect?
Do you create monthly reports using Excel?
Do you want a good resume builder?

Clearly I’m a right-brained, visual type of person. I like analyzing data and I consider myself a strategic thinker, but I like to look at it in a shiny graphical format, not globs of numbers in spreadsheets that blur together over time. I’ve wasted a lot of time in past positions entering data in Excel and then using that as a reference for some horrible Word Smart Art. Eventually I graduated to Pivot Tables and Pivot Charts (still very helpful) but nothing compares to Access in the Office family when it comes to collecting data and pulling information. I shied away from Access for a few years, simply because I assumed it was for more advanced data people…and because someone else was already taking care of that piece for me.

20140122-145158.jpg
I’m still somewhat of a beginner when it comes to Access, but I’m proud to say I learned (a big) something knew already in 2014. It’s so easy to fall behind with technology and even though I don’t work in data analytics or IT, I feel as a marketer that I need to know this stuff and keep up. I’ve been lucky to have IT and data people around me to assist throughout my career, but I know I can make all of our lives easier with this knowledge. It’s never too late to learn and I can’t see how it wouldn’t be useful to anyone!

Plus it’s free, so I mean, come on.

Cheers!

Advertisements

You Know You’re Getting Old When…

As another year ends I’m reminded of how much older I’m getting. I certainly haven’t grown much, physically or mentally. I mean I did finish my master’s degree in 2013, but I’m still the person who makes fart noises behind peoples backs when they say something stupid in public, let’s be serious.

So how do I know I’m getting old? It started a few years back when I was in a movie theatre with my boyfriend, watching a preview of the new Footloose. A group of tweens in front of us started debating whether or not it was a remake. One insisted she saw something like it before.

Ultimately they concluded Footloose was not a remake. Are you kidding me? It took everything in my being not to throw popcorn at those little turds.


That’s when it hit me.

Over the years all my friends got married and now they are having babies (another major sign you’re getting old). This doesn’t bother me one bit though. I’m really happy for all you spouses and parents out there. I’m not missing my college partying days by any means (ok maybe a little). This is just another indication that I’m supposed to start acting like an adult now. My Facebook newsfeed is filled with sonograms and mushy love notes (ew people, just stop).

Today, in true adult fashion, my boyfriend and I were at a fast food restaurant. While we debated the dollar menu options we would soon regret, a young girl slipped and fell behind us while walking through the door. Not a bad fall, just a good old fashioned humorous flop. She got right up and her and her friends laughed their asses off. It was funny and she was obviously fine. While we were eating, however, the manager came by and made her sign off on a bunch of paperwork that promised she would go see a doctor and not press charges and bla bla bla.

Ten years ago, this never would have happened. Or maybe it would have, I don’t know, but the fact that I am having this reaction must mean I’m getting old (and also the fact that I’m blogging at 10:30pm on Friday night). Is this what the world has come to? Does everyone have to sign their life away whenever they take a harmless spill? I bit the dust last week in a Target parking lot and nobody seemed to care. Are we not supposed to laugh at that anymore?

Anyways…now that I’m obviously starting to get old, I decided on a couple of good New Years resolutions:

1. Never grow up (completely). That’s right folks, I’ll be making fart noises behind your back until the day I die.

20140103-221620.jpg
2. Make new friends. This one is important. As we get older we tend to lose touch with good friends. Maybe it’s a natural part of life, or maybe it’s because we just get lazier as we get older, I’m not sure. But while I’m still in my 20s I’m going to bulk up my friendzone while it’s still socially acceptable.

Happy New Year!