Access 2016 For Beginners: Practice Makes Perfect
4.5 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,088 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access 2016 For Beginners: Practice Makes Perfect to your Wishlist.

Add to Wishlist

Access 2016 For Beginners: Practice Makes Perfect

Don't just watch me create a database, answer the practice problems and develop a database for yourself!
4.5 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,088 students enrolled
Created by Ermin Dedic
Last updated 8/2017
English
Current price: $12 Original price: $195 Discount: 94% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 9 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Create and use the fundamental objects in Access 2016
  • Create a basic to intermediate database
  • Learn how to create tables and work with tables
  • Learn how to work with fields and records
  • Learn how to create and utilize Queries
  • Learn how to utilize date and time properly
  • Learn how to create and utilize forms
  • Learn how to create and utilize reports
View Curriculum
Requirements
  • You must have Access 2016
  • Be able to use a computer
Description


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!


Who is the target audience?
  • Beginners in Access, 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 neccesary
Compare to Other Microsoft Access Courses
Curriculum For This Course
34 Lectures
02:05:13
+
Is the course for you? What will we cover?
2 Lectures 02:51

I welcome you to the course by telling you who this course is for and what we will be focusing on in terms of content.

Preview 01:33

Important Things To Consider
01:18
+
Creating and Working with Tables
8 Lectures 28:17

Naturally, it makes sense to start at the start screen. We will look at the options we have at the start screen.

Preview 02:35

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.

Key Concepts (as little theory as possible)
02:20

The table is the first object that we create in the course. It is the object that will store our information/data. 

Preview 10:18

Primary and Foreign keys are the basis of building relationships between tables.

Primary and Foreign Keys
05:53

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).

Relationships
06:36

Practice Problem #1
00:11

Practice Problem #2
00:15

Solution for Practice Problems 1 & 2
00:08
+
Fields (Columns)/Records(Rows)
8 Lectures 27:44

Controlling how certain information is inputted into your database helps you get consistent data and prevent errors of entry.

Input Masks (input control for fields)
07:42

Setting a default value can often save you time.

Default Values
02:26

Validation rules prevent certain input based on expressions we outline.

Validation Rules
06:35

We look at the other aspects of fields..like field size, format, and required.

Additional Field Options
04:36

Filtering and Sorting your records is super easy with Access 2016.

Sorting and Filtering
05:51

Practice Problem #3
00:14

Practice Problem #4
00:13

Solutions for Problems 3 & 4
00:06
+
Queries
8 Lectures 33:37

A short introduction to Queries!

Intro to Queries
01:57

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.

Creating Queries (with wizard and design view)
05:30

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.

Filtering/Constraints with Criteria
04:24

If you want to make your life much easier, and create 'flexible' queries, parameter requests are a must.

Parameter Requests
05:39

If you ever have to create a calculated column/field, you will want to be comfortable with expressions/formulas, and the expression builder.

Using Expressions/Formulas to create Calculated Fields
08:13

I cover Query Property Sheets. Get more control over your database!

Query Property Sheets (get more control over your queries)
07:30

Practice Problem #5
00:23

Solution Practice Problem #5
00:00
+
Dates In Queries
5 Lectures 22:27

Often you'll want to select a date or time range..I'll show you how.

Selecting A Range of Dates
03:35

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.

Formatting Dates
07:40

What functions let you see current date,time, or the now? I will show you.

Insight from Current Date/Time
02:41

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.

How to Calculate Elapsed Time
04:42

In this lesson, I show you how to calculate time intervals. 

Calculating Time Intervals
03:49
+
Forms
2 Lectures 04:28

In this short introduction to forms, we discuss 'bound' forms and 'unbound' forms.

Intro To Forms
01:20

Generating Forms can be a breeze. We show you how to do it, and what purpose the Form object serves.

Generating A Form
03:08
+
Reports
1 Lecture 05:50

Here you learn about the Report object. Report allows us to view, format, and summarize our data.

Generating A Report
05:50
About the Instructor
Ermin Dedic
4.3 Average rating
330 Reviews
4,499 Students
9 Courses
Data Science, Graduate Student (Educational Psychology)

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).