Elevate your Microsoft Access skills in this intermediate tutorial designed for users with foundational knowledge who want to create more powerful databases and perform advanced data analysis. Learn to master intermediate Access features including advanced select queries, action queries, parameter queries, and cross-tab queries over 1 hour and 23 minutes of comprehensive instruction. Explore calculated fields, built-in functions like DateDiff, Month, and If, multi-table queries, and data summarization techniques. The tutorial covers essential topics such as creating and filtering queries, using AND/OR/BETWEEN conditions, implementing wild cards, working with calculated fields, utilizing various functions, creating action queries to modify data, understanding query join types, and developing parameter queries. Perfect for professionals, students, and data enthusiasts looking to improve their efficiency with queries, tables, and forms in this powerful database management system that seamlessly integrates with other Microsoft Office applications.
Overview
Syllabus
Start 0:00
Introduction 0:09
Creating a Query 1:44
Using Criteria to Filter Queries 6:28
Data Type Mismatch 10:11
Using AND, OR, & BETWEEN Conditions 11:50
Sorting Queries 16:35
Using Table Fields with Our Criteria 20:54
Wild Cards and Saving Queries 24:07
Calculated Fields 26:12
Month and MonthName Functions 30:39
Dated IFF Function - 39:25
IF Function - 44:27
Data Summaries 50:25
Crosstab Query 55:28
Creating a Table with Action Queries 1:03:04
Updating Data with Action Queries 1:04:06
Delete Query 1:08:47
Appending Tables 1:10:23
Query Join Types 1:12:52
Creating Parameter Queries 1:15:53
Conclusion 1:22:40
Taught by
Learnit Training
