|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-access-level-2-intermediate-access/
课程评论：没有评论
**Coursera 课程总结：Microsoft Access Level 2 - 中级 Access** 本课程将带您深入探索 Microsoft Access 的高级功能，尤其适合已掌握基础知识的学习者。通过为期 18 年的 Microsoft Access 培训和认证经验，讲师将手把手地指导您掌握一系列实用的数据库管理技术，以提高工作效率。 **课程亮点包括：** * **数据输入与验证：** 学习设置默认数据录入值和使用验证规则，确保数据的准确性和一致性。 * **字段历史与查找：** 掌握如何显示字段的历史记录，并创建查找字段，方便数据关联和选择。 * **查询技巧：** 学习如何在查询中隐藏重复值和记录，以及如何使用更新查询、追加查询、删除查询和生成表查询（Action Queries）来批量修改数据。 * **表单设计：** * 创建下拉列表（Combo Boxes），方便用户从查找值中选择。 * 添加选项组（Option Groups），根据用户选择控制可用选项。 * 利用选项卡（Tabs）扩展表单空间，避免垂直滚动。 * 使用命令按钮（Command Buttons）在表单之间快速导航，也可用于其他 Access 对象。 * **报表设计：** * 在报表中添加排序和筛选功能，以及控制分组的显示方式。 * 添加汇总字段，生成包含子报表（SubReports）的综合性报表。 通过本课程的学习，您将能够更有效地管理数据库，更轻松地处理日常任务，并大幅提升您在 Microsoft Access 方面的专业技能。
Go Beyond Access BasicsTake your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together.Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master:How to set data entry defaults and using Validation RulesShow a field's history and create Lookup FieldsHide duplicate values and records in a QueryHow to use Action Queries: Update, Append, Delete and Make TableCreate Form drop-down lists to lookup values, or Combo BoxesAdd Form Option Groups that controls the list of choices available for a userAdd more space to your Forms without scrolling with TabsJump around quickly to other Access Objects by creating Form Command ButtonsAdd, Sort and Filter records in a Report, as well as keeping groups togetherAdd summary fields to your Reports and include SubReportsAnd much, much more!
