|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/access-2021-full-course-beginner-to-advanced/
课程评论：没有评论
课程名称：Access 2021 完整课程：初学者到高级 课程概述：本课程适合初学者及有经验的日常用户，以提高其在 Microsoft Access 中的技能和效率。Access 是 Microsoft 的关系数据库应用程序，用于组织和存储数据，同时具备报表功能。 课程内容：本课程将从导航已完成的数据库开始，探索关系数据库及其包含的对象。接着学习 Access 界面，帮助您熟悉工作环境。随后，我们将学习如何规划、设计和创建数据库表。课程还包括从 Excel 导入表数据以及手动输入表数据的过程。此外，我们将探讨数据排序和筛选技巧，然后深入学习表之间的关系，这对于成功的关系数据库至关重要。接着，我们将创建数据库查询、表单和报表。课程将重点讲解表关系如何影响查询、查询的自动化以及如何创建动作查询。高级培训部分包括高级报表和表单设计技巧，我们将学习如何创建切换板、编写宏，以及使用 Access VBA 进行复杂的自动化。最后，我们将讨论数据库安全性和自定义选项。 通过这个全面的 Access 课程，您将全面掌握 Access 的所有功能。
Who it's for: Beginners or experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Access. What it is: Access is Microsoft's relational database application used to organize and store data. Access also has reporting capabilities.What you'll learn: We start with navigating a completed database while exploring the concept of relational databases and the objects they contain. We'll move on to learning the Access interface, so you can become comfortable in the working environment. Then, we dive into how to plan, design, and create database tables. We'll continue by importing table data from Excel, as well as manually entering table data. Sorting and filtering techniques will be explored before we move on to exploring table relationships, the key to a successful relational database. We will create database queries, forms, and reports. We'll spend time on learning how table relationships affect queries, how to automate queries, and how to create action queries. Our advanced training starts with Advanced Report and Form Design techniques. We will learn how to create switchboards, write macros, and use Access Visual Basic for Applications (VBA) for complex automation. We will end by covering database security and customization options. Learn it all in this all inclusive Access class.
