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

253 views · Published 10 September 2018 · 1:20:50 · Indexed 22 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 extract unique values and unique records from your Query, use of Wildcards to help in less refined Query searches, Parameter Query that prompts the user for a set of criteria prior to generating the Query, Update Query to update number fields, Append Query to add records from one Table to another, Delete Query to delete records that meets specified criteria, Make Table Query to make a Table based upon a Query of data or records, arrange a Form’s layout using the Layout View and how to use Table Formats, Anchoring controls or labels to a part of a Form to keep it in a relative position to the other controls and, or labels, sorting and filtering Form records, creating a Combo Box or drop down list, Option Group for narrowing a front-end user’s choices and adding Form Tab Pages for additional space within the same window without having to scroll.

1. Unique Values & Records
2. Wildcard Query
3. Parameter Query
4. Update Query
5. Append Query
6. Delete Query 
7. Make Table Query
8. Form Layout View & Table Formats
9. Form Anchoring
10. Form Sorting & Filtering Records
11. Enhancing a Form’s Appearance
12. Form Combo Box
13. Form Option Group
14. Form Tab Pages

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: 
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