課程目標 |
介紹資料管理觀念。教授核心技術如資料模型、結構化資料查詢語言。資料庫架構及實作概念。介紹資訊技術於資料管理上之應用,如資料倉儲、資料分析、資料探勘及近代網路資料及訊息發展。 |
Objectives |
This course introduces following topics: data management, from data modeling and structural query language technology through database architectures and implementation concepts and information technology application in the data management such as data warehouse, on-line analytic processing and data mining, to web and data exchange technology. |
教材 |
上課教材: 李淑馨 (2008) 資料庫管理理論與實務 – Access 2007, 第二版, 博碩文化 TQC Access 2007實力養成及評量 (解題秘笈) 碁峯,全華
參考資料: 林慶德、陳宇芬 譯 (2006) 資料庫管理與應用, 全華 Hoffer, A. Jeffrey, Mary B. Prescott and Heikki Topi (2009) Modern Database Management, 9th Ed. Pearson 平南 (2005) 活用Access會計管理系統 – 開發與應用, 金禾資訊 Teresa Henning, Truitt Bradly, Larry Linson, Leigh Purvis, and Brent Spaulding, (2010), Microsoft Access Small Business Solutions, Wiley |
Teaching Materials |
Textbooks: 李淑馨 (2008) 資料庫管理理論與實務 – Access 2007, 第二版, 博碩文化 TQC Access 2007實力養成及評量 (解題秘笈) 碁峯,全華
References: 林慶德、陳宇芬 譯 (2006) 資料庫管理與應用, 全華 Hoffer, A. Jeffrey, Mary B. Prescott and Heikki Topi (2009) Modern Database Management, 9th Ed. Pearson 平南 (2005) 活用Access會計管理系統 – 開發與應用, 金禾資訊 Teresa Henning, Truitt Bradly, Larry Linson, Leigh Purvis, and Brent Spaulding, (2010), Microsoft Access Small Business Solutions, Wiley |
教學內容 |
1. Access 2007 複習 2. TQC Access 2007術科第一類實作 3. TQC Access 2007術科第二類實作 4. TQC Access 2007術科第三類實作 5. TQC Access 2007術科第四類實作 6. TQC Access 2007術科第四類實作及學科複習 7. TQC Access 2007學科複習 8. TQC專業測驗 9. 微軟Access 2007於小型企業應用 – 客戶及客戶資料 10. 微軟Access 2007於小型企業應用 – 產品、製造及存貨 11. 微軟Access 2007於小型企業應用 – 財務資料記錄及分析 12. 微軟Access 2007於小型企業應用 – 系統整合 13. 範例研討 (Cases Study) |
Syllabus |
1. Access 2007 Review 2. TQC Access 2007 Class 1 Practice 3. TQC Access 2007 Class 2 Practice 4. TQC Access 2007 Class 3 Practice 5. TQC Access 2007 Class 4 Practice 6. TQC Access 2007 Class 4 Practice and Disciplines Review 7. TQC Access 2007 Disciplines Review 8. TQC Expert Exam 9. Microsoft Access Small Business – Customers and Customer Data 10. Microsoft Access Small Business – Producing and Tracking the Goods and Services 11. Microsoft Access Small Business – Tracking and Analyzing Financial Data 12. Microsoft Access Small Business – System Integration 13. Cases Study |