|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-access-advanced/
课程评论：没有评论
**Coursera Microsoft Access 高级课程内容总结** 本课程旨在帮助学员掌握 Microsoft Access 的高级功能，提升数据库管理和应用开发能力。课程内容涵盖了从深入的数据管理到自动化报表、SQL 运用、宏和 VBA 编程，以及最终应用程序的完善。 **第一模块：高级数据管理** 此模块侧重于表之间的关系和引用完整性，并介绍数据库专业人士使用的语言——SQL。学员将学习如何建立有效的表间关系、保证数据的一致性，并初步接触 SQL 的基本概念。 **第二模块：高级窗体任务** 本模块教授如何创建导航窗体和子窗体，以及利用高级窗体控件构建功能完善的用户界面。学员将学会设计更具交互性和用户友好的窗体。 **第三模块：自动化报表** 此模块专注于如何利用窗体来控制和启动报表，实现数据的快速检索。同时，也将探讨修改窗体属性（如组合框）以及将查询链接到窗体的方法。 **第四模块：SQL 与 Microsoft Access** 本模块深入讲解 SQL 的基础和进阶命令，特别是 JOIN（连接）和子查询的概念。学员将更熟练地运用 SQL 来查询和操作 Access 数据库。 **第五模块：宏与 Visual Basic for Applications (VBA)** 本模块是课程的核心部分，教授如何使用宏和 VBA 来为 Access 数据库添加高级功能。学员将学习创建和应用宏，并通过 VBA 编写自定义程序，实现数据库的自动化和智能化。 **第六模块：完成应用程序** 此模块关注应用程序的收尾工作，包括设置启动选项、数据库的共享/拆分，以及通过创建 ACCDE 文件和加密数据库来增强安全性。学员将学会如何最终完善和保护他们的 Access 应用程序。 **学习资源：** 课程提供可下载的练习手册和随堂练习，包括与课程内容同步的“Lesson”练习以及用于巩固学习的“Skill Sharpeners”练习。建议学员在课程开始时从“Introduction”模块下载相关学习材料。
With every ZandaX Microsoft course, you get a workbook and exercises (downloadable from the "Introduction" module at the start of each course). There are two types of exercises: first of all, exercises to match the lessons (called Lesson 1.1, Lesson 1.2, etc) where you can "follow along" with the instructor, and also Skill Sharpeners, where you are given exercises that will reinforce your learning. These all correspond exactly to the manual. So remember to download them, and the manual, from the "Introduction" module at the start of the course. People tell us that the Skill Sharpeners are a real bonus!MODULE 1: Advanced Data ManagementLearning outcomes: A look into table relationships and referential integrity along with introducing SQL, the language database professionals use to manage a database. Topics covered: Referential IntegrityTable RelationshipsAn Introduction to SQLModal Dialog BoxesMODULE 2: Advanced Form TasksLearning outcomes: Creating navigation forms and sub-forms along with some of the advanced form controls necessary to create a fully rounded user interface. Topics covered: Using SubformsCreating a Navigation FormAdvanced Form ControlsExporting a FormOther Form TasksMODULE 3: Automating ReportsLearning outcomes: Create Reports in Access that can return data quickly by using a form to control and launch reports. Look at modifying form properties including combo boxes and link a query to a form. Topics covered: Creating the Report FormBuilding Query CriteriaMODULE 4: SQL and Microsoft AccessLearning outcomes: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries. Topics covered: Understanding SQLUsing the SELECT StatementUsing SubqueriesUsing SQL JoinsMODULE 5: Macros and Visual Basic for Applications (VBA)Learning outcomes: Using Macros and Visual Basic to create some advanced functionality to your Access Database. Topics covered: Macro BasicsMore about MacrosAccess and VBABuilding Advanced ProceduresUsing VBA in a DatabaseMODULE 6: Finishing the ApplicationLearning outcomes: Look at finishing touches to control how users interact with a database using start-up and sharing options. Identify security measures by creating an ACCDE and encrypting a database with a password. Topics covered: Setting Start Up OptionsSharing/Splitting the DatabaseCreating an ACCDEEncrypting the Database with a Password
