|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/access-vba-introduction-series1/
课程评论：没有评论
Access VBA (从基础到高级 - 40小时) 课程总结 本课程深入讲解Microsoft Access中的VBA编程，总时长达40小时。课程内容丰富详实，涵盖了Access VBA的方方面面，即使您熟悉Access的前端操作，也能轻松掌握VBA的各项技能。 **课程亮点包括：** * **VBA编辑器详解：** 学习如何进入VBA编辑器并理解其结构。 * **变量作用域：** 掌握变量的生命周期，区分Public、Local和Module级别变量，并学习`Option Explicit`的使用。 * **循环结构：** 熟练运用`For Next`和`Do While`等循环语句，并应用于Recordsets。 * **集合循环：** 遍历Access中的各类对象，包括表、查询、窗体、模块、报表等，实现高效自动化。 * **数组：** 学习`Option Base 1`以及一维和多维数组的实际应用。 * **函数：** 掌握用户自定义函数（UDF）和内置函数的使用。 * **错误处理：** 学习`On Error Resume Next`和`GoTo Err`等错误处理机制，并学会明智地运用它们。 * **与其他Office应用交互：** * **Excel：** 控制Excel应用，实现所需操作。 * **PowerPoint和Word：** 通过Late binding和Early binding技术与PowerPoint和Word应用进行交互。 * **SQL语句的应用：** 在VBA中运用`Select`、`Update`、`Delete`、`Create`、`Drop`、`INSERT INTO`等所有SQL语句。 * **其他重要函数：** 学习`Do CMD`函数和`IF`函数（包括基础、嵌套和与循环及对象结合使用）。 * **文件和文件夹操作：** 使用Scripting Library创建和管理文件及文件夹，体验自动化乐趣。 * **文件对话框：** 理解文件对话框的用途，并学习如何结合Scripting Library从任意文件夹选择数据。 * **仪表盘（Dashboard）：** 课程提供了仪表盘的制作案例，帮助您从一开始就建立自信。 * **答疑与实践：** 课程解答了学员的常见问题，并提供和讲解了部分实践性强的作业。 本课程为您提供一个全面、深入学习Access VBA的平台，让您能够得心应手地自动化和增强您的Access数据库应用。
This course talks about the use of VBA in ms access. It has many sections (35 hours) and each topic is discussed in a detail. If you know access front you are ready to learn access VBA and learn every small , big thing about it.VBA Editor - Let us understand how to go to vba editor and understand its structureScope of Variables - How long a variable exist, public, local and module level. Option Explicit usesLoops - for next with do while - How to write and use it on recordsetsCollection Loops - Loop tables, queries, forms, modules , forms, reports, objects - So amazingArrays - option base1, one dimensional , multi dimensional arrays with practicalsFunctions (UDF and inbuilt)Error Handlers - On error resume next, Go to err - How to use them wiselyConnecting Excel application - Work with excel application and control the way you wantLate binding and early binding with Powerpoint and word applicationsSQL Statements - Select, update, Delete, Create, Drop , INSERT INTO - all sql statements use in VBADo CMD FunctionIF function - Basic , nested IFs , With Loops and objectsFile and Folder - How to create folders, files , how to work with scripting library - So much funFile Dialogs - Why do we need it and how it can be used with scripting library to pick data from any folderDashboard Covered for you to gain confidence from the very beginningYour questions answered - I have taken up students queries and solve themAssignments also shared with you and some are solved as well
