Learn to code from scratch with the latest and greatest tools and techniques.
Enroll NowFrom Photoshop to After Effects, learn professional creative tools from the experts.
Enroll NowSnag unlimited access to 1,000+ courses for life — now just $99 with this deal!
View DealMicrosoft Access is the perfect compliment to Microsoft Excel..but so many people under-utilize Access. In fact, here is what the Microsoft website states:
" In general, Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users. Excel is generally better for analyzing data: performing complex calculations, exploring possible outcomes, and producing high quality charts. If you use Access to store your data and Excel to analyze it, you can gain the benefits of both programs."
In fact, the biggest mistake users make is to use Excel as a database (or a place to store or manage data). This can cause all kind of headaches if there is an increase in data or multiple users start to want to interact with the data.
The course includes an illustration on how to prepare Excel data before importing it into Access, how to properly import it into Access, and then illustrating how a database works.
I'm passionate about statistics, data science, object oriented programming and psychology/mental health.
I've developed an expertise in SAS programming and beginner/intermediate statistics largely through my schooling and partly self-study. I'm also self-taught in object oriented programming.
I'm a former Graduate student in Educational Psychology. Two years into the program I decided that I could make a bigger difference in the world by being outside the clinical context of helping one client at a time. By teaching what I've learned in from my 6 years of studying Psychology (4 years of Bachelors and 2 of Graduate), I can help more people at once. I can also apply my stats, programming, and data science skills to advance the mental and physical health fields from the outside, hopefully improving the quality of life for many people at once.
I enjoy receiving messages from students who have passed exams, obtained interviews, or gained employment, from taking one of my courses.