Microsoft Access is a tool that can be used for manipulating data sets so they can be used more easily. For example, if you have sales and shipping information from three different data sources you can combine them using Access! This is done by creating a "Query" that ties all of the data via a common ID number to only the information you actually need from your data sources. It's a great way to manipulate data to make it more user friendly for later use! An advantage of access is that it is very user-friendly. You don't need to know lots of coding or syntax to use it. Here are some resources to help you learn Microsoft Access:
- Microsoft likes the users of its tools to know what they are doing, so they publish their own lessons here. It's broken down nicely by skill, making it easy to find the specific lessons you want
- Here is part one of a two part video lesson on Microsoft Access on YouTube. It only takes 2 hours to watch all of it, so next time you are thinking of watching a Netflix movie, watch this instead and pick up a new skill!
- Prefer to read rather than watch? Tutorialspoint has online text material to help you learn Access!
- Udemy has a free version of their video lectures here
SQL (pronounced Sequel) is similar to Access in that it is used for database management, but SQL has a few key differences. SQL is a language that is designed for managing and summoning data from different databases based on a criteria you are looking for. Imagine you have a huge database of policies and you want to specify the specific types of information you want to find within it, SQL can help! SQL can be more powerful and versatile than Access, but to use its full functionality you will need to understand how coding words and what the syntax of SQL is.
- This article can give you a good strategy for how to learn SQL
- There are countless SQL learning videos online, here are a few to get you started
- W3 has a really nice reading opportunity to learn SQL and perform exercises at the end of each section. Not many learning resources let you actually apply the learning, so this is a great resource!
This website is brought to you by The Penn State Actuarial Science Club's Webmaster, Aidan Lake.