Loading... Please wait...

Blog

Access 2016 Tables: 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.

Read More »


Access 2016: 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.

Read More »


Access 2016: 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.

Read More »


Excel 2016: SmartArt Graphics

Excel 2016 training video on how to work with SmartArt Graphics, which are used to help visually communicate information like with: lists, processes, cycles, hierarchy, relationships, matrixes, pyramids or pictures.

Read More »


Access 2016: 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.

Read More »


Excel 2016: Drawing & Modifying Shapes

Excel 2016 training video on how to draw and modify basic shapes including: circles, squares, lines, ovals, rectangles, and more!

Read More »


Access 2016: Entering Records In Tables

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

Read More »


Excel 2016: Create PivotCharts

Excel 2016 training video on how to create a PivotChart [Pivot Chart] which is used is a way to analyze your data, using an interactive chart.

Read More »


Excel 2016: Customize PivotTable

Excel 2016 training video on how to customize your PivotTables including: grouping, custom calculated field, subtotals and more!

Read More »


Word 2016: Table Formulas, Functions & Calculations

Word 2016 training video on how to add a formula, or function to do calculations with the numbers in your table cells.

Read More »



Sign up to receive information about new videos:

Contact Info

Professional & Certified Training
on Microsoft's Office: Access, Excel, Outlook, PowerPoint, Project and Windows.

Dream Force, LLC
10348 S. 2420 E.
Sandy, UT 84092

800-978-9790
801-278-0892

Kirt Kershaw
Microsoft Certified Trainer

Kirt has over a decade of training experience with Microsoft's Office and Windows. He holds Microsoft Certifications from the year 2000 to the present, and can help you certify too!


Access 2016 Training Videos | Excel 2016 Training Videos | Word 2016 Training Videos | Office 2013 Training Videos | Access 2013 Training Videos | Excel 2013 Training Videos | Outlook 2013 Training Videos | PowerPoint 2013 Training Videos | Project 2013 Training Videos | Word 2013 Training Videos | Office 2010 Training Videos | Access 2010 Training Videos | Excel 2010 Training Videos | Outlook 2010 Training Videos | PowerPoint 2010 Training Videos | Project 2010 Training Video | Word 2010 Training Videos | Office 2007 Training Videos | Access 2007 Training Videos | Excel 2007 Training Videos | Outlook 2007 Training Videos | PowerPoint 2007 Training Videos | Project 2007 Training Videos | Word 2007 Training Videos | Windows 7 Training Videos | Windows Vista Training Videos

Microsoft Office Training Videos Home | DVD | Download | Reviews | About | Contact