Access 2016: Complete Microsoft Access Mastery for Beginners
4.5 (119 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.
2,925 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access 2016: Complete Microsoft Access Mastery for Beginners to your Wishlist.

Add to Wishlist

Access 2016: Complete Microsoft Access Mastery for Beginners

Master Microsoft Access. Design databases w/ tables, forms, queries and reports. (for Access 2010, 2013, and 2016)
4.5 (119 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.
2,925 students enrolled
Created by Steve McDonald
Last updated 5/2017
English
English [Auto-generated]
Price: $100
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 1 Article
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • At the end of this course, you will be able to create a simple DATABASE in Access from scratch.
  • You will know how to create and modify TABLES in Access.
  • You will know how to create FORMS for enter data into your tables.
  • You will know how to create QUERIES to ask questions of your Access database.
  • You will know how to create REPORTS for sharing and presenting your data in a clear, professional way.
View Curriculum
Requirements
  • You just need to have a PC, basic computer skills and an installed copy of Microsoft Access on your computer.
  • You don't need any previous experience with MS Access or Excel.
  • This course starts at the very beginning.
Description

Welcome to the Access 2016 course. 

Thank you so much for joining me. 

  • Do you need to learn Microsoft Access, but feel intimidated or
    overwhelmed by the thought of it?
  • Are you ready to learn a ton of practical, hands on Access skills?

If so, you found the right course!

This course is designed to get you feeling comfortable and confident using Access. It's designed to get you started with the skills you need to organize your data in tables, mine your data using queries, and create clean, professional reports to impress your boss.

Is it the Right Fit?

You might be wondering if this course will be a good fit for you. Well, I designed this course for the beginner who needs to add this course to their list of important job skills. This course is also a good fit for you if you have a little bit of experience with access already, and you're ready to fine tune and expand your skills in an easy, stress-free way.

Skills to Impress Your Boss

While its ultimately up to you, my goal is to give you the skills to impress your boss and hopefully get that raise, promotion, or new job that you deserve.

Start at the Very Beginning

We'll start out with a complete tour of Access and it's tools. Then, I'll show you how to open an Access Database and how to use pre-formatted Access templates provided by Microsoft so you can start right away.  

Create a Database from Scratch

  • I'll walk you through creating a complete Access database from scratch. 
  • I'll show you how to create tables and connect those tables to each other using relationships. 
  • I'll show you how to mine your data using queries, how to create forms so users can enter data into your database, and how to create custom reports so you can impress your boss. 
  • I'll also share insights and productivity tips along the way.

Let's Get Started!

Are you ready to take your productivity and hopefully even your job prospects to the next level? Let's get started with Access 2016.

Click on the Buy Now button or watch one of the Free Preview Lectures and start learning Access today.

Who is the target audience?
  • Anyone who needs to learn Microsoft Access, but might be intimidated or feel overwhelmed by it.r
  • This course is for students brand new to Access.
  • This course is also for students who have some experience with Access or Excel and need to learn more about Access.
Compare to Other Microsoft Access Courses
Curriculum For This Course
37 Lectures
05:34:38
+
Introduction to Access
3 Lectures 31:57

Welcome to Microsoft Access for Beginners. In this lecture I'll introduce you to some basic database concepts and give you a tour of a Microsoft Access template.

Preview 09:52

In this video I'll take you on a tour of the Microsoft Access dashboard, tools and ribbon.

Preview 10:08

At the end of this lecture, you'll understand the four most basic objects in Microsoft Access: Tables, Queries, Forms and Reports. And you'll understand the role that each of these objects plays in your Access database.

Preview 11:57
+
Tables in Access
4 Lectures 40:06

In this lecture I'll walk you through creating your first two tables in Access. Tables area the backbone of a database. They are where all of your data, or information, is stored in Access.

Preview 17:53

Appending data allows you to add data into an existing Access table from another source, such as Excel. In this lecture I'll show you the ins and outs of appending and Excel file into our Access database.

Appending Data from Excel into Access
07:50

In this lecture I'll walk you through importing data from Excel into your Access database. Importing is a quicker, cleaner way to bring in new data if you haven't yet created your table in Access.

Importing Data from Excel into Access
06:48

In this lecture I'll walk your through how to import data from a CSV (comma separate values) file into your Access table. 

Importing Data from a CSV Text File into Access
07:35
+
Database Design in Access
3 Lectures 25:18
Database Design and Table Relationship Basics in Access
07:18

More Complex Database Design Scenarios
03:53

In this lecture you will learn more about table relationships in Microsoft Access. You'll also learn about the importance of Primary and Foreign keys in creating these relationships.

Primary Keys and Foreign Keys in Relationships
14:07
+
Field Properties in Access Tables
3 Lectures 35:41

Size, Format & Input Mask Field Properties
16:04

Default Value, Validation Rules & Indexed Field Properties in Access
15:59
+
Forms in Access
4 Lectures 54:02

In this lecture you'll learn how to create a form using the Form Wizard in Access. You'll also learn how to format your labels and text box controls, use the properties to modify your form and how to select objects in Design View.

Create and Format a Form Using the Form Wizard
14:04

At the end of this lecture, you'll be familiar with many of the controls that can be added to your Access form in the design tools tab. You'll be able to add these and configure them to increase the functionality of your Access forms.

Add Controls to Your Form for Better Usability
15:15

In this lecture, you'll learn how to add combo boxes and navigation buttons to your Access forms. This allows you to create a better user experience for anyone entering data into your form. It also allows you to restrict the data entered, using a combo box drop down, so they can only enter data that exists in a specified field in your table.

Add Navigation Buttons and Drop Down (Combo) Boxes to Your Form
16:08
+
Queries in Access
3 Lectures 34:49

In this lecture, you'll learn how to create your first Query in Access. You'll also learn how to use Sorting and Filtering in your tables to get quick answers from your data.

Introduction to Queries, Sorting and Filtering
10:42

In this lecture we'll create a Query based on the employees in our table who live in Los Angeles using specific criteria in our Access Query.

Create a Query Using a Single Criteria
07:53

In this lecture, we'll look at lots of examples of how to use Criteria in your Queries to make those Queries more powerful.

Criteria in Queries - Many Examples
16:14
+
Reports in Access
2 Lectures 19:07

In this lecture, you'll create a clean, simple employee phone list report.

Introduction to Reports - Create Your First Report
06:10

In this lecture, we'll create two more Reports in Access using different methods.

Create Two More Reports
12:57
+
Options Menu in Access
2 Lectures 19:53

In this lecture, you'll learn how to change General and Current Database options in the Access Options Menu. This allows you to customize the look and activity of your Access interface.

Options - General and Current Database Option Tabs
10:12

In this lecture, you'll learn how to change options in all of the remaining tabs in the Options Menu. This will allow you to customize the look and actions of your Access interface.

Options - Datasheet and Other Option Tabs
09:41
+
Exporting Data
1 Lecture 05:03

In this lecture, you'll learn the important task of Exporting your Access database object to other files, including PDF, CSV (comma separated values text file), and Excel.

Exporting Tables, Queries & Reports to Text, PDF and Excel
05:03
+
Access Glossary - Hands-On Videos of Access Definitions
11 Lectures 01:03:40
Access Glossary Download PDF
04:09

This Access Glossary lecture includes definitions for Access terms starting with A:

AutoForm
An AutoForm is a quick form that automatically includes every field from the table or query on which it is based.

AutoNumber
The AutoNumber format automatically assigns a new number each time a new record is entered. This format works well for primary keys, because it assigns a unique number to each record.

AutoReport
An AutoReport is a quick report that automatically includes every field from the table or query on which it is based.

Preview 05:16

This Access Glossary lecture includes definitions for Access terms starting with B:

Bound Control
A bound control in a form or a report is used to show or edit information from a table or query. An example is a text box.

Button
A button is an image that houses a tool or command.


Preview 03:16

This Access Glossary lecture includes definitions for Access terms starting with C:

Caption
Captions can be column headers in tables or they can be labels for forms.

Cascading Delete
Cascading Delete will delete ALL the related records in the related table when you DELETE  a record in the PRIMARY table. This applies to relationships you have created that enforce referential integrity between tables.

Cascading Update
Cascading update will update ALL the related records in the related table when you change a record in the PRIMARY table. This applies to relationships you have created that enforce referential integrity between tables.

Column Headers
Column headers are the labels above each column in your table. The names of the headers are usually the same as the field names.

Column Selector
The Column Selector is the horizontal bar on top of each column. By clicking the column selector  you can select an entire column in a query. You can also use the column selector to move or delete the entire column.

Control
Controls are graphical objects that you can add to forms and reports. Examples of controls are text boxes, images, labels, graphics, buttons and lines.

C - Captions, Cascade Delete/Update, Column Header, Column Selector, Control
08:58

This Access Glossary lecture includes definitions for Access terms starting with D:

Data Type
The data type of a field specifies and/or limits the type of data that you can enter into a field. This includes types like short text, autonumber, number, date/time, yes/no, and currency.

Datasheet View
Datasheet view is available for tables and queries. This is where you view the results of your query. In a table, this is where you can view, edit, or add data.

Design View
Tables, reports, forms and queries all have Design view. It allows you to add fields and controls, or change the overall formatting and properties of the object.

Default Form
Allows you to assign a specific form to open automatically whenever you open Access.
To set a default form, click Access Options. Then Click Current Database. Then in the Display Form list, select the form that you want to display when the database starts.
Note: Remember that you have to have to reopen your database before the new default will be in effect.

Delimited
In delimited text files, characters like commas or tabs are used to separate fields. Delimited text files are useful for importing or exporting to and from text documents.


D - Data Types, Datasheet & Design View, Default Form, Delimitted
06:35

This Access Glossary lecture includes definitions for Access terms starting with E:

Exporting
Exporting is the process of sending data out to another program such as Excel, a text file, or a PDF.

Expression
An expression is basically the same as a formula. It's used to specify criteria in a query or to do calculations in forms and reports.

E - Exporting and Expressions
04:15

This Access Glossary lecture includes definitions for Access terms starting with F:

Field
A field is a category of information found in columns in table datasheet view.  

Field Properties
Field properties determine how that field's data is displayed and stored.

Foreign Key
A foreign key is a field (or collection of fields) in one table that uniquely identifies a row in another table. The foreign key is found in a second table, but it refers to the primary key in the first table.

Form
A form is an Access object that displays information from the data in your tables. A form is the best way to enter new data, or edit data because you can control how the data is entered.

Fixed Width
In a fixed width file, the fields are separated in columns with spaces between them.

F - Field, Field Properties, Foreign Key, Form, Fixed Width
07:28

This Access Glossary lecture includes definitions for Access terms starting with I:

Importing
Importing is when you bring data into Access from another source.

Indexing
Indexing helps to locate and sort records more quickly. This means the database will maintain a list of the indexed field. It basically does the sorting ahead of time, so it seems faster for the user.

Input Mask
An input mask helps you control the values that you enter into a field.


I - Importing, Indexing and Input Mask
10:41

This Access Glossary lecture includes definitions for Access terms starting with P:

Primary Key
The primary key is the unique identifier for each record in a database.

Property Sheet
The property sheet allows you to change the settings on a control to modify its characteristics or appearance.

P - Primary Key and Property Sheet
04:07

This Access Glossary lecture includes definitions for Access terms starting with R:

Record
A record is one row of data in your database.

Record Selector
A record selector is the little grey box to the left of a record in a table.

Recordset
A Recordset is the result of a query. A Recordset often looks like data in a table, but it isn't actually stored in the query.

Referential Integrity
Referential integrity is how Access makes sure that relationships between records in related tables are valid. 

Rows
Rows are the horizontal divisions of a table. Each row contains a separate record.

Rulers
Rulers are horizontal and vertical bands along the left side and top of the form or report in design view. 

R - Record, Record Selector, Record Set, Referential Intergrity, Rows & Rulers
04:39

This Access Glossary lecture includes definitions for Access terms starting with S:

Show Table Button
The Show Table button opens a dialog box that lets you add a table to the query or the relationships window.

Split Form
A split form gives you two views of your data simultaneously - a form view and a datasheet view.

Subform
A subform is a form within a main form. It can be displayed as a datasheet or as a single or continuous form.


S - Show Table, Spit Form & Sub Form
04:16
1 More Section
About the Instructor
Steve McDonald
4.4 Average rating
4,000 Reviews
48,483 Students
16 Courses
Dedicated Instructor Will Show You How | 47,000+ Students

Learning is easier if you are given the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals.

My talent is taking complex subjects (like Excel) and making them simple to learn. I wasn't always good at technology. There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated countless hours to learning about technology. Now I'm proud to call myself a self-taught technology geek. 

The benefit to you is that I'm a geek who still speaks the language of normal human beings. I will never use a word that you aren't familiar with, without showing you what it means and how to use it to your benefit.

I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.

I am here to guide you on your way to success. You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction.

I'm always happy to help.

I believe in you, and I'm here to support you in your learning process.

Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy.

Sign up for a course today and I'll help you reach the level of success you deserve. 

I'll see you in there!