|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-microsoft-access-2010/
课程评论：没有评论
**Coursera 课程总结：高级 Microsoft Access 2010 教程** 本课程是为已掌握 Microsoft Access 基础知识的学习者设计的，旨在教授其更强大的数据库创建和管理功能。由专业 IT 培训师教授，课程内容循序渐进，重点讲解高级查询选项、窗体设计，以及一系列能简化工作流程的快捷键和提高效率的选项。 **主要学习内容：** * **高级表格设计：** 掌握索引和输入掩码的应用。 * **复杂查询：** 学习使用连接（joins）、联合（unions）和子查询（sub queries）执行高级数据操作，跨越多个数据库和数据源。 * **高级窗体设计与报表：** 学习创建能提升数据收集质量和数量的复杂用户窗体；掌握数据管理和展示的技巧。 * **宏（Macros）：** 深入了解宏的运用，简化在 Access 2010 中管理和访问数据。 * **数据库管理与安全：** 学习执行至关重要的管理和维护功能，创建安全、兼容的数据库，支持 Office 产品及 SQL 等行业标准。 **适合人群：** * 希望解锁 Access 生产力强大功能和安全特性的用户。 * 希望在基于 SQL 及混合环境中实现 Access 解决方案的用户。 * 寻求通过快捷键和宏自动化重复性任务以提高工作效率的 Access 管理员。 **课程亮点：** * 提供可验证的结业证书。 * 包含与屏幕示例匹配的项目文件。 * 课程内容逻辑清晰，易于理解。 * 学习者评价积极，尤其赞赏在数据库安全性和功能挖掘方面的价值。
A Verifiable Certificate of Completion is presented to all students who undertake this course. This Advanced Microsoft Access 2010 Tutorial Video picks up where the InfiniteSkills beginner course leaves off and shows how to work with some of the program's more robust database creation and management features. Presented by a professional IT trainer, the video lessons go point by point through advanced query options and form design, as well as a number of shortcuts and productivity options that can simplify and shift the way you work. Given the advanced subject matter, the order of the Access course is logical and easy to follow. The earliest lessons focus on advanced table design with indexing and input masks. The course shows how to create advanced queries using joins, unions, and sub queries, going step by step where things get complex. Lessons on advanced form design and reporting will allow you to better manage and display your data, and the course's full chapter on Macros make it easy to manage and access data in Access 2010. Project files are included to match the examples onscreen. What You Will Learn - How to perform advanced data manipulation across multiple databases and sources. - How to create complex user forms that will improve the quality and quantity of data collected. - How to perform crucial management and maintenance functions using Access utilities and commands. - How to enhance and develop secure, compatible databases that can be accessed by users working with Office products and common industry standards such as SQL. Who Should Take This Course - Anyone with a basic understanding of Microsoft Access who wants to unlock the program's power user capabilities and security features. - Anyone who wants to implement Access solutions within SQL-based and mixed environments. - Access administrators looking to work faster and smart through shortcuts and macros that automate repetitive tasks. What People Are Saying "I was told we'd have to move everything over to MySQL to get the security we needed, but these tutorials helped me prove otherwise. The lessons on encryption were perfect." - Hank Mascis "I am genuinely impressed with what is capable with Access now. It's improved greatly over the years, and this training and the VBA course has helped me see the light." - V Spinotto
