What you'll learn:
- Understand how Access is constructed and how to use the major objects within it.
- Be confident in moving around within Access and using the many tools available
- Be able to build effective database solutions for their unique data needs.
- Be able to save time by automating tasks with macros and/or simple VBA subroutines
Just about everyone knows and uses Microsoft Excel, but many of the things they use Excel for would be better done with Access. In just about every office, there are people struggling with long, multi-step processes with Excel that could literally be done with a single mouse click in Access. The problem is that while Excel is the most awesome data analysis tool on the planet, it is not an effective database! BUT people are using it for that purpose anyway because it is all they know.
So why doesn't everyone just use Access? Well, here is the bad news:
It is harder and takes longer to get productive with Access.
But then again there is some good news too:
It is harder and takes longer to get productive with Access.
What? Is that a typo? How can the good and bad news be exactly the same?
Here is the deal - MOSTpeople won't take the time to learn Access. They will continue to struggle doing their laborious, complex Excel database processes because they do not have the discipline and determination to learn new ways of doing things. BUT these people, and the companies they work for, are VERYHAPPY to pay someone who can show them a simple database that does these same tasks with a few mouse clicks.
No matter what office environment you are in, if you take the time to learn Access and implement it to automate some of your own tasks, you will soon be "discovered" by your co-workers and you will start getting requests for "help" with their work. Bosses who are not accustomed to getting exactly the report they want ahead of time will start asking for more detailed reports and the person who can deliver on these requests becomes much more valuable as an employee.
For you, the person who decided to work extra or work on your own time to get productive with Access, you will benefit for that short time of intense work for the rest of your life. Things that other people assume are very hard to do are not hard at all and every time you are confronted with something new, you learn a little more about Access.
The more you work with it, the better and more skilled you become. You will find that you have transitioned from semi-manual labor with Excel (copying and pasting, doing many steps), to THINKING about how to use the power of Access to automate the entire process. You will have enriched your work environment and your life!
I've worked with Access just about every day since it was first released and I learn more about what it can do every week! There is just about no limit to what you can do and you are limited only by your imagination.
So are you the one who wants to make a positive change in their life? Are YOUthe one who is willing to work hard for awhile to reap the benefits forever? The person who will stand out, who will be as close to "layoff-proof" as possible and always in demand?
Take thiscourse and let me layout the basics of Access and explain why everything I've said above is true - and could be true in YOURLIFE too!
The videos in this course were created using Access 365. To get the most out of this course, students should be using Office 365 (Access 365) or Office 2019 (Access 2019), but you can also use earlier versions, like Access 2010, Access 2013 or Access 2016. With earlier versions, not all techniques will work and the screens will not look the same in some cases.
With the addition of three hours of new videos on migrating Excel data to Access, you can save yourself a lot of headaches by seeing all the common problems people encounter during this process. These new videos are at the end of the Access course because you will be using many of the skills you have learned to determine where problems are in imported data and how to resolve them.
