《【酒店管理培訓(xùn)】酒店《數(shù)據(jù)庫(kù)管理》培訓(xùn)活動(dòng)綱要》由會(huì)員分享，可在線閱讀，更多相關(guān)《【酒店管理培訓(xùn)】酒店《數(shù)據(jù)庫(kù)管理》培訓(xùn)活動(dòng)綱要（4頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。

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

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

3、e. 詢問(wèn)學(xué)員對(duì)數(shù)據(jù)庫(kù)的了解。 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ù)時(shí)需要一個(gè)系統(tǒng)分類以方便使用，就好象我們使用名片盒來(lái)裝名片，用文件夾來(lái)存儲(chǔ)文件，用相冊(cè)來(lái)裝相片。 b. The database is something that can h

4、elp us with the library. 數(shù)據(jù)庫(kù)就可以在處理大批數(shù)據(jù)時(shí)發(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. 另一類表單稱為子表單。它依附于表單中的每一個(gè)條目，記錄該條目的內(nèi)容。例如，一個(gè)子表單記錄著另一個(gè)表單中一個(gè)聯(lián)系人(條目)所有的交往的報(bào)告。 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ù)表單可以在多個(gè)表單中建立起相互關(guān)聯(lián)。 Demonstrate the database to trainee the structure of the database. 向?qū)W員展示數(shù)據(jù)庫(kù)的結(jié)構(gòu)組成。 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. 它包含兩個(gè)表單，兩個(gè)數(shù)據(jù)表， 一個(gè)表格, 一個(gè)報(bào)表: a. CONTACTS： 這個(gè)表單是有關(guān)媒體和聯(lián)系人的詳細(xì)信息 b. CALLS 表單：這個(gè)表格是關(guān)于公

9、關(guān)部經(jīng)理與媒體聯(lián)系人之間的 交往接確的記錄 c. TRACE 數(shù)據(jù)表：用于將來(lái)的跟催 d. CONTACTS-CHN 數(shù)據(jù)表: 用于在WORD中生成會(huì)面報(bào)告 e. CONTACT-CHN表格：是用于在WORD中生成信件 f. CONTACT-BRIEF報(bào)表：包括每個(gè)聯(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. 號(hào)碼 f . 號(hào)碼 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ù)庫(kù)一周壓縮備份兩次，以防電腦故障造成數(shù)據(jù)丟失。 4. Changes made on the structures of the database are subject

11、to MarCom Manager's approval. 修改數(shù)據(jù)庫(kù)的結(jié)構(gòu)必須得到公關(guān)部經(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ù)庫(kù)要使用密碼保護(hù)。使用數(shù)據(jù)庫(kù)要得到 營(yíng)業(yè)總監(jiān)和公關(guān)部經(jīng)理的許可。 -------------------------------

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

13、標(biāo)簽 3. Critique 評(píng)估 Summary with emphasis on the database structure and merging. 回顧總結(jié)時(shí)重點(diǎn)放在數(shù)據(jù)庫(kù)結(jié)構(gòu)和合并文件上。 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