資料介紹

• 辦公軟件與office教程
• 數據庫SQL Server/Oracle/MySQL/DB2教程
• 計算機資料

語言：英語
網址：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