| 當期課號 |
1303 |
Course Number |
1303 |
| 授課教師 |
阮氏清萍 |
Instructor |
NGUYEN THI,THANH BINH |
| 中文課名 |
資料庫概論 |
Course Name |
Introduction of Relational Database |
| 開課單位 |
會計系(四日)一C |
Department |
|
| 修習別 |
必修 |
Required/Elective |
Required |
| 學分數 |
3 |
Credits |
3 |
| 課程目標 |
應用微軟Access軟體套件介紹關聯式資料庫基本概念及其於會計上的應用。課程內容包含基礎資料表、各式查詢、表單及報表等說明及演練；並介紹Access VBA以整合各種元件完成資料庫應用系統。同時輔助學生取得相關證照。 |
Objectives |
Introduce the basic concepts of relational database with Microsoft Access package and its applications in Accounting. The course includes the descriptions and practices of basic data table, various queries, forms and reports. In addition, VBA for Access is also introduced as tools to integrate all components into a complete database application system. Along with the study, the course also provides the guidance for some related certificates about Access. |
| 教材 |
1. Access 2007嚴選教材！資料庫建立．管理．應用。
(作者：楊世瑩，出版社：碁峰，出版日期：2010年03月12日)
2. Access 2007實力養成暨評量
3. Access 2007實力養成暨評量解題秘笈
電腦技能基金會編著 碁峰資訊服份有限公司。 |
Teaching Materials |
1. Access 2007嚴選教材！資料庫建立．管理．應用。
(作者：楊世瑩，出版社：碁峰，出版日期：2010年03月12日)
2. Access 2007實力養成暨評量
3. Access 2007實力養成暨評量解題秘笈
電腦技能基金會編著 碁峰資訊服份有限公司。 |
| 成績評量方式 |
平時測驗/作業&出席狀況 30%
期中考 30%
期末考 (TQC專業測驗) 40% |
Grading |
Quizzes/Homework and Participation 30%
Midterm 30%
Final (TQC Expert Examination) 40% |
| 教師網頁 |
|
| 教學內容 |
本課程以 TQC 實力養成暨評量，漸進導入Access 的資料表、查詢、表單及報表，TQC 術科題庫四大類共 40 題，包含「Access 資料表建構與資料建置」、「Access 查詢類型及設計」、「Access 表單控制項之建立與應用」、「Access報表設計與控制項運用」等類別，讓學生充分掌握Access的特性與應用技巧，提升Access資料庫的理解與應用能力。後段以『ACCESS 2007 VBA應用』整合各種元件完成資料庫應用系統。 |
Syllabus |
This course aims to develop Access TQC skill, including "Access data construction "," Access query and Design "," Access controls and application "," Access report design and control " etc., to enable students to fully grasp the characteristics of Access as well as to enhance the application skills. ACCESS 2007 VBA is also applied to integrate components for performing a database application system. |