Lynda.com Setting Up a Database in Excel 英文正式版(Excel建立數據庫視頻教程軟體)
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
|
|
專業知識教學
