Welcome to the Access 2016 course.
Thank you so much for joining us.
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
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.
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.
In this video I'll take you on a tour of the Microsoft Access dashboard, tools and ribbon.
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.
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.
This Access Glossary lecture includes definitions for Access terms starting with A:
An AutoForm is a quick form that automatically includes every field from the table or query on which it is based.
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.
An AutoReport is a quick report that automatically includes every field from the table or query on which it is based.
This Access Glossary lecture includes definitions for Access terms starting with B:
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.
A button is an image that houses a tool or command.
This Access Glossary lecture includes definitions for Access terms starting with C:
Captions can be column headers in tables or they can be labels for forms.
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 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 are the labels above each column in your table. The names of the headers are usually the same as the field names.
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.
Controls are graphical objects that you can add to forms and reports. Examples of controls are text boxes, images, labels, graphics, buttons and lines.
This Access Glossary lecture includes definitions for Access terms starting with D:
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 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.
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.
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.
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.
This Access Glossary lecture includes definitions for Access terms starting with E:
Exporting is the process of sending data out to another program such as Excel, a text file, or a PDF.
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.
This Access Glossary lecture includes definitions for Access terms starting with F:
A field is a category of information found in columns in table datasheet view.
Field properties determine how that field's data is displayed and stored.
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.
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.
In a fixed width file, the fields are separated in columns with spaces between them.
This Access Glossary lecture includes definitions for Access terms starting with I:
Importing is when you bring data into Access from another source.
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.
An input mask helps you control the values that you enter into a field.
This Access Glossary lecture includes definitions for Access terms starting with P:
The primary key is the unique identifier for each record in a database.
The property sheet allows you to change the settings on a control to modify its characteristics or appearance.
This Access Glossary lecture includes definitions for Access terms starting with R:
A record is one row of data in your database.
A record selector is the little grey box to the left of a record in a table.
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 is how Access makes sure that relationships between records in related tables are valid.
Rows are the horizontal divisions of a table. Each row contains a separate record.
Rulers are horizontal and vertical bands along the left side and top of the form or report in design view.
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.
A split form gives you two views of your data simultaneously - a form view and a datasheet view.
A subform is a form within a main form. It can be displayed as a datasheet or as a single or continuous form.
Learning is easier if you are given the right tools and instruction. In every one of my courses I take my students step-by-step through the tools and knowledge they need to accomplish their goals.
Whether I am teaching How to Publishing Kindle eBooks, How to Learn Excel, or How to Create Killer Content for the Web I always share an inside view of my knowledge about the subject. You get access to all of my secrets.
For over 10 years I have studied strategies to create passive income and how to use passive income to vastly improve the quality of your life.
I have tested many different strategies from investing in rental real estate to building niche websites about my hobbies to publishing Kindle eBooks. I have studied what works and what doesn't work, and I have narrowed my research down to the strategies that work the best for creating financial freedom and an improved quality of life.
Each of my courses is designed to share my hard-earned secrets with you.
I hold nothing back. I won't bore you with all of the strategies that didn't work. I'll get right into the exact steps that I have taken to be successful so that you have the opportunity to replicate them.
Of course, it's no secret that one of my favorite ways to generate truly passive income is through publishing Kindle eBooks. I have published over 100 eBooks and published five of those in print. Many of my books have been bestsellers including my own pottery book The Despicable Five.
Once I developed my Kindle publishing system, learned some formatting secrets, and learned how to use some simple SEO skills, publishing eBooks became remarkably simple.
Even hiring writers, which would seem scary at first, is really easy and even fun when you follow my system.
Using my system, you can publish one or two books and then roll the profits from them into hiring people to write more books for you, so you aren't taking any money out of your pocket.
It starts out as a little passive income snowball and as you add the profits back into the snowball it grows and grows until you are seeing a surprising and exciting amount of passive income.
I retired in 2014 thanks to my eBook publishing success. Now, I'm using my spare time to find the best ways to create passive income. As I find great ways to make money from home I'm more than happy to share what I learn with you.
You'll notice that my new favorite way to create passive income is teaching courses on Udemy. Check out my Udemy Course Creation course to see why I love it so much!
I am here to guide you on your way to success. You can contact me at any step of the way for assistance, even if you're unsure whether my course is the perfect fit for you. Let me know your concerns and I'll point you in the right direction, even if it's to someone else's course.
I'm always happy to help.
Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy for you.
Sign up for a course today! I'll see you in there.