Look Who it Was Random video

Microsoft Access 2010 Tutorial for Beginners – How to Use Access Part 9

183 views · Published 8 October 2018 · 1:03:39 · Indexed 2 October 2026

Channel: Kirt Kershaw · 2018 · Education

Watch on YouTube

This is a Microsoft Access 2010 Database Basic Tutorial for beginners.  In this basic course Access video tutorial, you’ll learn how to export your data to Excel and create charts as well as into text files to import into another database, perform a Mail Merge with Microsoft’s Word, use the Normalization Standard to break Tables down into smaller, more meaningful Tables, how to use the Table Analyzer to break Tables down automatically, how to restructure Tables to do away with any Many to Many relationships that Access does not support, hide and unhide Table columns of data, create Subqueries, how to find unmatched records between two Tables using the Unmatched Query, how to find Duplicate data using the Duplicate Query, use the Criteria Groups Query and the Total feature to group records and summarize data in your Queries and how to use the Crosstab Query.

1. Export Access to Excel
2. Export Access to Text File
3. Use Mail Merge with Word
4. Normalization Standard
5. Table Analyzer
6. Many to Many Relationships 
7. Restructuring Tables
8. Hide, Unhide Table Columns
9. Subquery
10. Unmatched Query
11. Duplicate Query
12. Criteria Group, Total
13. Crosstab Query

All 142 of my Access 2010 training videos contain everything you need to help pass the Microsoft Access 2010 (77-885) exam and become certified!



  

DVD & DOWNLOAD AVAILABLE:
(Use code "YOUTUBE10" for 10% OFF any download) 
https://www.DreamForce.us

SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
http://www.youtube.com/subscription_center?add_user=videotrainingpro

LET'S CONNECT!
-- http://www.linkedin.com/in/kirt-kershaw-33874410

More from this channel