|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-access-2021-advanced-course/
课程评论：没有评论
**课程名称：Microsoft Access 2021 高级：专家级数据库管理** **课程概述：** 本课程专为已掌握 Microsoft Access 基本操作并希望深入探索进阶概念和功能的用户设计。通过提供可下载的课程文件，学员可以同步实践，提升数据库管理技能，自信高效地应对复杂数据挑战。 **课程目标：** * 掌握 Microsoft Access 2021 的核心高级功能，成为精通的数据库专家。 * 能够创建和管理复杂的查询，优化数据库性能。 * 学习编写 SQL 代码，实现更强大的数据操作。 * 熟练运用宏和 VBA 代码自动化任务，提升效率。 * 设计和实现高级表单和报表，增强用户体验。 * 了解如何将 Access 与其他应用程序和数据源集成。 **课程亮点：** * **内容详实：** 涵盖主键创建、索引规则、数据表视图的高级操作、子数据表、数据库拆分（前端/后端）、多用户问题处理、宏的开发与安全、VBA 编程基础（模块、子程序、函数、变量、错误处理）、事件驱动编程、导航表单、高级查询（SQL 语句、连接、子查询）、数据库保护等。 * **实践导向：** 提供“Northwind”样本数据库，并包含配套的课程和练习文件，支持学员边学边练。 * **教学资源丰富：** 超过 6 小时的视频教程，包含 50 个独立视频讲座。 * **专业认证：** 完成课程可获得结业证书。 **适用于：** * 有 Access 基础，希望提升技能的数据库专业人员。 * 数据库管理员。 * 软件开发者。 * 有志成为 Access 高级用户的个人。 **学习价值：** 本课程将帮助您在职业生涯中取得进展，提升解决复杂数据问题的能力，并充分发挥 Microsoft Access 2021 的强大潜力。
**This course includes downloadable course files to work with and follow along.**Are you already familiar with the basics of Microsoft Access and eager to delve into more advanced concepts and features? Look no further! Welcome to our comprehensive training course, Microsoft Access 2021 Advanced, specifically designed for individuals like you who want to expand their expertise and maximize the potential of this powerful database application.Building upon your current foundation with Microsoft Access, this course takes your database management skills to new heights, enabling you to tackle complex data challenges with confidence and efficiency.Our training program is tailored to meet the needs of intermediate and advanced users who seek to master the intricacies of Access 2021. Whether you are a seasoned data professional, a database administrator, a software developer, or an aspiring power user, this course will equip you with the skills and knowledge necessary to harness the full potential of Microsoft's advanced database management techniques.Throughout the course, you will embark on an immersive learning journey, exploring a wide range of advanced topics. We will guide you through mastering complex queries, optimizing database performance, writing SQL code, developing macros, leveraging advanced forms and reports, and integrating Access with other applications and data sources.Whether you aspire to become a database expert, advance your career, or enhance your problem-solving abilities, this course will meet you at your skill level and provide the necessary guidance to become proficient in Microsoft Access 2021. Our goal is to empower you with the skills and knowledge to tackle complex data challenges, optimize performance, and leverageIn this course, you will learn how to:Create primary keysUnderstand indexing rules and guidelinesSet up the sample ‘Northwind' databaseWork efficiently in datasheet viewCustomize datasheet viewApply advanced sorting and filtering techniquesCreate sub-datasheetsLink to tables in other Access databasesInstall and set up SQL Server ExpressSplit an Access database into front end and back endConvert tables to local tablesAddress multi-user issues when sharing database filesWork through the basics of macrosModify the AutoExec macroUnderstand macro eventsAdjust macro security settingsHandle macro errorsCustomize the quick access toolbarConvert macros to VBA codeWrite and run VBA codeUnderstand VBA error handlingCreate modules, subs, functions, IntelliSense, and variablesName variables and stringsWork with standard functionsAdd events to a databaseCreate switchboards and navigation forms.Format bound and control formsSplit formsCreate tabbed formsAdjust combo-box propertiesBuild advanced queriesWrite and modify SQL statementsUnderstand joins and join typesWork with action queriesCreate subqueriesProtect the database and VBA code.This course includes:6+ hours of video tutorials50 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
