NOTE: Every website, every one has a different look and feel and different styles for their own view website. We don't know what format, what color you like for your webpages. It is why we design myNet.Word, built-in 16 millions color tool, for you to design a colorful webpages. However, to make your webpages more colorful and stylists you can do the following:
1) Have web pages designed by using other software packages then insert into myNet.Office.
2) All you need is a good CSS style sheet file for all the web pages format the way you like. Make a change in CSS file will effect all web pages.
3) myNet.Office plugs in 2 CSS stylist files. One is in the /root/ main folder named: default.css. It is used for public webpages that people see. One is also in the /root/ folder named: system.css. It is used for admin webpages that people can't see. All you need to make your webpages look the way you like is to change the default.css CSS file.
4) Open our web pages, then change the color, the style you want if you know HTML coding.
5) Buy a template website, and modify the way you like.
• We think the good website style must be simple and easy menu navigation. Web pages should not have too many colors, many styles, many formats. Specially it is business, online office not an entertainment place. Website should not be to much colorful and should be as simple as GOOGLE website.
• You should focus on design an impressive "look and feel" and colorful product catalog showcase that we think the most important webpage.
• If you focus too much time on the "look and feel" of webpages, time may be running out for your web project. As you see in the next few days there are more important things to do.
• We help you build the more challenging one - the Virtual Net Office. We don't design myNet.Office in order to design the website. It doesn't worth it. There are FREE or 50$  templates websites, or a lot tools build website out there.

THE RESULT

In the end of the day2, you should see see your virtual office site more complete details. You are able to sell products and services online as well. Let's begin.

STEP BY STEP TO DO FOR DAY 2

1. Create a new database table to hold the submit data. Example create a table named: Sales_Inquiry used for the submit form Sales Inquiry web page. From [myNet.Dbase] pull down menu -> Select [Table] menu in order to Create New Table -> It opens an interface Design Database Table screen. You just follow its steps to design a database table. It is easy.
   OR If you know SQL DATABASE PROGRAMMING, then enter the code create table in the [Code Area] then click on [Submit Query] button. For example, here is the code for creating table Sales Inquiry:
    

   USE SAMPLE CODE TO CREATE A TABLE Sales_Inquiries

   DESCRIPTION OF DATABASE TYPE

   CREATE TABLE Sales_Inquiries ( ID Int not null Auto_Increment Primary Key, EMAIL varchar(50) , NAME varchar (50) , TITLE varchar (50) , APPOINTMENT_DATE Datetime , COMPANY_NAME varchar (50) , COMPANY_SIZE int , WEBSITE varchar (50) , PHONE varchar (50) ,| TOTAL_REVENUE double , SUBJECT Enum  ( "Product", "Service", "Other Helps" ), DESCRIPTION text ); NOTE Copy this code -> Paste in myNet.Dbase [Code Area] in the left corner -> Click on [Submit SQL Code] button -> The new table Sales_Inquiries will be created.

   • ID: Selected as the Primary Key for this table. Because it allows a company to submit the Sales Inquiries many times. If use EMAIL as a Primary Key then a company with email = info@mycompany.com can't submit second time. It declares as Auto_Increment means it automatically increases ID number to plus 1. • EMAIL: Selected as type varchar (50) means it is a string of words of characters. It is not number. It has size = 50 which means can contain 50 characters of email. • TITLE, COMPANY_NAME, WEBSITE, PHONE: see explain type for EMAIL. • APPOINTMENT_DATE: Selected as Datetime type because it is a date with time. • COMPANY_SIZE: Selected as int (Integer number) type because it represents the number of employees and it can't be a decimal. • TOTAL_REVENUE: Selected as double (double number) type because it represents the total revenue it is a decimal number. • SUBJECT: Selected as Enum type because it has a list of choices. • DESCRIPTION: Selected as Text because it can contain more that 250 characters that is the limit of varchar type. Text type can contains 65000  characters. Resources SQL Database Programming: http://www.w3schools.com/SQL/sql_intro.asp

   Click here: http://www.webdevelopersnotes.com/tutorials/sql/mysql_tutorial_selecting_data_using_conditions.php3 for the Database Programming Tutorial.
   To Practice the tutorial: Copy the code in the tutorial. Paste in myNet.Dbase -> Code Area. The results are the same. Good for learning Database Programming.
    

   Picture: myNet.Dbase produces the same result output after running the database code from the tutorial. Every one can learn.  We all get started as dummies. But the difference between us and the true dummies is we want to learn.

   Picture: This output runs on Unix system. This SQL command copy from the tutorial: SELECT f_name, l_name, title from employee_data where title IN ('Web Designer', 'System Administrator'); Will select all first name, last name, title from the database table employee_data where their title IN either 'Web Designer' or 'System Administrator' It is like English-syntax like language. Every one can learn. When you know to use SQL, you will be the master of web database. It will bring your online business, your virtual net office to the next level.

   Web Database is the most important component for the website. You just can't use Gui interface steps by steps to get all complex data like from multi tables.
   Back end web databases don't let you do advanced Database Programming, just in case you need for complex business logics, is a weak database system.
   Do not use it. Also do not spend too much money, licences for databases that is costly, and hard to maintain, required developer to design.
   
   • For example, let say you collect Credit Card number online. But you don't want to keep them in the table Customer. It is a waste of time if you search for
   each customer id and delete their credit card number. So you ask us a support. All you need is past this blue code: Update customer SET card_num = 'xxxx'  
   in myNet.Dbase -> [Code Area] -> Click on [Submit SQL Code]. DONE!   Now all credit card numbers become 'xxxx'. A simple code does it all.
   
   Another example, let say you want to get the data of Invoice Date, Invoice Number, Customer Phone, Email, Alert_Note, Point Earn, and the Total Spend so far
   of this customer with Phone = 416-123-4567x1234. This involves into 2 tables: Customers and Invoices. There is no Gui, no steps by steps can be designed that
   allows you to get the data required. Solution: Here is the code that allows you to get data you want, and the result is output in table row/col format. Easy to read.

   SELECT invoices.deliv_date as inv_date, invoices.invoiceid,  customer.phone as cust_phone,  customer.name,  customer.cust_type,  customer.email,  customer.alert_note,  customer.point_earn, invoices.sub_total as total_spend from customer, invoices where customer.phone ='416-123-4567x1234' and invoices.phone ='416-123-4567x1234'  NOTE All you need is copy and paste this code in blue color in the [Code Area] of myNet.Dbase -> Click on [Submit SQL Code] button. myNet.Dbase will execute the code and display the result in the table/column format that you can view and edit easily. Sorry, we don't want to scare you. But it helps you see and understand why we spend too much time on R&D in designing myNet.Office in order to prepare when complex things, complex data cases happen to your virtual office. If that happens, myNet.Office can handle the situation. In a virtual net office world, it is all about the data. On the Net, if the back end web site doesn't support advanced database. It is a weak backend. A weak website! You must update. Or when business grows. Your data becomes a mess.  It is a little too late to update.
   SELECT invoices.inv_type as invoice_type, count (invoiceid) as total_invoice, count (customerid) as total_cust, sum(invoices.sub_total) as total_sales, sum (invoices.pst_amt) as Total_PST, sum (invoices.gst_amt) as Total_GST from invoices where invoices.inv_date >= '2008-01-01' and invoices.inv_date <='2008-04-30' group by invoices.inv_type	This short SQL programming code will calculate and display report: Total Sales amount, Total GST, Total PST, count Total Invoices, Total Customers in the 1 quarter from 2008/01/01 to 2008/03/30, group by Invoice Type. Then display data in the table row/col format. NOTE: Invoice Type = Cancelled, Complete, or Pending status of that invoice.
   SELECT x_invoice.inv_type, sum( x_invoice.sub_total) as Today_Total_Sales, sum( x_invoice.pst_amt) as Today_Total_Pst, sum(x_invoice.gst_amt) as Today_Total_Gst from x_invoice, sum(Deliv_Tip) as Today_Deliv_Tip, sum(shipping_fee) as Today_Shipping_Fee from x_invoice where x_invoice.invoice_date = '2008-08-30' group by x_invoice.inv_type	This short SQL programming code will search through database. Then calculate and display The End of the Day Report  will display data of today: Invoice Type, Total Sales, today Total_Pst, Total_Gst, Total Shipping Fee.. of all invoices processed today invoice date = 2008-08-30. Change < = (less than or equal)  2008-08-30 before that date.

   These are examples for getting a little bit complex data but common may be required for your online business. Some people don't care.
   As a result, when business grows complex. They realize that their back end system is weak foundation. Data becomes a mess, a little too late to change.
   
   • Click here for the step 1 setup HOW TO CREATE NEW TABLE USING CREATE TABLE TEMPLATE WITHOUT DATABASE PROGRAMMING  
   
   
   Picture: How To Create New Table Using Template - no code, no web skills required. Net.DBase -> [Tables]. Table is created only all conditions satisfied.
   Use myNet.Dbase and its Create New Table Template Tool to create all kinds of web database tables for processing, collaborating, sharing information.
   FEATURES
   • Delete: lets you delete NAME of fields.
   NAME TYPE: Like ENUM, SET are advanced field. ENUM lets you create a list of many options to choose. In this case, you create a SUBJECT table field with option list = {Product, Service, Other Helps' }. But user can select only one. While data type SET like ENUM is also a list of options. But you can select many. In table field will save many options. myNet.Office will see SET field will automatically create a list of many check boxes [x] . To select many just click on it. Use SET to create a form that asks people to select many options.
   
   
   Picture: myNet.Office will automatically create interface of many check boxes for data type SET of field MYSET = ( 'travel', sports', 'dancing', 'fine dining' ), and create interface of pull down option list for data type ENUM of field EAT = ( 'eat in', 'eat out',' eat restaurant' ).
   
   
   Picture: You can see, the result is saved in table. Look at field MYSET has 3 data = sports, dancing, fine dining. EAT has 1 data= eat out.
   Field MYSET is programmed automatically allocated for 33 characters = sum of all characters of its set.
    

2. • Create a webpage content for the form Sales Inquiry. Open [myNet.Page] -> Select [New Page] name Sales Inquiry webpage, enter the following words or what ever, insert pictures.. example: SALES INQUIRIES Would you have a Sales person from our company or do you have a sales question? Please fill out the form.
   • Next, Insert the web database form. From the topmenu [Insert] -> Select [Web Database Form] -> An screen entry opens, you select the table Sales_Inquiry you created in step 1 -> Then select the format form. There are 2 different looks. One is Rounded Corner Blue Form. One is Table Format Form. -> Click on [Insert] button. -> After you insert table, it also creates an email record in table x_email_property of  Email Manager. You must fill all info so that it can send email. (See step 3)
   When people open the web page form Sales Inquiry. Fill the form. Data submitted will be inserted into the database table named: Sales_Inquiry. Now, you can easily process info, share, collaborate, send email campaigner.. what ever. Next, create an email message.
   
   • Click here for this step the setup HOW TO DESIGN A SUBMIT WEB DATABASE FORM IN 5 MINUTES
    
3. Fill data Email Property in table x_email_property for the Sales Inquiries form. After customers submitted the form Sales Inquiries, they will receive an email sent to their email field on the submit form. And your staffs, departments also receive the email informed immediately depending how you set up in Email Property.
   STEP EMAIL PROPERTY: from [myNet.Dbase] pull down menu -> Select [Administration] menu. From the right corner, you click on the pull down list of all tables. Then select the table name: x_email_property in order to setup email message, logos, people and the departments will receive the email after customers submitted the form Sales Inquiry. If you don't want customer receive the email you can setup so. If you don't want an email sent to your people and your customers then you don't need to create the email property for this submit form. DONE! 
   
   • Click here for the setup Email Property WORKING WITH EMAIL MANAGER  

  CONCLUSION FOR STEP OF DAY 2: Design Web Database Form

• First, use myNet.Dbase to design a table in order to store form data using SQL code or Create Table Template -> Next, Use myNet.Page to create a new web page for form display with text, picture... Then use Insert tools to select the table to insert into this web page. -> Finally, open table x_email_property to setup Email property. DONE!
• No programming or designing involved. Sample Output Web Database Form Screen

  BENEFITS OF WEB DATABASE FORM.
In the virtual net office world, it is all about the data .
• Use myNet.Dbase and its Create New Table Template Tool to create all kinds of web database tables for  processing, collaborating, sharing information.
• Create all kinds of forms to collect data from customers, sales, and store in database for collaborating, sharing, processing information, such as search in resume who is name=Smith, or support web form keeps customer's FAQs in database for engineering research...
• Create all kinds of forms, send private link form (See HOW TO DESIGN A SUBMIT WEB DATABASE FORM )  to your partners, suppliers, vendors, and event in-house staffs in order to update status, collect data, survey data, statistic data....store all data in database.
• How long your secretary spend time on the phone for late payment customers?
You create an eCampaigner email to all late bill customers. Create a table late_pay_customers that has: Name, Email, Amount Own, Method Payment, Credit Card Number, Date_Paid....Then create a private link web database form not posted on the website. One click, you send to 5 thousands customers in just 30 seconds. Keep sending the eCampaigner for late bill. Since every paid record is kept in database, you can easily keep track who pay what, when. For 5000 customers, if Billing Staffs spend average 15 minutes/customer. It will take 8 months of labour to call them just 1 tour.