|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-access-level-3-advanced-access/
课程评论：没有评论
**课程名称：** Microsoft Access 3级 - 高级Access **课程概述：** 本课程旨在将您的Microsoft Access技能提升至高级水平，通过循序渐进的指导，帮助您精通Microsoft Access的高级功能。您将学习如何运用以下高级特性： * **表格重构：** 学习数据库的规范化和重构设计不佳的数据表。 * **查询优化：** 使用子查询实现更具针对性的查询结果。 * **交叉表查询：** 通过交叉表查询对行和列标题相交的值进行汇总计算。 * **宏自动化：** 利用宏实现数据录入自动化，例如根据其他字段中的数据进行自动填充。 * **报表设计：** 掌握在报表中按字母顺序排序、添加标签和分组记录。 * **文件附件：** 学习如何将文档和图像等任何文件附加到记录中。 * **报表美化：** 学习如何隐藏空的记录标签，以优化报表空间。 * **其他高级主题：** 涵盖更多高级Access功能，助您成为Access专家。 **讲师优势：** 讲师拥有超过18年的Microsoft Access培训和认证经验，将亲身指导您掌握这些高级功能。
Drive Your Microsoft Access Skills to an Advanced LevelTake your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options.Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master:Table normalization and restructuring of poorly designed databasesMore targeted Query results by using SubqueriesPerform summary calculations of intersecting values of row and column headings using Crosstab QueriesAutomate data entry, based upon certain data entered into other fields, with Automated MacrosAlphabetically sort, label, and group records in your ReportsHow to attach any file including documents and images to a record.How to hide empty Record Labels from displaying and taking up unnecessary space in your Reportsand much, much, more…
