《【酒店管理培訓】酒店《數(shù)據(jù)庫管理》培訓活動綱要》由會員分享，可在線閱讀，更多相關《【酒店管理培訓】酒店《數(shù)據(jù)庫管理》培訓活動綱要（4頁珍藏版）》請在裝配圖網(wǎng)上搜索。

1、A hotel XXX大酒店 TRAINING ACTIVITY OUTLINE 培訓活動綱要 Task 任務：Database Management 數(shù)據(jù)庫管理 Code 序號： OH-SM-MC-A201 Objectives目的：At the end of this session, each trainee will be able to fully understand contact management by using ACCESSS. 在此培訓結束后，每一個學員都要學會使用ACCESS管理聯(lián)系人數(shù)據(jù)庫。 Standard標準：See Attached S&P

2、. 參見后附標準與程序。 Resources培訓器材：Whiteboard, Mark Pen and Projector. 白板，馬克筆、電腦和投影儀。 Method 培訓方式 Training Steps 培訓步驟 Time 時間 Lecture 講座式 1. A brief introduction of database 簡要介紹數(shù)據(jù)庫 Ask trainee awareness of databas

3、e. 詢問學員對數(shù)據(jù)庫的了解。 a. When we handle a great number of items, we need a system to categorize them for easy reference, like we use Cardex for business cards, paper file for documents, albums for photos. 處理大批數(shù)據(jù)時需要一個系統(tǒng)分類以方便使用，就好象我們使用名片盒來裝名片，用文件夾來存儲文件，用相冊來裝相片。 b. The database is something that can h

4、elp us with the library. 數(shù)據(jù)庫就可以在處理大批數(shù)據(jù)時發(fā)揮作用。 It is like Excel, with rows and columns. But it has different format, which is called FORM. 它就象是EXCEL，也有行列；但是可以做成 不同的格式，稱為表單。我們可以在單元 格里輸入數(shù)據(jù)。 c. Another type of form is called subform. It is attached to each rec

5、ord in the form regarding information of this record. For example, a subform may contain all interaction report of one contact (record) in a form. 另一類表單稱為子表單。它依附于表單中的每一個條目，記錄該條目的內(nèi)容。例如，一個子表單記錄著另一個表單中一個聯(lián)系人(條目)所有的交往的報告。 d. Query is a type of form that may combine data from different forms and tables

6、. By using query, we can build up relations among forms. 數(shù)據(jù)表單是一種能從不同表單中吸收數(shù)據(jù)的表格。使用數(shù)據(jù)表單可以在多個表單中建立起相互關聯(lián)。 Demonstrate the database to trainee the structure of the database. 向學員展示數(shù)據(jù)庫的結構組成。 It contains two forms, two queries, one table and one report: a. CONTACTS: This form is about details of

7、 the contact person and his company. b. CALLS Sub-Form: This form is about detail contents of interactions between the contacts and hotel MC department. c. Trace Query: This query is used to for future follow up. d. CONTACTS-CHN query: This query is used to generate Contact Report in Word. e.

8、CONTACT-CHN table is used to generate letters in Word. f. CONTACT-BRIEF: This report contains the every means of communicating the contact person. ---------------------------------------------------------------- 1. 它包含兩個表單，兩個數(shù)據(jù)表， 一個表格, 一個報表: a. CONTACTS： 這個表單是有關媒體和聯(lián)系人的詳細信息 b. CALLS 表單：這個表格是關于公

9、關部經(jīng)理與媒體聯(lián)系人之間的 交往接確的記錄 c. TRACE 數(shù)據(jù)表：用于將來的跟催 d. CONTACTS-CHN 數(shù)據(jù)表: 用于在WORD中生成會面報告 e. CONTACT-CHN表格：是用于在WORD中生成信件 f. CONTACT-BRIEF報表：包括每個聯(lián)系人的基本聯(lián)系信息 Required components for the CONTACTS form are: a. Chinese Name b. Title c. Department d. Company Name e. Telephone Number f. Fax Number 必須要填

10、寫的字段名為： a. 中文名 b. 頭銜 c. 部門 d. 公司名 e. 號碼 f . 號碼 3. The database will be zipped and backed up twice a week and protected against data loss due to any accidental computer problems. 數(shù)據(jù)庫一周壓縮備份兩次，以防電腦故障造成數(shù)據(jù)丟失。 4. Changes made on the structures of the database are subject

11、to MarCom Manager's approval. 修改數(shù)據(jù)庫的結構必須得到公關部經(jīng)理的許可。 5. The database will be password secured. Access to the database is subject to approval of Director of Sales & marketing and MarCom Manager. 數(shù)據(jù)庫要使用密碼保護。使用數(shù)據(jù)庫要得到 營業(yè)總監(jiān)和公關部經(jīng)理的許可。 -------------------------------

12、-------------------------------------- Procedures 程序部分： 1. Update 更新數(shù)據(jù)庫 - Refer to procedure 1 參看程序1 2. Merging with Word - Refer to procedure 2 參看程序2 3. Trace 跟進 - Refer to procedure 3 參看程序3 Trainee Practice 學員練習: 1. Merging to generate Contact Report 合并WORD生成會面報告 2. Generate Label 生成

13、標簽 3. Critique 評估 Summary with emphasis on the database structure and merging. 回顧總結時重點放在數(shù)據(jù)庫結構和合并文件上。 5 min 5 分鐘 20 min 20 分鐘 35 min 35 分鐘 30 min 30 分鐘 20 min 20 分鐘 10 min 10 分鐘 天馬行空官方博客： ://t.qq /tmxk_docin；QQ:1318241189；QQ群：175569632