MS Access Basics to Advanced| Session 2: Tables Queries and Forms (Time links added)
This is Session No. 2 of MS Access screen recorded Learning Tutorials with time links. In this course, from our Learning and Entertainment Channel, we will go through the MS Access from Basics to Advanced level and will develop a complete database from scratch. Step by Step in multiple sessions, to keep each session upto 1 hour. We will be discussing Tables, Queries, Forms, Reports, Visual Basics (coding and modules).
The playlist of all MS Access Sessions is here: • MS Access
Time Links
00:00 Recap of Session 1 and Intro
01:00 Data Entry Forms and Navigation (Applying Data Entry)
03:55 Input Mask and Validation and adding Further Drop down-list and Value Lists to Fields in the Form
03:55 Input Mask and Validation and adding Further Drop down-list and Value Lists to Fields in the Form
15:50 Adding Footer to the Form
18:00 Trick to develop data source for Schools or other lists
28:48 Advance Drop down-list options, columns width and count (Show/Hide Columns)
34:40 Adding Buttons (Next / Previous/ Add Record etc.) in the Form and Setting
42:05 Tab order
44:40 Adding a field later, when form is already developed
46:00 Form Setup (Popup or static)
47:30 Queries (Basics) and applying criteria
59:20 Queries (Advance) on the main data table and linking with forms
01:00:34 Queries (Advance) Adding like command and linking with a Form
01:09:07 Queries (Advance) Adding button in forms for queries (GO)
01:15:10 Bonus
Session 3 coming soon
Note
30:00 At this place, I said 1 is equal to show and 0 not show, but actually I was simply explaining, here 1 stands for 1 Inch and 0 for 0 inch, so 1 is showing because its width is decided as 1” and vice versa
If you want to learn about other 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,...
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 Coll...
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 Coll...
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. Research and Studies
2. Interpretation of data and Reporting
3. M&E
4. Result Based Management /Monitoring (RBM)
5. MS Word
6. SPSS
#access #msaccess #tutorials #learning