Welcome to the Access 2016 course.
Thank you so much for joining me.
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 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!