課程名稱:進階 Access 2013 資料庫處理課程 - 簡稱:Access Training Course (2013 Advanced) |
詳細教授內容 :
1. Sort and Filter (排序及篩選)
Sorting (排序)
Filtering (篩選)
--- Filter By Form
(依表單篩選)
--- Filter By Selection
(依選取範圍篩選)
--- Advanced Filter/Sort
(進階篩選/排序)
2. Relationships (關聯)
Create “Relationships”
Types of “Relationships”
--- Enforce Referential
Integrity (強迫參考完整性)
--- Cascade Update
Related Fields (重疊顯示更新相關欄位)
--- Cascade Delete
Related Records (重疊顯示刪除相關記錄)
--- Not Select All
The Above Three Types Of “Relationships”
Delete “Relationships”
Insert Table to Create New “Relationships”
3. Advanced Query (查詢)
Create Query For Calculations (計算)
Query Properties
--- Unique Values
(唯一值)
--- Top Values (臨界數值)
Join Tables (連接資料表)
AutoLookup Queries (自動查閱查詢)
Use Parameter (參數)
Summarize Data
Use Calculation Expressions to Summarize Data
4. Action Queries (動作查詢)
Update Query (更新查詢)
Append Query (新增查詢)
Delete Query (刪除查詢)
Make-Table Query (產生資料表查詢)
5. Advanced Forms (表單)
Add Field List to Form
Use Toolbox (工具箱)
--- Option Group
(選項群組)
--- Combo Box (組合方塊)
and List box (清單方塊)
--- Command Button
(指令按鈕)
--- Tab Control
(索引標籤控制項)
Form Sections
Locate Object
Format Form
--- Fill/Back Color
(填滿/背景顏色)
--- Font/Fore Color
(字型/前景色彩)
Form Properties (屬性)
Macro Builder (巨集建立幫手)
6. Advanced Reports (報表)
Report Sections
Sorting and Grouping (排序及群組)
Report Properties (屬性)
7. Switchboard Manager (切換表單管理員)
8. Advanced “Index” (索引的深入理解)
Single Field Index (單一欄位索引)
Multiple Field Indexes (多重欄位索引)
9. Security (保全)
|