{"course":{"id":"108221710601","name":"資料庫管理(含實習)","enroll_type":"必修","general_type":"","dept":"四技工管系","grade":1,"class_group":"甲","teacher":"鄭明顯","credit":3,"hour":4,"time":[{"day":2,"section":[2,3,4]},{"day":4,"section":[4]}],"classroom":"","max":60,"min":10,"remark":"","alt_for":"","courses":""},"detail":[["指定教材","王安邦著，\"資料庫管理與實務應用使用Access 2016\"，上奇資訊，第二版，台北，2017年12月"],["參考教材","楊世瑩著,\"2016 Access嚴選教材\",碁峰資訊股份有限公司,初版,台北,2016年6月"],["成績評量標準","檢定考:30%\n期中考:25%\n期末考:25%\n報告:10%\n練習:10%"],["教學方法","理論講授,個人實驗(實作)"],["教學目標","本課程介紹資料庫理論與實務，理論部分說明關聯式資料庫如何產生作用，實務部分則以Access為重點。希望學生學習資料庫之基本理論觀念，並經由Access之操作練習，能夠了解基礎資料庫之建立與應用。最後要求學生分組挑選一個案實作系統，並於期末上台報告成果。"]],"office_time":[["鄭明顯","地點：創新大樓603教師研究室\n週一2-4節 週三2-4節 週四6-8節"]],"schedule":[["2020/02/04","2","4","3","鄭明顯","課程介紹","","介紹本學期課程計畫與進度及評分方式。另說明Access操作環境與資料庫物件的關係。",""],["2020/02/06","4","4","1","鄭明顯","範例介紹","","介紹本學期課程計畫與進度及評分方式。另說明Access操作環境與資料庫物件的關係。",""],["2020/02/11","2","4","3","鄭明顯","建立資料表","","資料的種類，設定資料表的欄位內容、索引欄位、更改資料表結構，資料工作表的操作",""],["2020/02/13","4","4","1","鄭明顯","建立資料表","","資料的種類，設定資料表的欄位內容、索引欄位、更改資料表結構，資料工作表的操作",""],["2020/02/18","2","4","3","鄭明顯","尋找、取代、排序與篩選資料","","尋找資料，取代資料，排序資料與篩選資料",""],["2020/02/20","4","4","1","鄭明顯","尋找、取代、排序與篩選資料","","尋找資料，取代資料，排序資料與篩選資料",""],["2020/02/25","2","4","3","鄭明顯","建立美觀的資料輸入表單與列印資料","","利用表單精靈建立表單物件，表單物件的基本操作，快速建立表單，快速建立報表",""],["2020/02/27","4","4","1","鄭明顯","建立美觀的資料輸入表單與列印資料","","利用表單精靈建立表單物件，表單物件的基本操作，快速建立表單，快速建立報表",""],["2020/03/03","2","4","3","鄭明顯","關聯式資料庫的基本知識與E-R Model","實習作業一","認識關聯、主鍵與連外鍵，資料的完整性，何謂實體關係模型與其組成要素",""],["2020/03/05","4","4","1","鄭明顯","關聯式資料庫的基本知識與E-R Model","實習作業一","認識關聯、主鍵與連外鍵，資料的完整性，何謂實體關係模型與其組成要素",""],["2020/03/10","2","4","3","鄭明顯","建立關聯式資料庫  進階的查詢應用","","如何設計一個完善的資料庫，從客戶分析到建立實體關係模型，整合為全區的概念模型",""],["2020/03/12","4","4","1","鄭明顯","建立關聯式資料庫  進階的查詢應用","","如何設計一個完善的資料庫，從客戶分析到建立實體關係模型，整合為全區的概念模型",""],["2020/03/17","2","4","3","鄭明顯","檢定一","","使用簡單查詢精靈，在查詢中建立計算欄位，建立參數式的查詢，建立交叉式資料表查詢",""],["2020/03/19","4","4","1","鄭明顯","檢定一檢討","","使用簡單查詢精靈，在查詢中建立計算欄位，建立參數式的查詢，建立交叉式資料表查詢",""],["2020/03/24","2","4","3","鄭明顯","個案實作報告(一)","","全班分組實施上機測試一",""],["2020/03/26","4","4","1","鄭明顯","個案實作報告(一)","","全班分組實施上機測試一",""],["2020/03/31","2","4","3","鄭明顯","資料表正規化","","周實體關係圖與正規化的關係，欄位相依，第一階正規化，第二階與第三階正規化，正規化的另類思考。",""],["2020/04/02","4","4","1","鄭明顯","補假","","周實體關係圖與正規化的關係，欄位相依，第一階正規化，第二階與第三階正規化，正規化的另類思考。",""],["2020/04/07","2","4","3","鄭明顯","期中考","","統一考試",""],["2020/04/09","4","4","1","鄭明顯","期中考檢討","","統一考試",""],["2020/04/14","2","4","3","鄭明顯","表單的進階設計","實習作業二","使用精靈設計各式各樣表單，控制項的選取與操作技巧，控制項屬性，善用快顯功能",""],["2020/04/16","4","4","1","鄭明顯","表單的進階設計","實習作業二","使用精靈設計各式各樣表單，控制項的選取與操作技巧，控制項屬性，善用快顯功能",""],["2020/04/21","2","4","3","鄭明顯","設計美觀實用的報表","","建立包含多個資料表的報表，修改報表中的各項設定，加入計算欄位，在報表中使用查詢參數",""],["2020/04/23","4","4","1","鄭明顯","設計美觀實用的報表","","建立包含多個資料表的報表，修改報表中的各項設定，加入計算欄位，在報表中使用查詢參數",""],["2020/04/28","2","4","3","鄭明顯","檢定二檢討","","全班分組實施上機測試二",""],["2020/04/30","4","4","1","鄭明顯","檢定二檢討","","全班分組實施上機測試二",""],["2020/05/05","2","4","3","鄭明顯","Access與其他軟體交換資料","實習作業三","匯出資料表與匯入資料，套用Word的郵件合併列印功能，Office剪貼簿",""],["2020/05/07","4","4","1","鄭明顯","Access與其他軟體交換資料","實習作業三","匯出資料表與匯入資料，套用Word的郵件合併列印功能，Office剪貼簿",""],["2020/05/12","2","4","3","鄭明顯","利用巨集簡化操作與VBA輕鬆上手","","認識巨集，建立執行巨集的命令鈕，巨集群組與條件巨集，巨集的執行流程控制VBA的程式架構，，",""],["2020/05/14","4","4","1","鄭明顯","利用巨集簡化操作與VBA輕鬆上手","","認識巨集，建立執行巨集的命令鈕，巨集群組與條件巨集，巨集的執行流程控制VBA的程式架構，，",""],["2020/05/19","2","4","3","鄭明顯","檢定三檢討","","全班分組實施個案實作，並上台操作與報告成果",""],["2020/05/21","4","4","1","鄭明顯","檢定三檢討","","全班分組實施個案實作，並上台操作與報告成果",""],["2020/05/26","2","4","3","鄭明顯","個案實作報告(二)","實習作業四","個案實作，並上台操作與報告成果",""],["2020/05/28","4","4","1","鄭明顯","個案實作報告(二)","實習作業四","個案實作，並上台操作與報告成果",""],["2020/06/02","2","4","3","鄭明顯","期末考","","統一考試周",""],["2020/06/04","4","4","1","鄭明顯","期末考檢討","","統一考試周",""]]}