MS Access Basics to Advanced|Session 5|Advanced Queries, Combined Queries, Forms, VBA
This is Session No. 5 of the MS Access Tutorial in which we discuss creating Sub Tables like Data Entry for new activities and Sub Forms,
Queries (Combined and Complex with Relationships), Queries (Advanced for Data Analysis from different tables and some more functions of Forms with Calculations Field.
Here is the complete Play List of MS Access Sessions 1-5: • MS Access
00:00 Intro and recap of previous Sessions (1-4)
01:13 Contents of Session 5
02:24 Creating Sub Tables for activities/ routine data and applying validation and links with main table/ database
12:05 Creating Sub Forms for activities/ routine data and auto filled fields and format
27:46 Queries on Sub Tables of activities/ routine data
29:08 Linking Main and Sub Tables / Sub Datasheets (Master Fields and Child Fields)
32:44 Queries with multiple Tables (Main and Sub Tables and Linking) for extracting information
37:54 Creating Main Form/ Dashboard for the database and linking forms, queries etc. (Part 1)
53:45 What other tutorial you can find on this channel to improve your skills
55:30 Next Session
If you want to learn about software like MS Excel, PowerPoint, MS Word, online data collection tools (like Google Forms, MS Forms, KOBO), How to conduct needs assessment studies, Data management, Windows features and other tips, click the relevant links below:
MS Excel: • MS Excel Basic to Advance, Session 1, Basi...
MS PowerPoint:
• MS PowerPoint
MS Word:
• MS Word & Mail Merge
Online data collection tools Google Form, KOBO, MS Forms:
• Learn KOBO and other Online Data Collectio...
Learning Tips:
• Learning Tips
MS Access:
• MS Access
Project Management:
• Project Development and Management
Windows Features:
• Windows
Other Software:
• Softwares
About the Channel: In this channel, you will find step-by-step and detailed explained tutorials, on different topics mentioned below: Subscribe, watch and share your feedback URL: / ilusplm
Detail Tutorials already shared on the channel (link given above) and upcoming are as below:
Series 1: Learn Online data collection tools like Google Form and Spreadsheet Tutorials videos on how to develop google form and google spread sheet for online data collection. The playlist URL is: • Learn KOBO and other Online Data Collectio...
Series 2: Learn MS Excel (From Basic to Advance level)- Learn MS Excel from Basic to Advance level developing simple tables, databases, data analysis, and all other topics from basic to advance level, like below:
1. Basic of Excel
2. Basics of Data / Data entry and Databases in Excel (Validations)
3. Basics of Data Analysis via Excel (Basics Formulas)
4. Advance level of Data Analysis via Excel (Advanced Formulas, discover more about your data, spot trends & patterns in data)
5. Analysis with Pivot Table (Slicers and Timelines)
6. Conditional Formatting
7. And more
URL: • MS Excel
Series 3: Project Management (Complete Cycle)- In this 3rd series of our Learning Channel, you will learn the complete cycle of project and data management, from basics to advanced level i.e. tools development, databases, implementation, monitoring and evaluation of projects. All the Processes of project management (from inception to proposal submission, implementation, monitoring and end-line evaluation).
URL: • Video
Series 4: MS Power Point
URL: • MS PowerPoint
MS Access: • MS Access
Upcoming Tutorials
1. Conducting Research and Studies
2. Interpretation of data and Reporting
3. M&E
4. Result Based Management /Monitoring (RBM)
5. MS Word,
6. Online data collection tools like KOBO, SurveyCTO and more
7. SPSS
#Access #Queries #Forms #Analysis #SubForms