《Excel建立数据库视频教程》(Setting Up a Database in Excel)[光盘镜像]
电驴资源
电驴资源简介
简介:
/thumb.jpg)
语言:英语
网址:http://www.lynda.com/Excel-2007-tutorials/Setting-Up-a-Database-in-Excel/89046-2.html
类别:教程
(xuehui@TLF)
Lynda.com 出品的时长43分钟的在Excel中建立一个数据库视频教程。由Dennis Taylor演示了怎样使用Excel创建一个简单的数据库。讲解Excel数据管理工具的限制,创建一个数据库所需设计考虑的问题。以及使用列表简化数据库的建立,利用表单和数据验证工具来管理数据等。本教程附带练习文件。
In this course, author Dennis Taylor shows how to use Excel for creating a simple database. The course explains the limits of Excel as a data management tool and spells out the design considerations for creating a database. It also demonstrates using tables to simplify database creation as well as the Form and Data Validation tools to manage data. Exercise files are included with the course.
Topics include:
Understanding database design concepts
Using the Text to Columns feature
Creating fields
Using tables
Adding total fields
Formatting tables with the Design tab
Using the Form tool to build and view data
Using data validation to restrict data entries
下载链接来自TLF
未经过安装测试与安全检测,使用者后果自负与本论坛无关
软体版权归原作者及其公司所有,如果你喜欢,请购买正版
语言:英语
网址:http://www.lynda.com/Excel-2007-tutorials/Setting-Up-a-Database-in-Excel/89046-2.html
类别:教程
(xuehui@TLF)
Lynda.com 出品的时长43分钟的在Excel中建立一个数据库视频教程。由Dennis Taylor演示了怎样使用Excel创建一个简单的数据库。讲解Excel数据管理工具的限制,创建一个数据库所需设计考虑的问题。以及使用列表简化数据库的建立,利用表单和数据验证工具来管理数据等。本教程附带练习文件。
In this course, author Dennis Taylor shows how to use Excel for creating a simple database. The course explains the limits of Excel as a data management tool and spells out the design considerations for creating a database. It also demonstrates using tables to simplify database creation as well as the Form and Data Validation tools to manage data. Exercise files are included with the course.
Topics include:
Understanding database design concepts
Using the Text to Columns feature
Creating fields
Using tables
Adding total fields
Formatting tables with the Design tab
Using the Form tool to build and view data
Using data validation to restrict data entries
下载链接来自TLF
未经过安装测试与安全检测,使用者后果自负与本论坛无关
软体版权归原作者及其公司所有,如果你喜欢,请购买正版
