|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-microsoft-access-2019/
课程评论：没有评论
课程名称：高级微软Access在线课程：2019/365版 课程概述：本课程包括实践练习和终身访问。微软Access是一款出色的数据处理工具，特别适合当你的数据超出电子表格的承载能力时使用。与许多其他数据库工具不同，Access非常用户友好，适合非开发者。本高级Access课程从初学者课程结束的位置开始，深入探讨更高级的Access功能。我们假设您已经掌握了微软Access的基础知识，包括如何设置表格或数据库、创建基本表单和运行简单查询。在本课程中，我们将对Access中的宏和VBA进行更深入的探讨，同时介绍ODBC和SQL Server。本课程非常适合已经使用Access一段时间但希望进一步提升知识的学习者。 在本课程中，您将学习： - Access中的主键和索引 - 数据表视图的自定义和过滤 - 如何链接到其他数据库 - 使用ODBC和SQL Server的知识 - 如何将Access数据库拆分为前端和后端 - Access中的宏使用，包括AutoExec - 基础VBA在Access中的应用，包括代码和错误处理 - 创建表单的高级技巧 - 高级查询，包括“多个条件”标准 课程特色： - 7小时视频教程 - 46个独立视频讲座 - 实践练习文件 - 完成证书 学生评价： "课程非常棒！从基础开始，详细讲解了Access程序的各项功能，这对我这样的新手来说非常有帮助。与讲师一起完成项目的方式让我更有效地学习和记忆。" - John Fife "作为Access的新手，我非常欣赏逐步掌握所有基本知识的过程，这为我深入了解这个强大的数据库打下了良好的基础。我的学习旅程非常愉快，讲师的讲解深入且相关的例子丰富，实践机会也很充足。" - James Habersham "课程非常出色，讲解清晰，节奏适中，内容覆盖全面。我非常享受与这门课程一起学习Access的过程。" - Daniel Bleakley 您知道吗？Simon Sez IT教授各种软件，包括： - 微软Excel - 微软PowerPoint - 微软Word - 微软Project - 微软Outlook - QuickBooks - Photoshop Elements - 网页开发语言 - 以及更多内容！
**This course includes practice exercises and LIFETIME access**Microsoft Access remains an amazing tool for when your data outgrows spreadsheets. Unlike many other database tools, it's far more user-friendly and ideal if you're not a developer.In this Microsoft Access advanced course, we start where the beginner's course finishes and dives straight into more advanced Access features. In this course, we assume you know the basics of Microsoft Access, including how to set up a table or database, create a basic form and run a simple query. In this advanced Access course, we look much more at using Macros and VBA in MS Access as well as ODBC and SQL Server. This course is ideal if you've been using Access for a while but are looking to take your knowledge to the next level.In this course you will learn:All about Primary Keys and Indexes in AccessAbout customizing and filtering on the Datasheet ViewHow to link to other databasesAll about using ODBC and SQL ServerHow to split an Access database into front and back-endAll about Macros in Access including AutoExecHow to do basic VBA in Access including code and error handlingMore advanced techniques around creating forms in AccessAdvanced queries including "multiple where" criteria***Exercise files included***This course includes:7 hours of video tutorials46 individual video lecturesExercise files to practice what you learnedCertificate of completionHere's what our students are saying…"Great course so far! Starts off at a very basic level and explains all the functions of the access program which for a novice like me is very helpful. I like how the student works on the project with the instructor and I find this very effective in learning and retaining the material"- John Fife"Yes. Being a novice to Access, I appreciate getting all the detailed basics under my belt as we gradually progress into this powerful data base. I really enjoyed my journey through this Access course with my instructor. His presentation through all the modules was well explained and very in-depth with related examples and chances to practice what was taught."- James Habersham"Fantastic course. Very well presented. Perfectly paced and thoroughly explained topics.Really enjoyed learning access with this course."- Daniel BleakleyDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!
