{"course":{"id":"109221701H01","name":"資料庫管理","enroll_type":"必修","general_type":"","dept":"四技工管系","grade":1,"class_group":"甲","teacher":"鄭明顯","credit":3,"hour":3,"time":[{"day":3,"section":[1,2,3]}],"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":[["2021/01/20","1","3","3","鄭明顯","課程介紹","","介紹本學期課程計畫與進度及評分方式。另說明Access操作環境與資料庫物件的關係。",""],["2021/01/27","1","3","3","鄭明顯","建立資料表","","資料的種類，設定資料表的欄位內容、索引欄位、更改資料表結構，資料工作表的操作",""],["2021/02/03","1","3","3","鄭明顯","尋找、取代、排序與篩選資料","","尋找資料，取代資料，排序資料與篩選資料",""],["2021/02/24","1","3","3","鄭明顯","查詢設計","實習作業一","設計準則、函數、參數型查詢",""],["2021/03/03","1","3","3","鄭明顯","建立美觀的資料輸入表單與列印資料","","利用表單精靈建立表單物件，表單物件的基本操作，快速建立表單，快速建立報表",""],["2021/03/10","1","3","3","鄭明顯","關聯式資料庫的基本知識與E-R Model","","認識關聯、主鍵與連外鍵，資料的完整性，何謂實體關係模型與其組成要素",""],["2021/03/17","1","3","3","鄭明顯","建立關聯式資料庫  進階的查詢應用","實習作業二","如何設計一個完善的資料庫，從客戶分析到建立實體關係模型，整合為全區的概念模型",""],["2021/03/24","1","3","3","鄭明顯","檢定一","","全班分組實施上機測試一",""],["2021/03/31","1","3","3","鄭明顯","期中考","","統一考試周",""],["2021/04/07","1","3","3","鄭明顯","資料表正規化","實習作業三","周實體關係圖與正規化的關係，欄位相依，第一階正規化，第二階與第三階正規化，正規化的另類思考。",""],["2021/04/14","1","3","3","鄭明顯","個案實作報告","","全班分組實施個案實作，並上台操作與報告成果",""],["2021/04/21","1","3","3","鄭明顯","表單的進階設計","","使用精靈設計各式各樣表單，控制項的選取與操作技巧，控制項屬性，善用快顯功能",""],["2021/04/28","1","3","3","鄭明顯","設計美觀實用的報表","實習作業四","建立包含多個全班分組實施上機測試二資料表的報表，修改報表中的各項設定，加入計算欄位，在報表中使用查詢參數",""],["2021/05/05","1","3","3","鄭明顯","檢定二","","全班分組實施上機測試二",""],["2021/05/12","1","3","3","鄭明顯","Access與其他軟體交換資料","","匯出資料表與匯入資料，套用Word的郵件合併列印功能，Office剪貼簿",""],["2021/05/19","1","3","3","鄭明顯","檢定三","","全班分組實施上機測試三",""],["2021/05/26","1","3","3","鄭明顯","個案實作報告","實習作業五","個案實作，並上台操作與報告成果",""],["2021/06/02","1","3","3","鄭明顯","期末考","","統一考試",""]]}