Hello…

And if you have made it through the first three lessons we really appreciate it.  In this final set of lessons we’re going to take a look at Microsoft Access.  MS Access is a database application that will really get people’s attention on a resume (dumb comedy, but true) and more importantly can help put you in the upper echelon of software knowledge.

The whole idea behind Access is you store data in something called table (think list), then ask questions of your data (aka-query); from there create some forms (think Amazon order screen), or reports (aka- fancy printouts).  One can make a strong argument that learning Access will help you work with other Microsoft applications because many of Access’s capabilities transfer into other applications like Excel.  Furthermore many of the things you will learn from Access transcend into SQL, which is a big-league database application.

For the first lesson we’ll take a look at Access Tables and why they are so vital for you to understand.

Second, we’ll take a look at how to create a simple query which is really a fancy way of saying you want to ask questions of your information (data). <grin>

What are Access Tables

Queries in Access

One last thought– just to be upfront this is a legacy class.  Meaning it is intended for people who are not overly concerned about the specific version of the software used in the tutorials (in this case Access), rather they just want to learn the core concepts that apply to all versions and are ok with a few minor differences from what they see on their screen.

In case it helps all the content in this course applies to Access 2010, 2013, 2016 and Office 365.