|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-access-intro/
课程评论：没有评论
课程名称：Microsoft Access入门：数据库管理工具 课程概述：本课程旨在为Access初学者介绍Microsoft Access的基本概念和功能，教授创建和管理数据库所需的技能，并提供实用的示例和练习，帮助学员有效使用Access。课程结束时，学员应能够： - 理解使用关系数据库系统的目的和好处 - 掌握Access界面的导航及常用工具和命令 - 创建新数据库并设计合适的字段和数据类型的表 - 建立表之间的关系并维护参照完整性 - 在表单中输入、编辑和删除数据 - 使用查询筛选、排序和汇总数据 - 创建和自定义报告，以专业格式呈现数据 - 运用基本的格式和设计原则，提高数据库的外观和可用性 课程内容包括： - 理解数据库窗口 - 数据库对象 - 表、查询、表单、报告、宏 - 数据库术语 - 字段、记录、数据集 - 创建数据库 - 基本表和表设计，数据类型、数据格式及字段规则 - 使用查询并设计自定义查询 - 使用自动表单功能 - 表单设计 - 从空白表单开始，添加表并操作字段 - 使用自动报告功能 - 报告设计，创建自定义报告，移动和调整字段及标签 - 数据复制 - 冻结列 - 打印表格 - 打印报告 - 排序记录 - 使用筛选排序和高级筛选 - 重命名列 - 使用图表向导 - 从Excel导入数据 - 链接Excel数据 通过本课程，学员将对Microsoft Access数据库中的基本概念有良好的理解。
The main goals for an Access beginners course are to introduce the basic concepts and features of Microsoft Access, to teach the skills needed to create and manage a database, and to provide practical examples and exercises that demonstrate how to use Access effectively. By the end of the course, you should be able to:- Understand the purpose and benefits of using a relational database system- Navigate the Access interface and use common tools and commands- Create a new database and design tables with appropriate fields and data types- Establish relationships between tables and enforce referential integrity- Enter, edit, and delete data in tables and forms- Use queries to filter, sort, and summarize data- Create and customize reports to present data in a professional format- Apply basic formatting and design principles to enhance the appearance and usability of your database.The course content is as follows:Understand The Database WindowDatabase Objects - Tables - Queries - Forms - Report - MacroDatabase Terminology -fields - records - data setCreating a DatabaseBasic Tables and Table design, data types, data formatting and field rulesUsing Queries and design your own. Select queriesUsing the Auto Form FeatureForm Design -starting from a blank form. Add a table to a form and manipulate the fieldsUsing the Auto Report FeatureReport Design, create your own report, move and resize fields and labels.Copying DataFreezing ColumnsPrinting TablesPrinting ReportsSorting RecordsUsing the Filter Sorts and advanced filtersRenaming ColumnsUsing the Chart WizardImporting data from ExcelLinking to Excel DataAfter this course you will a good understanding of the basic concepts used in a Microsoft Access database.
