|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-access-2016-intermediate/
课程评论：没有评论
**掌握 Access 2016 - 中级课程内容摘要** 本课程旨在帮助学习者在掌握 Access 2016 基础知识的基础上，进一步提升数据库设计和管理能力。课程由经验丰富的 Microsoft Access 培训师 Kathy Jones 主讲，将深入探讨关系型数据库的设计原理，并重点关注以下关键主题： **核心学习内容：** * **关系型数据库设计：** 学习如何构建结构合理、性能优越的数据库，确保数据完整性。 * **表关系管理：** 掌握如何管理不同表之间的关系，实现数据的有效关联和检索。 * **高级查询技巧：** 学习使用联接查询、参数查询等高级查询功能，从多个表中提取和处理数据。 * **数据验证：** 了解如何通过字段验证规则，确保输入数据的准确性和一致性，维护数据质量。 * **子数据表：** 学习使用子数据表，方便地查看和管理相关联的数据。 * **数据库组织：** 探讨如何优化数据库结构，提升查询和操作的效率及性能。 * **报表定制：** 学习如何定制报表，以特定格式检索和展示所需数据，并添加计算字段，使报表更具信息量。 **课程特色：** * **实战导向：** 课程将基于 Access 2016，通过实际操作演示，帮助学习者构建功能性的关系型数据库。 * **深入讲解：** 课程内容超越基础知识，深入探讨数据完整性、性能优化和高级功能。 * **高质量内容：** 提供超过两小时的高清教学内容，采用“独特引人入胜”的 Bigger Brains 师生互动教学风格。 **学习目标：** 通过本课程的学习，学员将能够独立设计和构建功能完善的关系型数据库，并熟练掌握对数据库对象（如表、查询、报表）的定制化操作。
Create custom databases with this modern data-crunching powerhouse!Microsoft Access lets ordinary users develop powerful databases customized to their business needs.Building a simple database is one thing, but designing it for optimum performance and data integrity is much more difficult. In this course, experienced Microsoft Access trainer Kathy Jones will build upon the fundamentals of tables, queries, forms, and reports covered in the Basics course. Starting with the essentials of relational database design, this course will expand your knowledge of Microsoft Access by covering topics such as table relationships, query joins, sub-datasheets, field validation, parameter queries, and more. You'll also learn to customize your reports to retrieve exactly the data you need in the format you need it.Topics covered include:Designing a relational databaseJoining tables to retrieve data from unrelated tablesManaging table relationshipsValidating data entered into a database to maintain data integrityUsing advanced queries to manipulate dataOrganizing a database for efficiency and performanceCustomizing reports to organize the displayed informationAdding calculated fields to a reportQuickly search for and find the skills you want to master- then just point, click, and learn.Over two hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!Course Goal: By the end of this course, you will be able to design a functioning relational database and customize many of its objects
