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
| Lynda.com Excel 2010 Financial Functions in Depth 英文正式版(Lynda.com 出品 Excel 2010 深入學習財務功能視頻教程軟體) |
|
| Lynda.com Excel 2010 Charts in Depth 英文正式版(Lynda.com 出品 Excel 2010 基礎視頻教程軟體) |
|
| Lynda.com Excel 2010 Advanced Formulas and Functions 英文正式版(Excel 2010 高級公式和函數視頻教程軟體) |
|
| Lynda.Com SEO Search Engine Optimization Getting Started 英文正式版(Flash站台SEO教程軟體) |
|
| Lynda.com Practical and Effective JavaScript 英文正式版( Practical and Effective JavaScript 教程軟體) |
|
| Lynda.com Create an Online Portfolio with WordPress 英文正式版(利用 WordPress 搭建 Online Portfolio 在線作品集視頻教程軟體) |
|
| Lynda.com Acrobat 9 Pro Creating Multimedia Projects 英文正式版(Acrobat 9 創建多媒體項目教程軟體)(DVD版) |
|