Microsoft Access: Access Level 1 & 2 (GUI, Macros, VBA)
What you'll learn
- Access Graphical User Interface and the 4 main objects (tables, reports, queries, and forms)
- Excel to Access Import While Following All Database Principles
- Access Macros - Discover How To Utilize Macros for simple tasks
- Access VBA Will Allow You To Import Excel Into Access Using Code
Requirements
- Access version of some kind, MS Access 2013 to present is fine.
Description
Welcome to 'Microsoft Access: Access Tutorial, Level 1 & 2 (GUI, Macros, VBA)'.
We start with the Graphical User Interface of Access but then build up to Access Macros and Access VBA. We will also look at how to build a database by following all database principles.
All this means that you will go beyond learning how to use an existing database. We will give you a hands-on illustration of the key database principles so you can begin building a database on your own.
You will begin by exploring the 4 main objects of Access (tables, reports, queries, and forms), and then you build on that by learning about how to properly build a database.
We have seen quite a few courses on here who do a great job overall in teaching Access but then make fundamental mistakes when it comes to database design. These kinds of mistakes make it impossible to actually build a database on your own, unless the database is used for a trivial venture. You will learn about normalization, referential integrity, and other principles related to good database design.
For those of you spreadsheet experts from Excel, we have two course sections on importing Excel to Access via the GUI and Access VBA code. All of this while following database principles. If you're interested in learning the differences between Excel and Access, and how you may go about using both..this is a good opportunity.
This Microsoft Access Tutorial is perfect if you are a small business, or an individual, that needs to do a better job in terms of managing your data. If you want your data organized, and prepared for analysis and reporting. This course is perfect for you.
Microsoft Access is one of those programs that is currently highly undervalued, and this in large part because newer programs have come out, yet for 95% of businesses out there, Access has everything you need..and it is quite inexpensive and fairly easy to learn.
Microsoft Access is the perfect all-purpose database, and it can help your company store information and manage large amounts of data.
There is no risk. If you should not like the course, Udemy offers a 30-day money back guarantee. Get a valuable skill today!
Who this course is for:
- Access Beginners, and/or those that need a refresher.
- An individual or business that wants to build a basic or intermediate database for their small business.
- Employees who want to get a skill that is still very much valuable and necessary
Instructor
I have a passion for anything data, whether it is applying statistical methods to data more generally, or utilizing a data-driven approach in the Healthcare or Finance/Banking industries.
I studied Psychology for 6-years, including 2 years of Graduate school, where I was training to be a Child/School Psychologist. I was fortunate enough to have the opportunity to experience a blend of course work and clinical work but also recognize some of the problems facing the mental health system and graduate school system. While I am very interested in finding a solution for the latter, this is a long-term goal.
I did ultimately decide to voluntarily leave the Grad program, it was via academics that I fell in love with statistics and statistical software like SPSS/SAS.
Furthermore, it was my Graduate school experience that not only solidified my interest in teaching, it's where I received a lot of positive feedback on my ability to break down complex topics.
I enjoy receiving messages from students who have passed exams, obtained interviews, or gained employment, from taking one of my courses.
---------------------------------------------------------------------------------------
Para meus alunos de língua portuguesa ...
Sou apaixonado por estatística, ciência de dados, programação orientada a objetos e psicologia / saúde mental. Eu desenvolvi um conhecimento em Programação e Estatística SAS através da minha escolaridade e auto-estudo. Também sou autodidata em programação orientada a objetos.
Eu sou um ex-aluno de graduação em psicologia educacional. Dois anos depois, decidi me retirar voluntariamente. Aprendi que o ambiente acadêmico tradicional e o ambiente clínico não eram o caminho adequado para promover mudanças em larga escala.
Ensinar é uma paixão há muito tempo. Criei meu primeiro curso de vídeo online em 2016 (um curso de Estatística). Foi um projeto de pura paixão. Como resultado de obter ótimos comentários, continuei! Atualmente, ensino os cursos de SAS, estatísticas e psicologia, mas também estou sempre aprendendo. Gosto de receber mensagens de alunos que passaram nos exames, obtiveram entrevistas ou obtiveram emprego ao fazer um de meus cursos.
----------------------------------------------------------------------------------------------