|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/access-365-foundations/
课程评论：没有评论
课程名称：Access 365基础知识：创建数据库所需的一切 课程概述：如果您是小型组织或自雇人士，并需要超越Excel来存储数据，那么您需要使用MS Access 365。Access 365是一款已有30年历史的桌面关系数据库，它能有效地存放数据，但实际上，它的功能不仅限于此。您可以执行复杂的查询，以生成报告并获得所需的数据分析。这一切都始于扎实的基础，了解如何从头开始创建一个稳固的数据库，确保表格之间的正确关系和参照完整性，以避免数据不准确。 Microsoft Access 365是一款桌面数据库应用程序，可以存储大量数据。数据库内的对象——查询、表单、报告和代码模块，使用户能够轻松地添加或提取数据，并以不同格式展示数据。关系数据库的概念指的是在不同表格中收集的数据彼此以某种方式相关。例如，数据库可以保存客户的信息，每个表格都包含客户的个人资料、所有交易记录及购买的产品。 学生将学习如何创建完整的数据库，包括表格、表单、查询和报告，并建立对各种数据库工作原理的基础知识。需要具备Excel函数的知识和解决问题的能力，才能更好地完成本课程。此外，学生还需确保在个人计算机上安装MS Access 365版本。 讲师：Robin Solonenko
If you are a small organization or self employed and need to move beyond using Excel to hold your data, then you need MS Access 365. Access 365 is a desktop relational database that has been around for 30 years and does the job needed to hold your data. But in fact, it does more than just hold your data - you can execute complex queries to run your reports and get the data analysis you need on your organization.But it all starts with a good foundation and learning from the beginning on how to create a rock-solid database with proper relationships and referential integrity, so your tables hold correct data and not create windows and orphans.Microsoft Access 365 is a desktop database application that provides the ability to store large amounts of data and the objects within the database - Queries, Forms, Reports, and Code Modules enable the user to add or extract data easily and present the data in different formats.The term Relational Database refers to the idea that the data collected in the various tables are related to each other in one fashion or another. The database could hold information about customers and each of the table would have information about those customers like their personal info, all the transactions they have generated and all the products they purchased.Students will learn to create an entire database with Tables, Forms, Queries and Reports and build a foundation of knowledge of how databases of any kind work. Knowledge of Excel functions and the ability to problem solve will be required assets for this course. Students must also have MS Access 365 version installed on their local computer.Your InstructorRobin Solonenko
