The most straight-forward Access 2016 course on Udemy. Learning doesn't have to be hard. Practice questions in each section allow you to test how well you are learning the content!
We will build a fairly basic database together in this course. It is small and manageable so that you stay focused on the concepts and learning, and don't get overwhelmed by the amount of things going on (ie many tables, relationships, fields, records, etc)
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.
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 2016 has everything you need..and it is quite inexpensive and fairly easy to learn.
Access 2016 is the perfect all-purpose database, and it can help your company store information and manage large amounts of data.
Join me today, and let me help you utilize this amazing program!
Naturally, it makes sense to start at the start screen. We will look at the options we have at the start screen.
I'm not a big fan of theory and definitions. I like to make practical courses, that solve practical problems. I'll explain to you the bare minimum theory of how Microsoft Access 2016 works.
The table is the first object that we create in the course. It is the object that will store our information/data.
Primary and Foreign keys are the basis of building relationships between tables.
We can tell Access, in a very direct way (through relationships) how our different tables relate. This is a crucial step as we move on and work with the rest of the objects (queries, forms, reports).
Controlling how certain information is inputted into your database helps you get consistent data and prevent errors of entry.
Setting a default value can often save you time.
Validation rules prevent certain input based on expressions we outline.
We look at the other aspects of fields..like field size, format, and required.
Filtering and Sorting your records is super easy with Access 2016.
A short introduction to Queries!
I show you two different ways that you can create a query. We also discuss the two main type of queries, select queries and action queries. Here, we illustrate a select query, as we are simply taking different fields from different tables and combining them.
When we are in design view for our created query, the 'criteria' option gives us a lot of power and allows us to to be very specific in terms of what data we want to search for and display.
If you want to make your life much easier, and create 'flexible' queries, parameter requests are a must.
If you ever have to create a calculated column/field, you will want to be comfortable with expressions/formulas, and the expression builder.
I cover Query Property Sheets. Get more control over your database!
Often you'll want to select a date or time range..I'll show you how.
You want to make sure that you do any calculations before formatting, but if you are done with calculations, you might want to format your dates to produce an output/visual that you prefer.
What functions let you see current date,time, or the now? I will show you.
In this example we look at one of the functions that also you to see how much time has elapsed, from the current date/time to whatever date field you want to compare it to.
In this lesson, I show you how to calculate time intervals.
In this short introduction to forms, we discuss 'bound' forms and 'unbound' forms.
Generating Forms can be a breeze. We show you how to do it, and what purpose the Form object serves.
Here you learn about the Report object. Report allows us to view, format, and summarize our data.
The success and fun I had with statistics based courses in University has resulted in my current teaching interests. My interest in data and statistics boils down to my passion for finding the objective truth, and applying these findings in life and business. Currently, I teach five courses. A Statistics course, a SAS course in English, a SAS course in Portuguese (with subtitles, but English instruction), a SAS SQL course, and a Pandas (Python 3 ) course.
O sucesso e diversão que eu tive durante meus cursos de estatística na Universidade resultaram em meu interesse em ensinar. Meu interesse em dados e estatística vêm de minha paixão por encontrar verdades objetivas, e aplicar estas descobertas na vida e no negócio. Atualmente, eu ensino quatro cursos. Um curso de Estatística, um curso de SAS em inglês, um curso de SAS em português (com legendas, mas instruções em inglês) e um curso de Pandas (Python 3).