|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/hands-on-microsoft-access-2019/
课程评论：没有评论
课程名称：实践微软Access 2019 课程概述：微软Access 2019是一款信息管理工具，能够有效存储信息，并在某种程度上比其他电子表格应用更有效地管理数据。它是中小型企业（SME）特别有用的工具。本课程是一门实用的初学者课程，提供基于真实情境的实例供学员借鉴。课程从Access数据库的快速介绍开始，讲解核心概念、界面及术语，以帮助学员入门。随后，学员将掌握数据查询管理的关键组件，学习如何使用表单查看、添加、编辑甚至删除数据。在此基础上，学员将利用内置报告发布数据，并学习与关系数据库管理系统（RDBMS）相关的“连接”概念及其重要性。课程还将展示如何通过创建和应用宏来自动化Access数据库，并介绍VBA编程及其在Access中的应用。到课程结束时，学员将自信运用Microsoft Access 2019的新技能，提高工作效率和数据可视化能力。 关于讲师：Ben Beitler是一位高效的软件开发人员和顾问，拥有超过25年的数据库设计与实施经验，特别在客户关系管理系统和定制应用程序（主要是VBA编程，尤其是Excel电子表格和Access数据库）方面表现突出。他曾成功运营多家企业，包括桌面培训、咨询及Access和Excel开发，客户涵盖福特、丰田、汇丰、巴克莱、普华永道、德勤、赛杰等大中型公司。尽管他位于英国，但他也为远至澳大利亚的软件专家提供咨询服务和系统开发。
Microsoft Access 2019 is an information management tool that stores information and, arguably, helps manage data more efficiently than other spreadsheet apps. It is an ideal and particularly useful tool for small-to-medium-sized (SME) businesses.This will be a practical, beginner-level course with hands-on, real-world examples you can use as models for your own activities. Beginning with a quick introduction to an example Access database, you will cover the core concepts, interface, and terminology you need to get started. You will then master the key components of data query management; forms to help you view, add, edit, and even delete data in a controlled environment. Then, you will publish your data with the help of built-in reporting, and move on to work with RDBMS concepts relating to ‘joins' and why they're important. You'll find out how to automate your Access database by creating and applying macros and learn about VBA programming and how it's used with Access.By the end of the course, you will be confident in your new skills in Microsoft Access 2019 to improve productivity, and data visualization.About the AuthorBen Beitler is a highly proficient software developer and consultant with over 25 years' experience of database design and implementation of CRM management systems, and bespoke applications using VBA (mainly Excel spreadsheets and Access databases).He has successfully run several businesses, including desktop training, consultancy, and development in Access and Excel ranging from small to the larger companies including Ford, Toyota, HSBC, Barclays, PWC, Deloitte, Sage, and many others.Even though he is based in the UK, he has provided consultancy services and developed systems with software specialists as far afield as Australia.
