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