Library

Course: Microsoft Access 2016 - Access from Beginner to Advanced

Microsoft Access 2016 - Access from Beginner to Advanced

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

Microsoft Access 2016 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, and 2016. 

As your instructor I will use my 16+ 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, as well have all the training you need to help pass the Access 2016 (77-730) Exam and become certified, like me. 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…
Basic knowledge
  • This course was created with Access 2016. But, all features will work in Access 2010, 2013, 2016 and most in 2007
  • You will need Microsoft Access installed on your computer to follow along and complete the exercise files
What you will learn
  • 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 Certified Microsoft Office Access 2016 Specialist with over 16 years of Access training
Curriculum
Lectures quantity: 134
Common duration: 16:55:58
Access 2016 Level 1 - Beginner
  • Level 1 - Exercise Files, Instructor's Notes, Quiz & Answers  
    1. 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
    2. 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
    3. 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
Basics
  • Basic Database Introduction  

    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.

  • Basic Overview  

    Access 2016 training video on the basic overview of the application itself including: startup screen, Ribbon, Navigation pane, working area, Status Bar and more!

  • New Tell Me What You Want or Help Feature  

    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.

  • Change Office Theme  

    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.

  • Quick Access Toolbar  

    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.

  • Customize Ribbon  

    Access 2016 training video on how to customize the Ribbon including adding and removing tabs, commands and groups.

  • Datasheet Appearance  

    Access 2016 training video on how to customize the Datasheet's appearance including it's font size.

  • Document Window Options  

    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.

  • Basic Introduction to Tables, Queries, Forms & Reports  

    Access 2016 training video on the basics of the four major objects in Access including: Table, Query, Form and Report.

  • Create a New Database  

    Access 2016 training video on how to create a new database file for your tables, queries, forms and reports.

Tables
  • Creating Tables  

    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.

  • Entering Records in Tables  

    Access 2016 training video on how to enter in records in a table efficiently with some tips, tricks and shortcuts.

  • Export Table to XPS or PDF  

    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.

  • Table Structuring  

    Access 2016 training video on table structuring in a way that allows you to create relationships between tables from a poorly designed database.

  • Tips for Managing Tables  

    Access 2016 training video on tips for managing your tables including: deleting, renaming and hiding tables, table descriptions, and object groups.

  • Basics on Primary, Composite & Foreign Keys  

    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.

  • Basic Introduction Setting Up Tables for Relationships  

    Access 2016 training video on how to setup up tables to relate to one another by creating Primary and Foreign key fields.

  • Create One-to-Many Relationships  

    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.

  • Create One-to-One Relationships  

    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.

  • Denormalization or Denormalize  

    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.

  • Managing Table Data  

    Access 2016 training video on how to manage your table's data including how to: enter, modify, update and delete records.

  • Sorting Records  

    Access 2016 training video on how to sort your table's records.

  • Filtering Records  

    Access 2016 training video on how to filter your table's records.

  • Subdatasheets  

    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.

Queries
  • Query Wizard  

    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!

  • Basics on Creating a Query in Design View  

    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.

  • Setting Query Criteria  

    Access 2016 training video on how to set criteria for your query including: text, numbers, dates, blank, empty fields.

  • Add a Calculating Field  

    Access 2016 training video on how to create a field that performs a calculation on other fields using functions, or formulas.

  • Grouping Records & Totals  

    Access 2016 training video on how to group your records, and add a calculation to that group by using the Totals feature.

  • Customize Table Or Query Datasheet  

    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!

Forms
  • Basic Introduction to Forms  

    Access 2016 training video on the basic introduction to a Form, and includes how to sort and filter records in a form.

  • Create Forms Instantly  

    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.

  • Form Wizard  

    Access 2016 training video on how to use the Form Wizard to create a Form quickly for your database.

  • How to Modify & Edit Forms  

    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.

Reports
  • Report Views  

    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.

  • How to Create Instant Reports  

    Microsoft Access 2016 training video on how to create an instant report including the different report views: Layout, Design and Print Preview.

  • Step by Step Report Wizard  

    Microsoft Access 2016 training video on how to create a Report step by step using the Report Wizard!

  • Ceate Custom Calculating Fields  

    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!

  • Formatting Controls  

    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.

  • Applying Themes  

    Microsoft Access 2016 training video on how to apply a Theme to your Reports, which is a collection of complimentary fonts and colors.

  • Inserting Images  

    Microsoft Access 2016 training video on how to insert images into your Reports, and thereby making them more aesthetically pleasing.

  • Insert Background Images & Watermarks  

    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.

  • Inserting Hyperlinks  

    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.

  • Prepare for Print  

    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.

Access 2016 Level 2 - Intermediate
  • Level 2 - Exercise Files, Instructor's Notes, Quiz & Answers  
    1. 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
    2. 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
    3. 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
Advanced Tables
  • Data Defaults & Validation Rule  

    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.

  • Show Column History  

    Microsoft Access 2016 training video on how to use Show Column History, which tracks and keeps a history of previous data entered.

  • Input Masks  

    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.

  • Lookup Fields  

    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.

Advanced Queries
  • Inner & Outer Data Joins  

    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.

  • Join Unrelated Tables  

    Microsoft Access 2016 training video on how to Join Unrelated Data, which is used to you have two tables with no fields in common.

  • Self Join  

    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.

  • Top Values Query  

    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.

  • Unique Values & Records  

    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.

  • Wildcard Query  

    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.

  • Parameter Query  

    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.

  • Update Query  

    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.

  • Append Query  

    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.

  • Delete Query  

    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.

  • Make Table Query  

    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.

Advanced Forms
  • Layout View & Table Formats  

    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.

  • Anchor Controls  

    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.

  • Filter & Sort Records  

    Microsoft Access 2016 training video on how to Filter and Sort Records in a Form.

  • Enhance Appearance  

    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.

  • Combo Box  

    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.

  • Option Controls Group  

    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.

  • Form Tab Pages  

    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.

  • Command Button  

    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.

  • Subform  

    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.

Advanced Reports
  • Organizing Records  

    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.

  • Adding, Sorting & Filtering Groups  

    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.

  • Advanced Formatting  

    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.

  • Keep Groups Together  

    Microsoft Access 2016 training video on how to Keep Groups Together in your Reports, which keeps them from being broken, or splitting across pages.

  • Force New Page  

    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.

  • Adding Summary Field  

    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.

  • Add Subreports  

    Microsoft Access 2016 training video on how to add a Subreport into a Report, which is inserting one Report into another for quick referencing.

  • Create Mailing Labels  

    Microsoft Access 2016 training video on how to create Mailing Labels in a Report.

  • Import Excel  

    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.

  • Import Text & CSV Files  

    Microsoft Access 2016 training video on how to Import a Text or CSV (Comma Separated Value) file into your database.

  • Export to Word  

    Microsoft Access 2016 training video on how to export data from your database to Microsoft Word.

  • Export to CSV File  

    Microsoft Access 2016 training video on how to export a Report to a CSV (Comma Separated Value) file.

  • Export to Excel for Charts & PivotTables  

    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.

  • Export to Text File  

    Microsoft Access 2016 training video on how to export data from your database into a Text file for other databases to import.

  • Mail Merge with Microsoft Word  

    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.

Access 2016 Level 3 - Advanced
  • Level 3 - Exercise Files, Instructor's Notes, Quiz & Answers  
    1. 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
    2. 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
    3. 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
More Advanced Tables
  • Normalization Standard  

    Microsoft Access 2016 training video on how to break Tables down into smaller, more meaningful Tables through the Normalization Standard process in Access.

  • Table Analyzer  

    Microsoft Access 2016 training video on how to straighten out databases created by less-knowledgeable users by using the Table Analyzer Wizard in Access.

  • Many to Many Relationships  

    Microsoft Access 2016 training video on how to create a Many-to-Many relationship between two Tables in Access.

  • Restructuring Tables  

    Microsoft Access 2016 training video on how to restructure poorly designed Tables to be able to create relationships with other Tables in Access.

  • Hide Table Columns  

    Microsoft Access 2016 training video on how to hide a column in a Table in Access.

More Advanced Queries
  • Subqueries  

    Microsoft Access 2016 training video on how to Query within a Query also know as a Subquery in Access.

  • Unmatched Query  

    Microsoft Access 2016 training video on how to find unmatched fields between two Tables using the Unmatched Query in Access.

  • Duplicate Query  

    Microsoft Access 2016 training video on how to find duplicates data in a Table or Query using Duplicate Query in Access.

  • Criteria Groups Query  

    Microsoft Access 2016 training video on how to group and summarize records using the Criteria field in Access.

  • Crosstab Query Wizard  

    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.

Macros
  • Create Macros  

    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.

  • Macro Button  

    Microsoft Access 2016 training video on how to assign a Macro to a command button in Access.

  • Where Condition  

    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.

  • Require Data Entry Macro  

    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.

  • Display Message Macro  

    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.

  • Automated Macro  

    Microsoft Access 2016 training video on how to automatically fill in one field based upon data in another with the Automate Macro in Access.

More Advanced Forms & Reports
  • Conditional Formatting  

    Microsoft Access 2016 training video on how to apply formatting to a field based upon a condition using Conditional Formatting in Access.

  • Report Charts  

    Microsoft Access 2016 training video on how to insert a chart into a Report in Access.

  • Multiple Columns & Groups  

    Microsoft Access 2016 training video on how to create and modify columns in a Report in Access.

  • Cancelling Print Job  

    Microsoft Access 2016 training video on how to automatically cancel a print job of a Report in Access.

  • Export to PDF or XPS  

    Microsoft Access 2016 training video on how to export a Report into a PDF or XPS file in Access.

Maintaining Database
  • Linking to Other Database Tables  

    Microsoft Access 2016 training video on how to link to another Table in another database in Access.

  • Database Properties  

    Microsoft Access 2016 training video on how to learn and add details about your database in Access.

  • Compact & Repair Database  

    Microsoft Access 2016 training video on how to speed up and compress the size of your database using the Compact & Repair in Access.

  • Backup Database  

    Microsoft Access 2016 training video on how to create a backup of your database in Access.

  • Password Protect  

    Microsoft Access 2016 training video on how to password protect your database in Access.

  • Object Dependency  

    Microsoft Access 2016 training video on how to find what other objects are dependent upon, before deleting them, using Object Dependency in Access.

  • Database Documenter  

    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.

  • Performace Analyzer  

    Microsoft Access 2016 training video on how to analyze your database and get suggested performance improvements with Performance Analyzer in Access.

Database Integration
  • Import XML Data  

    Microsoft Access 2016 training video on how to import XML (Extensible Markup Language) data into your database in Access.

  • Export to XML  

    Microsoft Access 2016 training video on how to export Access into XML (Extensible Markup Language) in Access.

  • Link to Outlook Contacts  

    Microsoft Access 2016 training video on how to link to Microsoft Outlook Contacts in Access.

  • Table Attachment Field  

    Microsoft Access 2016 training video on how to attach files to each record using Table Attachment Fields in Access.

  • Save As Previous Version  

    Microsoft Access 2016 training video on how to save your database to a previous version of Access.

  • Navigation Forms  

    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.

  • Switchboard  

    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.

  • Modifying Switchboards  

    Microsoft Access 2016 training video on how to modify Switchboards in Access.

  • Form Startup & Options  

    Microsoft Access 2016 training video on how to set startup options for any Form when opening your database in Access.

Distribute Database & Security
  • Split Database  

    Microsoft Access 2016 training video on how to split a database in Access.

  • Distributing Split Database  

    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.

  • Database Access Modes  

    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.

  • Trusted Location  

    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.

  • Protect VBA Code  

    Microsoft Access 2016 training video on how to prevent unauthorized users from deleting, editing and copying your VBA (Visual Basic Application) code in Access.

  • File Protection ACCDE  

    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.

Bonus!
  • Digitally Sign Database  

    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.

  • Hide Empty Record Labels in Reports  

    Microsoft Access 2016 training video on how to hide empty records and their corresponding labels in a Report in Access.

  • Create Table of Contents  

    Microsoft Access 2016 training video on how to create a Table of Contents in Access.

  • Custom Display Control for Text Box  

    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.

reviews (0)
Average rating
0
0 voices
Detailed rating
5 stars
0%
4 stars
0%
3 stars
0%
2 stars
0%
1 stars
0%