|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-access-2016-access-from-beginner-to-advanced/
课程评论：没有评论
Coursera 课程总结：精通 Microsoft Access - 从入门到精通 本课程全面涵盖 Microsoft Access，从初学者到高级用户，共分为三个级别： * **入门级：** 学习创建强大、高效的 Access 数据库，进行数据录入、编辑、更新、查询、排序和筛选。掌握设置默认值和验证数据以确保数据准确性。 * **中级：** 学习在表单中快速编辑、筛选和搜索记录，添加选项控件、命令按钮和下拉列表以提高数据录入速度和准确性。学习添加自定义字段以进行计算（求和、计数、平均值等）。 * **高级：** 学习在报表中添加、排序和筛选组，并防止跨页分割。掌握在查询中使用条件来精炼搜索，查看唯一记录，并使用操作查询快速更新、添加和删除记录。还将学习通过创建宏来自动化数据录入和提高准确性。 该课程使用 Access 2016 版录制，但兼容 2010、2013、2016、2019 和 365 版本。Mac 用户界面可能与 Windows 版本略有不同。 讲师拥有超过 18 年的 Access 培训经验和多项微软认证，包括 MOS（专家和大师级讲师），MCT 和 MCP。学完本课程，学员将熟练掌握 Access 技能，提高工作效率，并为通过 Access 2016 (77-730) 认证考试做好准备。
Microsoft Access All-In-One Training This Microsoft Access course includes all three Levels from Beginner to Advanced Microsoft Access Level 1 - Beginner Microsoft Access Level 2 - Intermediate Microsoft Access Level 3 - Advanced Material recorded with Access 2016 but works in 2010, 2013, 2016, 2019 and 365. MAC users, since the videos are recorded with the Windows version of Microsoft Access, the interface will be bit different.As your instructor I will use my 18+ years of Access training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Access. At completion of this course you will master Access skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass the Access 2016 (77-730) Exam and become certified, like me. Below are just a few of the topics that you will master: Create powerful, effective Access Databases Enter, edit, update, search, sort and filter Table records Set defaults and validate data for more accurate data entry How to quickly edit, filter and search records in a Form Add option controls, command buttons and drop-down lists for faster data entry and accuracy in Forms Add custom fields to perform calculations: Sum, Count, Average and more Add, sort and filter groups as well as keeping them from splitting across pages in your Reports Use criteria in a Query to dramatically refine your search View unique records and use Actions Queries to Update, Add and Delete records fast Automate data entry and accuracy dramatically by creating Macros and much more…
