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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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

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

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

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.

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.

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.

Now we enter the advanced section of the course. It's gonna get a little more challenging from here, but take your time, bear with me through the intro stuff and it will all make sense in the end. This is where your skills will go to the next level in Access!

Introduction to VBA and the VBA window.

This is where things get serious. We're going to dive into VBA and look at a lot of the features and items involved in writing VBA code.

In this lecture you'll learn to debug your VBA code and set up error handling routines within your code.