Session 5 - Assignment One Question

MS Access applications developed for your business are the perfect solution for many small to mid-sized database needs. Whether you are looking to create a new Microsoft Access application, upgrade, or modify an existing MS Access application, System database architects can show you how your business can get the most out of this powerful Microsoft application. Easy-to-maintain, if there are two basic principles behind relation database design. The first principle is that duplicate information is bad. It wastes space and increase the likelihood of error and inconsistencies. The second principle is that the correctness and completeness of information is important. If our database contains incorrect information, any reports that pull information from the database will also contain incorrect information. MS Access can help us to solve this problem. For example, “Customer Name”, if we duplicate a customer name in system we cannot to calculate the correct Sales turnover, accounting report will also contain incorrect information. Therefore, we can fix a system to automatic assign a customer code for each customer name to avoid duplicate data in database system. And, MS Access can help us to consist of one or more record. It’s also possible for a table to be empty (i.e. order processing, customer name, model no., customer P/O no., and order quantity….etc.) Each record is made up of fields or data elements. The fields contain whatever properties or characteristics you want to store in each record. Also, we can used for selecting to view records, used for data input to display, used for formatting, calculating, printing, summarizing data...

Session 4 - Assignment One Question

Some forms of online marketing communication can succeed in catching and holding the user's interest, such as blogs, rich media ads and videos. With the Internet, there is a greater opportunity to collect marketing research about two-way feedback from customers through online surveys, forums or blog comments. Marketing research information is also available from the web site itself, since every time a user click on a link, the websites records the time of their visit and the file that they look at, as well as other things. The information can be analyzed later to gain a better understanding of customer profiles and behaviors. Disneyland websites is provided the about services which is particularly effective Internet Marketing...

http://park.hongkongdisneyland.com/hkdl/html/Summer/en_US/index.html
http://www.disney.com.hk/en/index_flash.html

Customers can sign up to join disney.com.HK!
Members of Disney.com.hk gain access to...can enjoy their exclusive content area as well a quality for online completions and events simply by using the user ID/Password you've selected during the registration process. Disney news mail is their free online newsletter that provides us with the latest information on Disney products and services, as well as news on upcoming events.　

Also, user clicks on a link, http://wap.disney.com.hk/, http://park.hongkongdisneyland.com.hk/. to check more information from Disney, download a wallpaper, screen saver, themes, java games and more of Disney to your phone, user can be forward the about lovely pictures to their friends. It can be set up an indirect marketing.

Ineffective ad, "Mengniuir" which is famed dairy's producer in China.

Their user's cannot find the details information for their product, no two-way communication, no using a marketing concept in websites. I sgguest "Mengniuir" to improve their digital technologies information system to help sell their goods or services. And, let customer know more about their product, use of a company website in conjunction with promotional techniques such as banner advertising...etc.

http://www.mengniuir.com/index.asp

Session 3: Assigment One Question

Online Booking

Select Dates > Select Flights > Fare Details > Passengers > Payment > Confirmation

Most of the HK's people don't have patience on waiting, also they don't waste their time and energy on repeat action. CRM can be improving "History System" to LET'S customer only for few clicks to completed flight reservation. (e.g. only select my ID & password, its shown flight history to let me choose silimer flight, meal favor, pay history-credit card...etc.)

Benefits, Customers interacting with a company perceive the business as single entity, despite often interacting with a number of employees in different roes and departments (Sales, marketing, management…etc.). CRM is a combination of policies, processes, and strategies, implemented by an organization to unify its customer interactions and provide a means to track customer information. It involves the of technology in attracting new and profitable customer.

Information gained through CRM initiatives can support the development of marketing strategy by developing the organization's knowledge in areas such as identifying customer segments, improving customer retaliation improving product offerings (by better understanding customer needs), and by identifying the organization's most profitable customers.

Session 2: Assigment One Question

SAP & ERP

i) Involved Sales,Warehouse & Shipping Dept.
ii) Order – to – delivery process as below: -

SALES
Receive Customer Order --> Using a real time inventory to confirm the stock status --> Create Sales Order --> Post to Warehouse for arrange shipment

WAREHOUSE
Go through with Sales order information (Customer Name, Ship to address, item no and more)--> Generate a Delivery Order and Packing Skip with serial no. from Pick and Pack Manager --> Post shipment

SYSTEM AUTOMATIC
Update an inventory --> sent shipping confirmation to customer (included tracking no. and shipment details ---> inform to salesman the about shipment status

iii) Investing in ERP/SAP, Companies would be consider which business they will grow and maintains. What are the benefits they using an ERP system? Costing for development and maintenance? How many Customers we need to support? How many employees and department will be involved? How large a business we need to grow and maintain? What’s the further business planning? It is important things need to Considering. Normally, the ERP system is not suitable for a small business which development cost more than HK$50/k it was very difficult to afford.

Session 1: Assigment One Question

Asia Miles is Asia's leading travel reward programmed, offering us many exciting rewards to match our lifestyle. And there are so many ways to earn Asia Miles. To earn Asia Miles, simply do what you normally do every day – and then just present your card! Travel the world with our 20 airline partners, including Cathay Pacific and Dragon air. Stay at a huge range of international hotels. Then keep on earning with dining, transport and other activities.

We can earn even more Asia Miles when we use our credit cards with their partners! For example, we can earn miles by dining at a partner restaurant, and earn again by paying for our meal with a partner credit card that converts our credit card points into Asia Miles.


Asia miles offering information system let us easy to use
Airline Earn Calculator and Non-Airline Earn Calculator to calculate how many miles we can earn from our different categories.

After you earn your miles, you can though the internet to redeem your rewards from our nine categories: Flights, Hotel and Holiday Packages, Wine & Dine, Leisure & Sport, Electronics & Accessories, Household & Other Merchandise, Gifts, Flowers & Hampers, Car Rental & Transportation, and Health & Beauty.

Mobile Channel, Get up-to-the-minute Asia Miles information while you're on the move with your Web-enabled mobile phone. Just type m.asiamiles.com into your phone browser and bookmark this address for continuous use. We can check a mileage balance, registered promotion, find partner restaurants, retrieve latest new…etc.

Invitation...