Microsoft Access Level 2 - Intermediate Access

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

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.