|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-access-vba-create-your-own-applications/
课程评论：没有评论
课程名称：Microsoft Access VBA - 创建自定义数据库应用程序 课程概述：学习Visual Basic for Applications（VBA）后，您可以创建宏来自动化重复性任务，从而节省大量时间，免去重复进行相同工作的乏味。如果您会在Microsoft Access中使用VBA，您就处于所有Access用户的顶端，因为您能够创建先进的数据库解决方案。通过学习Access VBA，您将能够管理小型到中型数据库、创建自定义函数、利用Access的各种对象的高级功能处理数据、创建可重用的便携程序、使数据动态化以消除无增值活动，并与其他应用程序和平台进行通信。 本课程涵盖的主题和理论包括：使用VBA在Access中的理由、良好的编码习惯、使用变量、常量和数据类型、错误处理、调试代码、使用过程、子程序与函数的区别、转换、日期、数学、字符串、格式与检查函数、输入和消息框、逻辑编程命令、数组、对象及类与实例化等。 本课程将帮助各个水平的学习者充分利用Visual Basic for Applications（VBA）环境。从开发环境开始，逐步学习VBA的各个方面，您将掌握构建自定义解决方案所需的工具和技术，使用Microsoft Access创建高效的数据库应用程序。
When you know Visual Basic for Applications [VBA], you can create macros to automate repetitive tasks which will save you a lot of time and boredom of doing the same thing over and over again. If you know how to use VBA in Microsoft Access, you are on top of all Access users because you know how to create state of the art database solutions. By learning Access VBA, you can:Manage smaller to medium size databases.Create you own defined functions.Manipulate data using advanced features of various objects of MS Access.Create a portable procedure to reuse as and when required.Animate data to get rid of non value added activities.Communicate with other applications and platforms.Topics and theories covered in this course include reasons for using VBA in Access, good coding habits, using variables, constants and data types, error handling, debugging code, using procedures, subroutines vs. functions, conversion, date, math, string, format and is functions, input and message boxes, logical programming commands, arrays, objects, and classes and instantiation. This course will help learners of any level to get the most out of the Visual Basic for Applications (VBA) environment. Starting with the development environment and working through various aspects of VBA, you will learn the tools and techniques needed to build custom solutions using Microsoft Access.
