Lynda com Setting Up a Database in Excel 英文版 CD

Lynda.com出品的時長43分鐘的在Excel中建立一個數據庫視頻教程。由DennisTaylor演示了怎樣使用Excel創建一個簡單的數據庫。講解Excel數據管理工具的限制，創建一個數據庫所需設計考慮的問題。以及使用列表簡化數據庫的建立，利用表單和數據驗證工具來管理數據等。本教程附帶練習文件。
Inthiscourse,authorDennisTaylorshowshowtouseExcelforcreatingasimpledatabase.ThecourseexplainsthelimitsofExcelasadatamanagementtoolandspellsoutthedesignconsiderationsforcreatingadatabase.ItalsodemonstratesusingtablestosimplifydatabasecreationaswellastheFormandDataValidationtoolstomanagedata.Exercisefilesareincludedwiththecourse.
Topicsinclude:
Understandingdatabasedesignconcepts
UsingtheTexttoColumnsfeature
Creatingfields
Usingtables
Addingtotalfields
FormattingtableswiththeDesigntab
UsingtheFormtooltobuildandviewdata
Usingdatavalidationtorestrictdataentries