|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-access-2021-for-beginners-master-the-essentials/
课程评论：没有评论
《Microsoft Access 2021 for Beginners: Master the Essentials》课程总结 这门课程专为零基础或希望巩固基础知识的学习者设计，旨在帮助您掌握Microsoft Access 2021的核心功能，并能独立创建和管理数据库。课程提供可下载的讲师文件和练习文件，方便您同步学习。 **核心内容概览：** Access 2021不仅仅是创建可定制桌面数据库的工具，它更是一个强大的平台，能够让您在无需高级开发技能的情况下，从零开始构建企业应用程序和模板。课程将引导您快速上手，全面掌握数据库的构建与管理。 **您将学到：** * **数据库基础：** 理解关系型数据库的概念，了解Access 2019与2021版本的主要区别。 * **界面与导航：** 熟练运用Access 2021的界面、功能区和命令，自定义快速访问工具栏，掌握菜单系统和快捷键，并利用帮助文件解决问题。 * **数据库对象创建与管理：** * **表：** 创建、修改表和字段，理解字段属性、索引字段和主键，创建查找菜单，设置数据验证规则，并能从Excel或文本文件导入数据。 * **数据管理：** 在数据表视图中管理数据，进行记录排序和筛选。 * **关系：** 创建表之间的关系（包括通过链接表建立关系），理解一对多关系。 * **窗体：** 创建和设计用户友好的窗体，包括子窗体，并能添加复选框、附件和选项按钮等控件，修改窗体设计和主题，创建导航窗体。 * **查询：** 构建简单和复杂的查询来查询表数据，聚合数值数据，创建表达式进行计算。 * **报表：** 创建和运行基础报表，设计自定义报表以获得更深入的见解。 * **数据库保护与优化：** 导出数据库到其他文件格式，通过加密和密码保护文件，以及使用压缩和修复功能来防止数据库问题。 * **打印输出：** 打印表、窗体和报表。 **课程特色：** * 7小时的视频教程，包含66个独立的视频讲座。 * 提供配套的课程和练习文件，支持实际操作。 * 完成课程后可获得结业证书。 通过本课程的学习，您将为构建更高级的Access数据库知识奠定坚实的基础。
**This course includes downloadable instructor files and exercise files to work with and follow along.**Take control of your data and discover the power of Access 2021, the latest on-premises release from Microsoft and the newest addition to the Access family of applications. Microsoft Access 2021 is so much more than a way to create customizable desktop databases. It is fair to say that Access 2021 is a user-friendly tool that allows us to create business applications and templates from scratch without the need for high-level development skills.Access 2021 allows even the novice database builder to start creating tables, forms, queries, and reports quickly. It is a full life-cycle database management tool that makes creating small to large databases easy.In this course, we will explore the basic functionality of Access and get familiar with the terminology, the interface, and the commands. We'll look at the available templates and build tables and populate them with data. We'll create relationships between tables and build queries to interrogate the data. We'll look at building nicely formatted forms so others can interact easily with our database and build custom reports to help us gain deeper insight.This course is for the absolute beginner or anyone who is looking to refresh their basic skills. It will provide a fantastic starting point from which to build more advanced Access database knowledge.In this course, students will learn how to:Explain what a relational database isDownload and install Access 2021Know the differences between Access 2019 and Access 2021Locate, open, and save Access database templatesOpen, close, and save a blank database fileNavigate the Access interface, ribbons, and commandsCustomize the quick access toolbar with frequently used commandsUnderstand the different menu systems in AccessUse keyboard shortcuts to navigate and execute commandsAccess the help filesCustomize Access optionsCreate tables and fieldsModify field propertiesUnderstand index fields and primary keysCreate lookup menusAdd data validation and data validation text to fieldsImport data into a table from Excel and from a text fileUse datasheet view to manage dataSort and filter records in a tableCreate relationships between tables that share a common fieldCreate relationships between tables using a link tableUnderstand one-to-many relationshipsCreate and design user-friendly formsSetup subformsBuild simple and complex queries to interrogate table dataAggregate numeric dataCreate expressions to perform simple calculationsCreate and run a basic reportCreate a custom reportUse form controls to add checkboxes, attachments, and option buttons to formsModify a form's design and themeCreate a navigation formExport an Access database to other file formatsProtect a database file by adding encryption and password protectionPrevent database issues using compact and repairPrint tables, forms, and reports.This course includes:7 hours of video tutorials66 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
