Microsoft Access All-In-One Training
This Microsoft Access course includes all three Levels from Beginner to Advanced
- Microsoft Access Level 1 - Beginner
- Microsoft Access Level 2 - Intermediate
- Microsoft Access Level 3 - Advanced
Material recorded with Access 2016 but works in 2010, 2013, 2016 and 2019.
As your instructor I will use my 18+ years of Access training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Access.
At completion of this course you will master Access skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks. Below are just a few of the topics that you will master:
- Create powerful, effective Access Databases
- Enter, edit, update, search, sort and filter Table records
- Set defaults and validate data for more accurate data entry
- How to quickly edit, filter and search records in a Form
- Add option controls, command buttons and drop-down lists for faster data entry and accuracy in Forms
- Add custom fields to perform calculations: Sum, Count, Average and more
- Add, sort and filter groups as well as keeping them from splitting across pages in your Reports
- Use criteria in a Query to dramatically refine your search
- View unique records and use Actions Queries to Update, Add and Delete records fast
- Automate data entry and accuracy dramatically by creating Macros and much more…
- This course was created with Access 2016. But, all features will work in Access 2010, 2013, 2016, 2019 and most in 2007
- You will need Microsoft Access installed on your computer to follow along and complete the exercise files
- Build a solid understanding on the Basics of Microsoft Access
- How to create an Access Database from scratch
- Master Microsoft Access from Beginner to Advanced
- Create Tables to store and organize all raw data
- Use a Query to search and retrieve data fast
- Enter and view records in a more organized layout using Forms
- Generate very detailed, professional looking Reports
- Taught by Microsoft Certified Trainer (MCT) with over 18 years of Access training
- Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
- Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
- Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
Access 2016 training video on the basic introduction to Access 2016 as a relational database, or a database that breaks the data down into its smallest most meaning parts, or tables and then links those tables in a relationship to pull data as needed, and thereby making process more efficient for both user and computer.
Access 2016 training video on the basic overview of the application itself including: startup screen, Ribbon, Navigation pane, working area, Status Bar and more!
Access 2016 training video on the new Tell Me What You Want that is part of the Help feature, and is used to find answers to questions about features in Access, as well as execute commands.
Access 2016 training video on how to change the Office Theme which is basically the color scheme of the application's layout, as well as default database folder, setting User name and Initials.
Access 2016 training video on the Quick Access Toolbar which you can customize it with any commands of your choice, and access them in a single click.
Access 2016 training video on how to customize the Ribbon including adding and removing tabs, commands and groups.
Access 2016 training video on how to customize the Datasheet's appearance including it's font size.
Access 2016 training video on the three Document Window Options which is how you want the Access working windows to operate including: Overlapping Windows, Tabbed Documents and Display Document Tabs.
Access 2016 training video on the basics of the four major objects in Access including: Table, Query, Form and Report.
Access 2016 training video on how to create a new database file for your tables, queries, forms and reports.
Access 2016 training video on how to create a table that is used to store raw data, and which queries, forms and reports are built upon.
Access 2016 training video on how to enter in records in a table efficiently with some tips, tricks and shortcuts.
Access 2016 training video on how to export a table to XPS, or PDF file format to send to someone who doesn't have Access on their computer, or as a quick snapshot of a table.
Access 2016 training video on table structuring in a way that allows you to create relationships between tables from a poorly designed database.
Access 2016 training video on tips for managing your tables including: deleting, renaming and hiding tables, table descriptions, and object groups.
Access 2016 training video basics on creating Primary, Composite and Foreign keys, as well as how and when to use them in your tables, prior to creating relationships between two or more tables.
Access 2016 training video on how to setup up tables to relate to one another by creating Primary and Foreign key fields.
Access 2016 training video on how to create a One-to-Many relationship between two tables, where you can have basically one record linked to many other records like: one customer that has many orders. This also includes enforcing referential integrity, cascade updates to related fields and deleting related records.
Access 2016 training video on how to create a One-to-One relationship between two tables, where you can have basically one record linked to one other record like: one client that has one billing contact for that client. This also includes enforcing referential integrity, cascade updates to related fields and deleting related records.
Access 2016 training video on denormalizing an a table, or breaking tables down into smaller, more meaningful parts i.e. tables. For example, a poorly designed database would have all the information like: clients, customers, orders, shipping, products loaded into one table, instead of one table for each meaningful part.
Access 2016 training video on how to manage your table's data including how to: enter, modify, update and delete records.
Access 2016 training video on subdatasheets which are datasheets nested within datasheets, or like tables within tables, but that are related. In other words, it's the ability to look up related data in another table without leaving your current table's datasheet view.
Access 2016 training video on how to create a query by using the Query Wizard, which is a step by step process where Access asks you questions and based upon your answers creates your query!
Access 2016 training video on how to create a query by Design, or in the design view including adding: tables and fields from those tables to the query.
Access 2016 training video on how to set criteria for your query including: text, numbers, dates, blank, empty fields.
Access 2016 training video on how to create a field that performs a calculation on other fields using functions, or formulas.
Access 2016 training video on how to group your records, and add a calculation to that group by using the Totals feature.
Access 2016 training video on how to customize your table's or query's datasheet including: banded rows, alternating colors, font types, cell effects and more!
Access 2016 training video on the basic introduction to a Form, and includes how to sort and filter records in a form.
Access 2016 training video on how to create a Form instantly! Also, I'll show you here how to edit your Instant Forms including working with stacked and tabular layouts, and how to remove them as well.
Access 2016 training video on how to use the Form Wizard to create a Form quickly for your database.
Microsoft Access 2016 training video on how to edit and modify the database's Forms in the Design View including: moving, aligning, resizing labels, text boxes or fields as well as changing the Tab Order, or the order of fields you can tab to in the Form view.
Microsoft Access 2016 training video on the different type of views to view, print or edit your reports including: Report View, Layout View, Design View and Print Preview.
Microsoft Access 2016 training video on how to create an instant report including the different report views: Layout, Design and Print Preview.
Microsoft Access 2016 training video on how to create a Report step by step using the Report Wizard!
Microsoft Access 2016 training video on how to create a field that you can add a formula, or function to and do some calculations by itself, or with other fields in your reports!
Microsoft Access 2016 training video on how to format numbers in your Reports by working with the Formatting Controls, which include formatting to currency, decimal places and data formats.
Microsoft Access 2016 training video on how to apply a Theme to your Reports, which is a collection of complimentary fonts and colors.
Microsoft Access 2016 training video on how to insert images into your Reports, and thereby making them more aesthetically pleasing.
Microsoft Access 2016 training video on how to insert background images, or watermarks into your Reports and make them appear more aesthetically pleasing, or to help with identification of the topic or type of report a person is reading.
Microsoft Access 2016 training video on how to insert background images, or watermarks into your Reports and make them appear more aesthetically pleasing, or to help with identification of the topic or type of report a person is reading.
Microsoft Access 2016 training video on how to insert hyperlinks into your Reports, in the Report View, which can be helpful for outside referencing of data found within the Report.
- Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
- Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
- Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
Microsoft Access 2016 training video on how to use Data Defaults and Data Validation, which includes saving time entering data with default data, and get accurate data entry by controlling the user's input with Data Validation.
Microsoft Access 2016 training video on how to use Show Column History, which tracks and keeps a history of previous data entered.
Microsoft Access 2016 training video on how to use Input Masks, which is used as a pattern for all data to be entered into a field including how much data and where.
Microsoft Access 2016 training video on how to use Lookup Fields, which is used to lookup the details of a field prior to selecting it from a drop-down list.
Microsoft Access 2016 training video on how to create an Inner Join and an Outer Join, which are used to either all related records from two tables as long as both contain a field with the same data, or all records from the first table with only matching records in the specified join fields of the other table.
Microsoft Access 2016 training video on how to Join Unrelated Data, which is used to you have two tables with no fields in common.
Microsoft Access 2016 training video on how to create a Self Join, which is used to join a table to itself when it contains two fields with duplicate data, but in different records.
Microsoft Access 2016 training video on how to create a Top Values Query, which is used to find the top number or percentage of items, like the top 5.
Microsoft Access 2016 training video on how to use Unique Values and Unique Records, which are either used to omit records with duplicates in your query, or used to return only unique records based on all field in the underlying data source that makes up that record.
Microsoft Access 2016 training video on how to use Unique Values and Unique Records, which are either used to omit records with duplicates in your query, or used to return only unique records based on all field in the underlying data source that makes up that record.
Microsoft Access 2016 training video on how to create a Parameter Query, which is used to prompt the user prior to opening the Query for additional criteria.
Microsoft Access 2016 training video on how to create an Update Query, which is an Action Query and it's used to make bulk changes to values within a table.
Microsoft Access 2016 training video on how to create an Append Query, which is an Action Query and it's used to add records from one table into another.
Microsoft Access 2016 training video on how to create a Delete Query, which is an Action Query and it's used to delete records in bulk from a table.
Microsoft Access 2016 training video on how to create a Make Table Query, which is an Action Query and it's used to insert records from a query into a new table.
Microsoft Access 2016 training video on how to work in the Layout View of a Form, which is a way to make design changes to a database element in a more general format, as opposed to the Design View. This includes grouping fields together in a uniformed control table like format.
Microsoft Access 2016 training video on how to Anchor Controls to your Form, which means when the front-end user resizes the form the controls will stay in their relative position to the other controls in the Form.
Microsoft Access 2016 training video on how to Filter and Sort Records in a Form.
Microsoft Access 2016 training video on how to enhance the appearance of your Forms including: drawing basic shapes, adding a Form Header and Footer, creating additional labels, inserting images, and how to hide the header while it's under construction, as well as adding a Form Title.
Microsoft Access 2016 training video on how add a Combo Box to your Form, which is a drop-down list of data for the front-end user to choose from.
Microsoft Access 2016 training video on how add an Option Group to your Form, which is used to give the front-end user a quick way to select from a choice of options.
Microsoft Access 2016 training video on how add Form Tab Pages, which is a Form containing extra tabs to add additional fields to; as a way to organize data and help speed up the front-end user's data entry by not having to scroll back and forth and search through dozens of fields.
Microsoft Access 2016 training video on how to add a Command Button, which is used to for various purposes including: open, close, print Forms as well as adding code to it to open up other related records in other Forms.
Microsoft Access 2016 training video on how to add a Subform into your Form, which is another Form of related data that you can view in the main form.
Microsoft Access 2016 training video on how to organize records in your Reports including: the many ways of adding fields into your Report, adding labels as page headers, and using the Layout View to visible resize a field to fit the text therein tight.
Microsoft Access 2016 training video on how to Add, Sort and Filter Groups in your Reports including: grouping records together and after sorting by title, adding a calculating total, or sum for each group as well as filtering the Groups.
Microsoft Access 2016 training video on how to do Advance Formatting to your Reports including: formatting gridlines, column titles, change alternate row color, Can Grow that allows text to wrap vertically within a text box, conditional formatting, displaying the total record count, Data Bars, hiding duplicate data and inserting page numbers.
Microsoft Access 2016 training video on how to Keep Groups Together in your Reports, which keeps them from being broken, or splitting across pages.
Microsoft Access 2016 training video on how to use the Force New Page, which forces a page break before, or after a selected section like a Page Header.
Microsoft Access 2016 training video on how to use Sum Fields, or add to number data type fields up together in a third field i.e. Stock + On Order = Total Inventory.
Microsoft Access 2016 training video on how to add a Subreport into a Report, which is inserting one Report into another for quick referencing.
Microsoft Access 2016 training video on how to create Mailing Labels in a Report.
Microsoft Access 2016 training video on how to Import Excel data into your Database, and saving that Import which can be executed again and again without going through all the steps.
Microsoft Access 2016 training video on how to Import a Text or CSV (Comma Separated Value) file into your database.
Microsoft Access 2016 training video on how to export data from your database to Microsoft Word.
Microsoft Access 2016 training video on how to export a Report to a CSV (Comma Separated Value) file.
Microsoft Access 2016 training video on how to export data from your database to Microsoft Excel to use proprietary features to Excel including creating Charts with your Access database data.
Microsoft Access 2016 training video on how to export data from your database into a Text file for other databases to import.
Microsoft Access 2016 training video on how to use the Mail Merge feature in Microsoft Word with your data in Access to create labels, letters and envelopes.
- Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
- Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
- Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
Microsoft Access 2016 training video on how to break Tables down into smaller, more meaningful Tables through the Normalization Standard process in Access.
Microsoft Access 2016 training video on how to straighten out databases created by less-knowledgeable users by using the Table Analyzer Wizard in Access.
Microsoft Access 2016 training video on how to create a Many-to-Many relationship between two Tables in Access.
Microsoft Access 2016 training video on how to restructure poorly designed Tables to be able to create relationships with other Tables in Access.
Microsoft Access 2016 training video on how to hide a column in a Table in Access.
Microsoft Access 2016 training video on how to Query within a Query also know as a Subquery in Access.
Microsoft Access 2016 training video on how to find unmatched fields between two Tables using the Unmatched Query in Access.
Microsoft Access 2016 training video on how to find duplicates data in a Table or Query using Duplicate Query in Access.
Microsoft Access 2016 training video on how to group and summarize records using the Criteria field in Access.
Microsoft Access 2016 training video on how to create a summary of calculation of intersecting values of row and column headings using the Crosstab Query in Access.
Microsoft Access 2016 training video on how to record a collection of actions used to automatically run a set of tasks by creating Macros in Access.
Microsoft Access 2016 training video on how to assign a Macro to a command button in Access.
Microsoft Access 2016 training video on how to automatically compare records in one Form, and to find its match in another Form using the Where Condition in Access.
Microsoft Access 2016 training video on how to require data to be entered into a field before saving the record by creating a Require Data Entry Macro in Access.
Microsoft Access 2016 training video on how to display a message box to alert front-end user about required data by creating a Message Macro in Access.
Microsoft Access 2016 training video on how to automatically fill in one field based upon data in another with the Automate Macro in Access.
Microsoft Access 2016 training video on how to apply formatting to a field based upon a condition using Conditional Formatting in Access.
Microsoft Access 2016 training video on how to insert a chart into a Report in Access.
Microsoft Access 2016 training video on how to create and modify columns in a Report in Access.
Microsoft Access 2016 training video on how to automatically cancel a print job of a Report in Access.
Microsoft Access 2016 training video on how to export a Report into a PDF or XPS file in Access.
Microsoft Access 2016 training video on how to link to another Table in another database in Access.
Microsoft Access 2016 training video on how to learn and add details about your database in Access.
Microsoft Access 2016 training video on how to speed up and compress the size of your database using the Compact & Repair in Access.
Microsoft Access 2016 training video on how to create a backup of your database in Access.
Microsoft Access 2016 training video on how to password protect your database in Access.
Microsoft Access 2016 training video on how to find what other objects are dependent upon, before deleting them, using Object Dependency in Access.
Microsoft Access 2016 training video on how to create a detailed Report about some, or all objects in your database using Database Documenter in Access.
Microsoft Access 2016 training video on how to analyze your database and get suggested performance improvements with Performance Analyzer in Access.
Microsoft Access 2016 training video on how to import XML (Extensible Markup Language) data into your database in Access.
Microsoft Access 2016 training video on how to export Access into XML (Extensible Markup Language) in Access.
Microsoft Access 2016 training video on how to link to Microsoft Outlook Contacts in Access.
Microsoft Access 2016 training video on how to attach files to each record using Table Attachment Fields in Access.
Microsoft Access 2016 training video on how to save your database to a previous version of Access.
Microsoft Access 2016 training video on how to create Forms to help a front-end user navigate to other objects using Navigation Forms in Access.
Microsoft Access 2016 training video on how to control the front-end user’s access to the database by creating a Switchboard including: Main Switchboard, Report Switchboard and a Form Switchboard in Access.
Microsoft Access 2016 training video on how to modify Switchboards in Access.
Microsoft Access 2016 training video on how to set startup options for any Form when opening your database in Access.
Microsoft Access 2016 training video on how to distribute a split database: the front-end to computers and the back-end onto the network, or server in Access.
Microsoft Access 2016 training video on about the four different access modes to your database including: Open, Open Read-Only, Open Exclusive, and Open Exclusive Read-Only in Access.
Microsoft Access 2016 training video on how to setup a folder known to Access as a location that should not be checked by the Trust Center, so as to prevent any warnings about macros, ActiveX controls, or data connections that the Trust Center would typically see as harmful.
Microsoft Access 2016 training video on how to prevent unauthorized users from deleting, editing and copying your VBA (Visual Basic Application) code in Access.
Microsoft Access 2016 training video on how to prevent Forms, Reports and Modules from being viewed and modified in the Design View, and creating, adding, deleting or changing references to database, or object libraries, changing source code and importing or exporting Forms, Reports or Code Modules in Access.
Microsoft Access 2016 training video on how to add your Digital Signature, or Digitally Sign your database to let others who you distribute it to know that the content is safe and can be trusted in Access.
Microsoft Access 2016 training video on how to hide empty records and their corresponding labels in a Report in Access.
Microsoft Access 2016 training video on how to create a Table of Contents in Access.
Microsoft Access 2016 training video on how to be able to create a Data Type Field Yes/No with its Display Control set to Text Box. As well as customizing it to text and color.