1. Course Overview - MS Access
2. Understanding of MS Access in Database
3. MS Access Basics
4. MS Access Architecture
5. Key difference between DBMS and RDBMS in MS Access with example
6. Main components of RDBMS
7. Major objects of MS Access with example
8. How to install MS Access 365
9. Launching MS Access and Create a new Database
10. Create Table and Add Fields
11. Introduction to Data Types and Field Properties
12. Different Data Types in MS Access with examples
13. Project - Introduction to Project Management Template
14. Project - Hands-on practice with Project Management Template
15. Understanding the Query Definition
16. Create a query using Query Design
17. Introduction to Forms and Types of forms in MS Access
18. Steps to create MS Access Forms using Form Wizard
19. MS Access Reports
20. Generate different MS Access Reports using Report Wizard
21. Generate different MS Access Reports using Report Layout Design
22. Creating projects using MS Access Database Templates
23. How to ImportExport data in MS Access
24. Understanding Microsoft Access Macros
25. Automate database using MS Access Macros
26. How to create a macro from a query in MS Access
27. How to Create Quick Macros in MS Access 365
28. Assignment - Create a Macro to store Shipment Details
29. Project - Introduction to Sales Analysis Pipeline Template
30. Project - Hands-on practice with Sales Analysis Pipeline Template
31. Create a database backup in MS Access
32. How to Save Database in MS Access
33. Understanding the Advanced features of new version of MS Access
34. Assignment - Creating Charts and Graphs in MS Access using new features
35. How to work on Advanced Macros using VBA
36. Practical Assignment - Converting Form Macros into Visual Basic Code
37. Project - Creation of MS Access Primary Objects
38. Project - Create a report using Real Estate Template
39. Project - Introduction to MS Access Inventory Database Template
40. Project - Hands-on practical experience with Inventory Management using Inventor
41. Project - Event Management using MS Access Template
42. Conclusion - Quick recap of course content covered so far
