|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-and-microsoft-access-database-application-development/
课程评论：没有评论
课程名称：Python与Microsoft Access数据库应用开发 课程概述： 本课程介绍Microsoft Access，这是微软的一款数据库管理系统，它将关系型Access数据库引擎与图形用户界面和软件开发工具相结合。该系统是Microsoft 365应用套件的一部分，包含在专业版及更高版本中，或单独出售。同时，Python是一种高级通用编程语言，其设计理念强调代码的可读性，并采用显式缩进。Python的语言结构和面向对象的方法旨在帮助程序员编写清晰、逻辑的代码，适用于小型和大型项目。 在Python的众多图形用户界面框架中，Tkinter是唯一一个内置于Python标准库中的框架。Tkinter具有多个优势，支持跨平台，即同一代码可以在Windows、macOS和Linux上运行。使用Tkinter开发的应用程序，其视觉元素会使用本地操作系统元素进行渲染，因此在不同平台上看起来都很贴合。 为了让Python应用程序与Microsoft Access数据库进行交互，需要一个名为pypyodbc的数据库连接适配器。在执行SQL语句以创建、更新、删除或检索数据之前，必须先连接到数据库。您可以使用pypyodbc来实现这一连接。 在本课程中，我们将从零开始构建一个基于Python和Microsoft Access数据库的CRUD（创建、读取、更新、删除）应用程序。
Microsoft Access is a database management system from Microsoft that combines the relational Access Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.Python is a high-level, general-purpose programming language. Its design philosophy emphasizes code readability with the use of significant indentation. Its language constructs and object-oriented approach aim to help programmers write clear, logical code for small- and large-scale projects.Python has a lot of GUI frameworks, but Tkinter is the only framework that's built into the Python standard library. Tkinter has several strengths. It's cross-platform, so the same code works on Windows, macOS, and Linux. Visual elements are rendered using native operating system elements, so applications built with Tkinter look like they belong on the platform where they're run.For python application to interact with a Microsoft Access database it requires a database connector adaptor called pypyodbcBefore you can run SQL statements to create, update, delete, or retrieve data, you must connect to a database. You can use the pypyodbc to connect to a database.In this course we will a build a CRUD application from scratch using Python and Microsoft Access database.
