|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-microsoft-access/
课程评论：没有评论
**课程名称：Microsoft Access入门** **课程概述：** 本课程旨在介绍Microsoft Access，一个功能强大的关系型数据库管理系统，特别适用于管理大量数据并避免数据重复。相比于电子表格在处理海量数据时的局限性，Access提供了一种更优化的解决方案。 Access采用菜单驱动和图形用户界面（GUI），使得初学者也能轻松地输入、管理和报告数据。用户可以通过熟悉的电子表格或表格界面输入数据，Access会自动生成表单。 课程将教授如何使用GUI轻松创建和修改数据库查询（Queries）和报表（Reports），以及利用菜单驱动的宏（Macros）录制器来自动化重复性任务。对于有经验的用户，课程还会提及如何使用Visual Basic for Applications (VBA) 语言进行定制。此外，Access还提供了丰富的模板，方便用户修改和使用。 Microsoft Access在跨Microsoft Office应用程序之间的数据交换和利用方面，能显著提高效率。它为初级用户提供了数据库管理功能，同时也能通过VBA与企业级系统进行集成，展现了其广泛的适用性和可扩展性。 **课程重点：** * **数据管理：** 如何在关系型数据库中有效管理大量数据。 * **避免数据冗余：** 了解Relational Design（关系型设计）的重要性。 * **用户友好界面：** 利用Access的GUI进行数据输入、管理和报告。 * **查询与报表：** 使用GUI创建和修改数据库查询和报表。 * **自动化：** 利用宏录制器简化重复性工作。 * **可扩展性：** 了解VBA在定制Access应用程序中的作用。 * **模板应用：** 如何使用和修改Access提供的模板。 * **Office集成：** Access在Microsoft Office生态系统中的价值。
A spreadsheet is easy to maintain. You can sort filter and format data quite easily and quickly. But spreadsheets are not to deal with big amount of data. Microsoft Access is a relational database management system that helps to manage large datasets in a relational design. It helps to avoid data duplication. It's the most widely used database by beginners in the world.Microsoft Access is a menu-driven database program that includes a graphical user interface enabling novice users to enter, manage and report on their data. Data can be entered using a familiar spreadsheet or table interface and the program will automatically generate forms based upon the data and labels that have been entered.Microsoft Access users can easily create and modify database queries and reports using the graphical user interface, and a menu-driven macro recorder to automate repetitive steps. Advanced users can customize Access applications using the Visual Basic for Applications "VBA" programming language common to all Microsoft Office applications. Access also includes many templates that can be easily modified by end users.Microsoft Access is important because it dramatically decreases the amount of time required to exchange and leverage information between Microsoft Office applications. Access provides database management functionality for novice end users and is highly extensible with enterprise systems by professional developers.
