{"course":{"id":"111121701H01","name":"資料庫管理","enroll_type":"選修","general_type":"","dept":"四技工管系","grade":3,"class_group":"甲","teacher":"王文生","credit":3,"hour":3,"time":[{"day":2,"section":[9,10,11]},{"day":4,"section":[9,10,11]}],"classroom":"","max":60,"min":10,"remark":"跨領域專班(本系可修)7/4~9/2甲乙合班","alt_for":"","courses":""},"detail":[["指定教材","李馨．資料庫系統管理與實作．一版．博碩文化．台北．2021"],["參考教材","王仲麒．資料庫系統概論與實務．一版．碁峰資訊．台北．2020"],["成績評量標準","期中考30%\n期末考30%\n平時成績(作業、出缺席、學習態度)40%"],["教學方法","理論講授,實務講授,個人實驗(實作)"],["教學目標","本課程藉由探討資料庫管理系統的認識與應用，著重資料庫範例的實際操作演練，以實務的範例來驗證資料庫理論，期使學生對資料庫系統的學習能有效接軌於未來職涯實務上的運用與管理。"]],"office_time":[["王文生","每周二、四18:00~18:30"]],"schedule":[["2022/07/05","9","11","3","王文生","課程介紹、評分標準、資料庫管理簡介","","資料庫管理簡介",""],["2022/07/07","9","11","3","王文生","第一章\u000b漫談資料庫","","資料處理、資料庫與資料處理模式",""],["2022/07/12","9","11","3","王文生","第二章 Access 2016簡介","","Access 2016工作環境、Access的基本操作",""],["2022/07/14","9","11","3","王文生","第三章 建立Access資料表","作業1","建立資料表及資料分類",""],["2022/07/19","9","11","3","王文生","第四章 活用資料工作表","","資料工作表的基本操作、異動記錄及資料排序",""],["2022/07/21","9","11","3","王文生","第五章 關聯式資料庫","","料庫正規化、分析Access資料表、建立關聯資料表",""],["2022/07/26","9","11","3","王文生","第六章 操作介面-表單","作業2","表單操作、表單檢視模式",""],["2022/07/28","9","11","3","王文生","第七章 彙總資料-報表 \t輸出資料庫物件、製作、閱覽及設計報表","","輸出資料庫物件、製作、閱覽及設計報表",""],["2022/08/02","9","11","3","王文生","期中考","","筆試",""],["2022/08/04","9","11","3","王文生","第八章 選取查詢和運算式","","設定查詢準則、 Access的運算式",""],["2022/08/09","9","11","3","王文生","第九章 進階查詢與SQL","作業3","參數查詢、動作查詢、SQL查詢",""],["2022/08/11","9","11","3","王文生","第十章 深入表單","","表單屬性、多重表單及使用控制項",""],["2022/08/16","9","11","3","王文生","第十一章 強化報表","","自訂報表、加入圖表及報表應用",""],["2022/08/18","9","11","3","王文生","第十二章 資料庫進階管理","作業4","製作切換表單、參數查詢及動作查詢 12.4 SQL查詢",""],["2022/08/23","9","11","3","王文生","第十三章 簡化操作的幫手 - 巨集","","製作簡易巨集、巨集應用、巨集的編輯、偵錯",""],["2022/08/25","9","11","3","王文生","第十四章 VBA強化管理","","巨集轉為VBA、使用變數及流程控制",""],["2022/08/30","9","11","3","王文生","第十五章 與Excel並肩合作","","Access與Excel間資料匯出與匯入",""],["2022/09/01","9","11","3","王文生","期末考","","測驗",""]]}