Скачать или смотреть 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:    • Видео  
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