- In one Cloud Office Office Database, company can build many software applications for: HR, SALES, FINANCE, MARKETING, SERVICE, CRM,  MANUFACTURING, SUPPLY CHAIN, PROCUREMENT, EMAIL MARKETING SYSTEM, ECOMMERCE.. See: EDBMS Case Study

- All-in-One Office solutions.
-
From 1 website in 1991 to 1 billion websites in 2014, and growing fast every day. 95% of websites are static info.  
=>
Click here see real time statistic.
Office Database built in Office. What Can I do with Office in 30s

Office is Cloud SaaS (Software as a Service) smart website builder for people with no web skills can build and maintain productive smart website.

● Office is All-In-One software package that integrated different Software Product Lines in one Office software product.
Main Product Lines are: Office Cloud Commerce, Office Smart Form Builder, Cloud Dbase, Office Social Collaboration, Word, Office eCampaigner. Use Office, all in-one. Website, E-commerce, Email Marketing, Database... All data, tables are in one place, all integrated, shared the same database. No back and forth. No data every where. Save money to pay for other cloud services. And save time and money to manage data every where.

What you can do with-  Office, and describe main Tools?  Using  Office people without web skill can do:

- What can I do with  Office in 30s


1) Create a nice basic info CMS Content Management System website, with Blog. The software App to design website is the built-in web editor: Office Word see

- What is CMS website? A CMS or Content Management System Website is the basic info website that you can create and update website by yourself, using tool like  Word. You don't need website builder software tool like Dream Weaver software in order to update website.
For example, when web designers designed a basic info website, they used software tool like Dream Weaver to design many Html webpages like: Index.html, AboutUs.html, ContactUs.html then upload to your website. When need to change phone or address in webpage ContactUs.html, you must need the web designer who then used Dream Weaver to open ContactUs.html to change its content. You can't do change ContactUs.html because you don't know and don't have Dream Weaver. Dream Weaver is expensive software, and hard to learn.
- Using myNet.Word to design webpage, when you want to update web page content, you just need to login as Admin of your website. Use myNet.Word, built-in  Office, to open the files and update.
- CMS or Content Management System means self manage the website's content.
-Click and see: A typical  Office 2012 front-end look-and-feel webpage   (Click on picture to enlarge). - Another typical  Office 2012 front-end look-and-feel

2) Build and maintain your own e-commerce website. The main  software App is  Office Cloud Commerce.

- Use this tool, you can build and maintain an online e-commerce website to sell any products and services online. You can sell Restaurant, Foods online, Flowers, Tickets, sell any Products and Services online. People ordered and paid using credit card or PayPal.
If GROUPON can sell business's Products and Services online, then so does your business. Businesses can't just depend on other websites to sell their products and services all the time. The ultimate, businesses have to depend on their own website to sell their products and services.
-  Office Cloud Commerce is built based on the foundation of EDBMS.
See: : Working with Office Cloud Commerce   

3) Build company SQL Database Server, EDBMS. The main  software App is: Cloud Office Database. Click here to learn EDBMS Case Study Examples.

- Using Office Database, you can build a Database Information Management System, EDBMS for the business. One special thing of Office Database is that you can upload pictures, photos, files in its tables so easily without hard coding. This is very hard to do if using other database software. You will learn more when reading this material.
See Office Database Join 5 tables in EDBMS and Display Photos .
(click on photo to enlarge) - Click here to learn what you can do with Office Database in 30s

4) Do Online Marketing, Email Marketing, eCampaigner. The main App is: Office Email Marketing eCampaigner.

When you launch a campaign, it is not the Email, or the News Letters, but the Email List is the most time consuming and challenging because you want to target the right group of customers.
To launch an Email Marketing campaign, eCampaign using Office, you will do 3 steps:
1)
Use Office Database to create an email Contact List, email segment List for Email Marketing. Big difference between Office Database and the simple Email List Builder used in other Email Marketing tools.

Because the simple Email List Builder of other eCampaign software is not Database.
- Therefore, using Email List Builder of other eCampaign Software Tool, you can't do complex SQL, can't complex query, can't complex segment your list. The Email List Builder can't complex search into multi tables, can't joint multi tables. Can't complex filter your database to target people, criteria email conditions you want.

- For example, simple Email List Builder CAN NOT DO THIS CAMPAIGN. Only Database like Office Database can query this campaign condition.
"- Launch A Bringing Customer Back Store Campaign to send coupon, or gift, or promotion, to update new Products and Services for all customers who have not come to our store, not contacted us for over 6 months already. To calculate how long, in Invoice database, minus the Current Date with the Last Date Ordered Field, will tell you how long the customers had not ordered since the last order. Let them fill a Feedback / Wish List form. The form ask: Why not ordering from us because of Price, or Customer Service, or Product Quality? Fill in comment box. What can we do for you? Customer wish list? "

- Let's do another very much simpler campaign that Email List Builder can't do:
"- Search or query 2 tables, the Invoice database, Customer database. Select all customers who bought more than 500$ and give them a 5$ coupon. And bring coupon to store. Or launch a promotion. Or send a notes. Or update new Products and Services."
-
Using myNet.Office, all you need to do is run the query below -> Got the list of all customers who satisfied this condition -> Then use myNet.Office eCampaigner to launch this campaign. This is the query:
SELECT invoice.invoice_id, invoice.invoice_date, sum(invoice.sub_total) as Total, customer.customer_id, customer.name, customer.photo, customer.phone, customer.email, customer.address
FROM customer
INNER JOIN invoice
ON customer.customer_id = invoice.customer_id
GROUP BY customer_id 
// -> GROUP BY: Prevents duplication of a customer who may appear many times on list. Thus receive multi emails. And also sum total all invoices bought by a customer.
HAVING SUM(invoice.sub_total) >= 500

NOTE: Office Database is also let you
save the Email List of customers got from this Query in a new Table for future eCampaign target repeatedly many times on this customer's group.


Picture: A typical Manual Email List Builder used by other Email Marketing eCampaigner Tools to email to people in Email List. Very simple List -> Take long time to build Email List.

NOTE:
Because the eCampaign launched from database like Office Database, not from Email List, you can do data analytic, such as:
- Who contributed the most? Who click the most? Who opt out? - Who didn't click yet so that we target again? - What demographic, such as: City, Population, Gender, Group, Community, Ethnicity... contributed the most? -  Calculate Total amount of donation? ...Then export database to Excel for Email, Print, Graph...

In general, YOU CANíT DO DATA ANALYSIS OF CAMPAIGN RESULT FROM SIMPLE EMAIL LIST BUILDER.
- EMAIL LIST BUILDER CAN'T LET PEOPLE INSERT CREDIT CARD NUMBER, UPDATE THEIR INFO LIKE ADDRESS, EMAIL BECAUSE EMAIL LIST BUILDER IS NOT A DATABASE SERVER.

- EMAIL LIST BUILDER HOSTED BY ANOTHER COMPANY. DON'T PUT YOUR CUSTOMER CREDIT CARD INFO IN THEIR EMAIL LIST BUILDER.


See photo of the Email Contact List created by Office Database for Email Marketing using by myNet.Office eCampaign



Photo: Launch eCampaign using myNet.Office eCampaign + myNet.Office Smart Form + Office Database. Office Database is a powerful tool to search, segment data, and do Campaign Data Analytics.

-
myNet.Office eCampaigner just added new Features tracking Email when people opened their emails sent from myNet.Office eCampaign...
- When
people open their email will automatically update Office Database always available on the Cloud. And how many times, and the time people opened email.
- Track How Many Times Customers have opened your Email, or not open email. And when the Last Time they opened.
- Track How Many Times customers click on email the URL Link, such as: Click here to register for this event, or, Click here to pay for this invoice, embedded in email. And when the Last Time they clicked. See picture of database.
- For example, in this Donation Contribution database, member David Smith did open the eCampaign 's email 2 times ( IS_EMAIL_OPEN = 2), and last time he opened is: 2012-05-10 at 2:45 PM (LAST_DATE_EMAIL_OPENED). There is an email embedded the URL link = Click here to open the Donation Form, and make a donation, David click opened this link Donation Form 2 times (EMAIL CLICK VIEW COUNTER =2). Last time he clicked on this link is 2012-05-10 at 2:45 PM (=LAST DATE CLICK). Then he did make a donation = 850$ on that date.
- Member Peter H didn't open email (IS EMAIL OPEN = 0). Made no donation. Brian W is donated but then opt out don't want to receive email.
- Member Tester did open email 1 time (IS_EMAIL_OPEN = 1) at 2012-05-16, 6:29 PM, but didn't click on the Url Link Donation Form (EMAIL CLICK VIEW COUNTER = 0). Thus didn't make any donation.

- myNet.Office lets you launch eCampaign from Sql, query search. And do all kinds of Campaign Data Analytics.
- For example, to re-launch Donation Campaign for people in database that had not yet open email. You run this query:
- Select * from donation_contribution_db where IS_EMAIL_OPEN = 0  => This query will give the list of donors not yet open email. Now launch campaign on this group.
=> To send all emails beginning with 500 people used primary key ID from 1 to 500:
- Select * from donation_contribution_db where ID >= 1 AND ID <= 500
=> To send thank you notes to donors already made donation more than 100$. You run this query search to get the list of donors:
- Select * from donation_contribution_db where  AMOUNT >= 100
=> To know who did open emails but no click on the Url link Donation Form. You run this query search to get the list of donors:
- Select * from donation_contribution_db where  IS_EMAIL_OPEN > 0  AND EMAIL_CLICK_VIEW_COUNTER = 0
=> To get the list of top 10 donors, just click on column heading AMOUNT to sort in UP or DOWN in order.
=> If your database had data of Gender, Geographic, Ethnicity, City, Company... you can do all kinds of Campaign Data Analytics. Such as: Gender, Ethnicity, who contributed the most, the least...
=> Do Campaign Data Analytics so that you re-target, nurture relationship with people, CRM later...

2) Use
myNet.Word to create Email Marketing file = My Africa Vacation: myNet.Word to create Email Marketing My Africa Vacation file . 

3) Finally, launch
myNet.Office Email Marketing eCampaigner.
- See result of email received by customer the My Africa Vacation marketing =
Email My Africa Vacation - The result email customer received of an eCampaigner Flower Promotion .

IMPORTANT NOTE: As required by Law, Electronic Email Campaign must have option to allow people opt in / opt out of receiving email, just like you made Cold Calls to your customers. Launch eCampaign from a database in PC, people can't opt in / out. Can't update their info like Address, Credit card...Because PC can't let people from outside to do this.
Can't do eCampaign with software, database running on PC, Laptop
.

IN CONCLUSION: To launch an eCampaign using myNet.Office, you do these steps:
-> Use myNet.Word to create an Email or News Letters. Make nice simple letter, simple email like email you send to your customers, your friends.
-> Use myNet.Office Smart Form Builder to create Forms like:
Register Form, Donation Form, Sell Ticket Form, Sell Product Form, Pay Invoice Form. Then embed the Url link of form in email. Or you can also embed an URL link to Product Catalog Sale Item of your website. Such as: Click here to order this Product Catalog Chicken Soup Item.
-> Use Office Database to create Contact List, Customer database. Do search, query to segment list, get list of targeted customers you want to receive emails, and not target every one. Then save the query result as a new table used for this email campaign so that you don't mess up with the original Customer, Contact List table. You can named new table as: August Campaign, or September Campaign, or Donation Campaign...You can always delete the table after campaign is done.
-> myNet.Office eCampaign will automatically add all fields used by eCampaign like: OPTIN (= Continue to receive email or not), IS_EMAIL_OPEN, LAST_DATE_EMAIL_OPENED, LAST_DATE_CLICK, EMAIL_CLICK_VIEW_COUNTER (= Times of click on URL form) to the eCampaign table. These fields are used to help you track the result of your campaign. You can always delete the table or delete these fields after this Email Campaign no longer needed.
-> Finally launch your eCampaign. This eCampaign is saved so that you can re-query and re-launch many times.
- For example, the above table: Donation_Contribution_Db contained the list of Donors who were collected from many tables: Customers, Contact Lists... You then use this table to launch Donation and Contribution Campaign. Using the same table Donation_Contribution_Db repeatedly many time, you do different search, query in order to segment for targeted groups, different criteria, such as: query for: Who didn't open email or Opened email but not make donation. Or send thank you notes to Donors donated > 100$.. and re-send emails to people selected by criteria in table Donation_Contribution_Db.
 

- First, create empty table donation_contribution_db
- Enter data into this table. You can add more fields like: Address, Company...We just try to make a simple table.

CREATE TABLE donation_contribution_db
(
ID int not null auto_increment primary key,
Name varchar(20) ,
Amount double,
Email varchar(30) ,
Title varchar(30),
Phone varchar(30),
Staff_Followup_Note text
);

-
Click here see Data Type like Varchar, Double...
- Copy the list of donors data of Name, Email, Phone, Title  from other tables: Customers, Contact List, Leads, Website Submit Form table... in table Donation. Now you should have donation_contribution_db table with hundreds of donors data copy from other tables. This way, you don't mess up data the original tables: Customers, Contact List, Leads, Accounts, Opportunities table..

INSERT INTO donation_contribution_db (Name, Email, Title, Phone) SELECT Name, Email, Phone, Title
FROM Customers


INSERT INTO donation_contribution_db (Name, Email, Title, Phone) SELECT Name, Email, Phone, Title
FROM Contact_List
- Add extra field = Address after field = Phone into table donation_contribution_db, you run this SQL:

Alter table donation_contribution_db add address varchar (250) after Phone

To add extra field Option List (pull down list to choose) of Group or Ethnicity after field NAME, run this SQL scrip:

Alter table donation_contribution_db  add Groups
Enum ( 'White', 'Blacks', 'Asian', 'Latino', 'Others' ) default 'White' after Name

- Other fields used for tracking the eCampaign results like: OPTIN, IS_EMAIL_OPEN... are automatically added by myNet.Office eCampaign when you launch the campaign.

NOTE: As you see, there are hundreds of different needs that only SQL programs can quickly solve. We can't design hundreds of UIs (User Interfaces) that will satisfy all your needs, hep solve problems like this example. => SQL is short script. Syntax is like English, very easy to learn. You GOOGLE search for SQL script.
- For example, to find duplicate EMAIL, NAME or any duplicate value in table, you GOOGLE this: SQL find duplicate value in table. You get a lot of SQL code examples, like this:
SELECT email, COUNT(*) FROM
donation_contribution_db
GROUP BY email
HAVING COUNT(*) > 1  


=> This is hard for traditional eCampaign software to do all kinds of SQL tasks, move data, copy data from table to another table, because they launch eCampaign from Email List Builder. They don't build in database like Office Database.

=> Do Email Marketing eCampaign to inform people first. Then make phone calls to people who didn't open email. A combination of eCampaign + Phone call will make effective marketing campaign, and help save a lot of time and money

.More campaigns? Click here  | Why Email Marketing, eCampaign is the king: affordable, easy steps, targeted, segment, tracking. More Click here

5) Collaborate with people, with customers. The main software App is:  Office Web Collaboration

This is called Member Collaboration. Which means you the website admin create some tasks, such as: Update Your Account, Change Password, Check Invoice History Order List or also called Order Status, Invoice Payment... using  Office Member Collaboration Tool. Then members, customers login your website will collaborate on these tasks.
For example, create a collaboration Invoice History Order List. Customers login their member Home or My Account will see all order invoices bought, delivery status, invoice payment...
This picture shows you what you can do with collaboration:
Office Login Member Collaboration Home Account

** See getting Business Referrals: How to Create Member Collaboration Member Add Referrals.


Click
see: *** How to create a Webpage with dynamic Menu, a Web Database of My_Support_Center, a Smart Form with Email Notification, an Upload Files Form, Resume Database without database programming, no web skills, all in 15 minutes ***  

Click see: Working with  Office Dynamic Database Menu Navigation.

1) See example, How to use Office Member Collaboration to Create Member Collaboration Data Entry Form for your EDBMS. 
2) See How to Create Member Collaboration Login Update Account Info, such as: Name, Phone, Address, Password...

3) See Office Login Member Collaboration Home Account
4) ** See Working With Member Collaboration, a Social Collaboration Network
5) ** See How to Create Member Collaboration Order Status History List.
6) ** See How to Create Member Collaboration Form.
7) ** See How to Create Member Collaboration Member Add Referrals.
Getting new Referrals, new customers..
8) ** See How to Create Member Collaboration Submit Smart Form Training Services, Upload Files.
9) ** See How to Create Member Collaboration Login Update Account Info, such as: Name, Phone, Address, Password..
10) ** See getting Business Referrals: How to Create Member Collaboration Member Add Referrals.


6) Create simple and complex smart forms. The main software App is: Office Smart Form Builder

Click, see: How to create a Webpage with dynamic Menu, a Web Database of My_Support_Center, a Smart Form with Email Notification, an Upload Files Form, Resume Database without database programming, no web skills, all in 15 minutes ***  

7) Office other Software Tools. There are other software App let you to build website.

- Office Blog Manager Tool used to build Blog...For example, to create a Blog, 1) Use Office Word to create a Blog .  2) Next, use Blog Manager to manage Blog Update STATUS from  Pending = Active. That's is it. You have a Blog. ** See the result of  My Blog created by Office 2012

- Office Album Manager Tool to create flashy Album that can sell.

- Office Product Catalog Design Tool to create professional beautiful Product Catalog -> See Result of a Product Catalog screen Click mouse on the picture to enlarge.

- Office Enterprise File System Explorer Share, work and collaborate files, documents, spreadsheets online anywhere, anytime time in the Enterprise. It helped centralize, compliance, control, and manage files and documents for all employees, staff. myNet.Explore helps business to navigate files system, upload, download files, view files, open files, videos, photos. Create new folders, delete folders, files easily. Download a file, a folder with files as zip file, as files. 


Picture: myNet.Office Enterprise File System Explorer. Make simple to centralize, share, work, collaborate, and manage files and documents.
- A single source of approved and secure documents. It is easy to control and manage documents.
For example, the staff, the engineering department, the sales reps, from any where, on site service, in hotel, different offices, locations.. can access, work, collaborate files and documents. Email Url link to files stored on cloud to customers. Customers open their emails, open, view files by clicking on Url link to files stored on cloud.
- Rather let staff, employees send email to customers with append files, documents, it is much better send email customers the Url link to online server's files, documents, that are always up to date the latest version, and easy managed and control and secure documents sent outside. Because email with append files will leave footprint, and deposited in many servers of the client's mail providers. These files later, are easily traced, easily audited, and hard to erase after email.
-
Staff, employees email each other within the company should send email files, document using Url link to files. Should not send email with append files.
- To send out files, documents from myNet.Office Enterprise File System Explorer, click on check bosses [x] near to files or folders, as many as you like. And then send email with embedding Url link to the files and documents sent. Customers open email, click on the email embedding Url link to access that folders or files stored on server.
- All emails sent from Office Database are tracked if customers open email and click on the Url links.
For example, you send email to John Smith in Customers, or Contacts table. You embed the Url link to the invoice payment. Office Database tracked the email if John Smith opened email and clicked on the Url link to invoice payment.
NOTE: Tracking email is an option for you to select when email in order to ensure important emails, like email of invoice payment, are opened by your clients. You can select option not to track.

- Click here to learn what you can do with Office Database in 30s

Back on top

Do we need to have database and EDBMS for online business website, e-commerce website?

Small simple online business, small simple e-commerce templates, or small simple e-commerce websites may not need database, and EDBMS.
But not recommended because database is the foundation of business website, e-commerce websites.


Database empowered website. Website no built-in database, no EDBMS, is hard to do serious online business. Will be a waste of time and money later on in order to re-design.

Let's say your company is building an e-commerce or a serious business website. EDBMS database chart is the blue print, the architect, the foundation of your website. It is like building an office building without the architect, the blue print.

Picture:
This diagram courtesy from Microsoft SQL Server EDBMS for an e-commerce website.

- This is example of a simple E-Commerce website and its Enterprise Database Management System (EDBMS).
NOTE: Complex e-commerce website will have more tables and more relationships as online business grow.

Click here see Office Database search into multi 6 tables: Orders, OrderDetails, Customers, Products, Suppliers, Employees. Then return all values. This is an example we said that e-commerce website without database EDBMS is not leverage all its potential, hard to manipulate data collecting from website. It is hard to do serious e-commerce website without EDBMS. Therefore, E-commerce website should be built on a EDBMS structure as we proposed.

For example, e-Commerce question. For sure your e-commerce website must have tables in order to store Orders, Order Details, Products, Suppliers, Shipping...
- The question is: Can your e-commerce website do a simple basic JOIN multi table query in order to gate data like this example?
- Every day,
businesses have to deal with Orders, Products, Suppliers, Shipping, Customers, Employees. These are the based components of business.
-
How can staff get a lot more data and information
, so quick and so fast, time efficient of each Order, each Product Stock Inventory, Unit on Order..., the Supplier of each Product, each Shipping, each Customer, each Employee by just 5 seconds hovering the mouse on each key, like CustomerID, EmployeeID? There is no wasting time, days of back and forth, Email, Phone, asking for : - When will be shipping? How many products in stock inventory, its supplier? Who is customer more detail info? Who is employee responsible for this order? Can your e-commerce website doing like this? All about Data Collaboration and using database EDBMS as a centric data updating instantly, sharing and collaborating.
- How long does it take your company, staff to gather all detail information updated instantly about: Order, Product, Shipping, Supplier, Total Sales, Tax, Employee responsible for this order?  Click here.

 

- A lot of businesses, organizations, because lack of knowledge, and having web designers, web developers, also lack of knowledge, as a result, they built e-commerce website, business website that have no tools, no SQL, no EDBMS. As a result, the business kept depending completely on the web designers, web developers for the maintain. And when businesses can't afford web developers no more, as a result the website is abandoned, left alone, static. No one maintained. ** Not only businesses lost money, lost time, but also lost businesses because they can't sell products and provide services **
This is the reason to stop businesses to go next level.

-
Click here to learn EDBMS Case Study Examples. => Used Office Database to design and build all EDBMS in Case Study.