|
|
Available Now - Tutorial #1 Is Free! Introduction - So, you want to build a website?The goal was to have a business with minimal overhead that could be run from virtually anywhere with a laptop, an Internet connection, and a cell phone. Well, I have accomplished that and more and you can as well. In 2004 I decided I wanted to have an Internet store and sell products over the World Wide Web. I did not know what HTML meant nor did I know where to begin. It couldn’t be that difficult, there are all sorts of websites out there. Sound familiar? Well, there is a lot more to it than you might think and these tutorials will help you get started and understand the dos and don’ts of web development and e-commerce integration. It took several years, a lot of research, and much trial and error but I finally accomplished the goal. I have built several e-commerce websites, web based accounting programs, and customer tracking applications. I have explored and continue to explore the many avenues to website creation and e-commerce management. I have been asked by so many people if I would help them get started with their web interests that I was compelled to create these comprehensive tutorials. These tutorials address issues and procedures that will help anyone interested in creating and managing anything from a small website to an e-commerce web store. But, more importantly, attain the goal! I paid several thousand dollars to have a 3rd party build my first website. This was an expensive lesson by which I only garnished a few static web pages that did not even begin to fulfill my needs. While on this journey, I was not able to find any comprehensive information about what I was trying to achieve. The few books I did purchase were of little help and quite costly. I found that the information I needed was scattered in bits and pieces here and there all over the place. This is understandable because most of the elements that make up this process are sciences unto themselves with volumes written about each. There are more variations, choices, similarities, and differences than a maze. These tutorials are an attempt to sort that all out for you and educate you enough to be able to function, maneuver, and evolve in this ever changing e-commerce environment. Within these tutorials I discuss each topic listed in the left hand side bar from a macroscopic perspective so you can learn the alternatives available, and there are many, for each element of the e-commerce process. I also show you the nuts and bolts of the methods I think constitute the easiest and most cost-effective alternative for someone just starting out. I demonstrate the use of software and programming languages that are some of the easiest to grasp and use. Exposure to these programming languages and methods will provide you with a foundation of understanding that will prove invaluable should you decide to move on to more complex solutions. The subject matter of the tutorials is such that you can attain the level of expertise and involvement that you are comfortable with and still accomplish the goal.
You will gain an in-depth understanding of the choices that are at your disposal and see first hand the good and bad points of each. The tutorials are a road map that will get you from where you are to where you want to be. You could spend months perusing the Internet to find even this small amount of information and figuring out how to make it work. More importantly, I provide you with the knowledge to market, manage, and protect your web creation so all of your hard work and effort deliver a profitable and enjoyable experience. In the market today there are literally hundreds of companies who offer free Internet stores and Internet sales opportunities in price ranges from free to several thousand up-front dollars coupled with monthly fees. Others offer “canned” or pre-written software that can be purchased to facilitate the creation of websites or web stores. Some require little or no programming knowledge while others require the user to have already attained a relevant level of competent programming skills. Others offer templates or code snippets that can be used within your web pages by simply copying and pasting some code in the appropriate locations within your web pages. All of these entities have their place and can be a good or bad choice depending on your requirements, abilities, knowledge, and the time and money you have to invest in your intended endeavor. The caveat is that, should you choose to go in a direction that does not best suit your needs, backing up and starting over can be a costly and time consuming process. I strongly suggest you know what is available, understand the good and bad points of each, and evaluate your options carefully before and while moving forward. These tutorials are the antidote to this problem. This is not a get rich quick scheme. I will not tell you that just anyone can do this - no experience required - or promise you first page search engine listings. These are sales gimmicks that attract the uninformed and are more than likely designed to liberate you of some of your money. Caution is advised when such promises are touted. Web building and maintenance coupled with actually running a business is a lot of work and can be costly and frustrating with little reward when not correctly pursued. Very few e-commerce websites actually turn a profit. To make a reasonable income from an Internet business requires the culmination of many elements, many that do not have anything to do with the web environment itself. So, just having a great website and a handful of products is not going to make you a dime if other critical elements are poorly planned or nonexistent. The following tutorials will give you a total understanding of what is needed to bring all of the elements together into a well oiled Internet machine. Now that we are done with that disclaimer, let’s take a look at what can be accomplished. These tutorials will help you learn how to develop a simple database driven e-commerce web store for an all up cost of around $52.00 per month. Yep - that is what it costs me for my domain, hosting, payment processing ability, and shopping cart that facilitates a 3000+ product 700+ page dynamically generated e-commerce web store with the combination of elements I chose. The price doesn’t change or fluctuate over time or as sales go up or down as they can with many available service plans. More importantly, I can alter my website, order processing, or invoice tracking to suit my needs as circumstances change with minimal effort. Now that $52.00 monthly cost assumes you are already using a computer with a Windows XP or Windows Vista operating system and have Microsoft Office installed. Your computer will need to be able to handle having several memory intensive applications running at the same time. I found a 1GHz processor with 1GB ram works but is a little slow. I am using a 2GHz processor with 2GB ram and it runs nicely. You will also have to be hooked up to a high speed Internet connection. Dial up won't cut it. This overhead is not included in the $52 cost nor is the cost of the Internet connection or phones. Additional software required will be a one time cost of around $400 for accounting software and a copy of Microsoft FrontPage. There are many choices and therefore the opportunity to do more and save some money or do less and spend more money are available. So, as you look at all the available options keep these figures in mind. I point these opportunities out to you. Generally, the more you have someone else do for you, the more it is going to cost you. There are exceptions and we discuss them in tutorial 2. Let me give you an example. One particular website service charges $90 per month with a minimum of a 1 year subscription to create and maintain a simple 5 page static website for you. A little pricey don’t you think? This is a real offer from a very large company who I will not name who claims to have over 70,000 customers. Imagine if you wanted to expand into a real business? It can get expensive quickly. There are several websites referred to within these tutorials. These websites have been created using the techniques and information contained within the various tutorials. All but the Dinky Dog Accessories website are currently operational entities either selling products or being used by the client for the intended purpose. From these, you can experience the result of what these tutorials will teach you. The look, feel, and subject matter is up to you. These websites are: All but three of the above websites are using Microsoft Office Excel spread sheet software as a data source. Two of them use both Microsoft Office Excel and Microsoft Office Access and one of them exclusively uses Microsoft Office Access for a database. TotalWebInfo.com uses Microsoft Office Excel as a data source. Pizza 101 does not use a data source at all and is a static website. SC Builders & Construction and Pizza 101 are built around a style sheet and divisions (<div> </div>) as opposed to tables. Please have a look at the websites and if you would like to understand how to build and manage such creations please read on. Have fun and enjoy! More than 120 Instructional Videos - View A List Of Them Here!3 Example Videos
Websites and Data Connections
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Video Reference Guide | ||||||
| Grand Total - All Tutorials All Videos | 146 | 1,962.2 Min. | 32.7 Hrs. | |||
| Tutorial 1 | ||||||
| Video Totals This Tutorial | 1 | 13.5 Min. | 0.2 Hrs. | |||
| >> Roadmap Reference 1 | 13.5 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 1 | 13.5 Min. | 0.2 Hrs. | |||
| Video Totals This Tutorial | 1 | 13.5 Min. | 0.2 Hrs. | |||
| Tutorial 2 | ||||||
| Video Totals This Tutorial | 3 | 60.0 Min. | 1.0 Hrs. | |||
| >> Roadmap Reference 2 | 16.5 Min. | 0.3 Hrs. | ||||
| Total Videos This Section | 1 | 16.5 Min. | 0.3 Hrs. | |||
| Go To Tutorial 2 Section 1 >> How to set up email accounts. | ||||||
| 11.5 Min. | 0.2 Hrs. | |||||
| Total Videos This Section | 1 | 11.5 Min. | 0.2 Hrs. | |||
| Go To Tutorial 2 Section 2 >> Install osCommerce PHP/MySQL Template | ||||||
| >> Install PHP / MySQL osCommerce Template | 32.0 Min. | 0.5 Hrs. | ||||
| Total Videos This Section | 1 | 32.0 Min. | 0.5 Hrs. | |||
| Video Totals This Tutorial | 3 | 60.0 Min. | 1.0 Hrs. | |||
| Tutorial 3 | ||||||
| Video Totals This Tutorial | 31 | 347.0 Min. | 5.8 Hrs. | |||
| >> Roadmap Reference 3 | 13.0 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 1 | 13.0 Min. | 0.2 Hrs. | |||
| Go To Tutorial 3 Section 1 >> Intro To Programming Languages & Scripts | ||||||
| >> Intro To Programming Languages | 29.5 Min. | 0.5 Hrs. | ||||
| >> Everything You Need To Know About The Path To A File | 27.0 Min. | 0.5 Hrs. | ||||
| Total Videos This Section | 2 | 56.5 Min. | 0.9 Hrs. | |||
| Go To Tutorial 3 Section 2 >> Open New Window Examples | ||||||
| >> JavaScript open page in new window demonstration. | Diagram | |||||
| >> JavaScript open page in new window code. | Diagram | |||||
| >> JavaScript and web browsers open page in new window demonstration. | Diagram | |||||
| >> JavaScript open page in new window diagram. | Diagram | |||||
| >> Web Browser Differences When Opening A New Window with the OnClick or OnSelect JavaScript Events | 11.0 Min. | 0.2 Hrs. | ||||
| >> Put all of your Javascript in one .js page and link that page to all of your pages. | 13.5 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 2 | 24.5 Min. | 0.4 Hrs. | |||
| Go To Tutorial 3 Section 3 >> PHP / Apache Server / XAMPP | ||||||
| >> How to install and use XAMPP (Apache Server / PHP / MySQL) on your local machine | 13.5 Min. | 0.2 Hrs. | ||||
| >> How to run PHP on IIS | 15.0 Min. | 0.3 Hrs. | ||||
| >> Server Behaviors and Web Page Extensions (.html, .php, .asp) | 13.5 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 3 | 42.0 Min. | 0.7 Hrs. | |||
| Go To Tutorial 3 Section 4 >> Introduction To Web Creation and Management Tools | ||||||
| >> Introduction To Web Creation and Management Tools | 7.0 Min. | 0.1 Hrs. | ||||
| >> Misrosoft FrontPage 2003 | 8.5 Min. | 0.1 Hrs. | ||||
| >> Adobe Dreamweaver CS4 | 6.5 Min. | 0.1 Hrs. | ||||
| >> Microsoft Expressin Web 2 and 3 | 8.5 Min. | 0.1 Hrs. | ||||
| Total Videos This Section | 4 | 30.5 Min. | 0.5 Hrs. | |||
| Go To Tutorial 3 Section 5 >> Introduction To Microsoft FrontPage 2003 | ||||||
| >> How to enable FrontPage extensions. | 4.0 Min. | 0.1 Hrs. | ||||
| >> How to log on to your host. | 4.0 Min. | 0.1 Hrs. | ||||
| >> How to create and set up a new web page. | 5.0 Min. | 0.1 Hrs. | ||||
| >> How to use the WYSIWYG editor. | 5.5 Min. | 0.1 Hrs. | ||||
| >> How to use edit undo and redo. Using the Folder List. | 4.0 Min. | 0.1 Hrs. | ||||
| >> How to see hidden files and folders. How to import and export files. | 5.5 Min. | 0.1 Hrs. | ||||
| >> How to transfer files around using Microsoft FrontPage. FTP / Publishing | 11.0 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 7 | 39.0 Min. | 0.7 Hrs. | |||
| Go To Tutorial 3 Section 6 >> Moving Files Around - FTP / Publishing | ||||||
| >> How to transfer files using Go Daddy's FTP Client. | 5.0 Min. | 0.1 Hrs. | ||||
| >> How to transfer files using Microsoft FrontPage. FTP / Publishing | 11.0 Min. | 0.2 Hrs. | ||||
| >> How to transfer files using Microsoft Expression Web 2. | 14.0 Min. | 0.2 Hrs. | ||||
| >> How to transfer files using Microsoft Internet Explorer 8. | 5.0 Min. | 0.1 Hrs. | ||||
| >> How to transfer files using Mozilla Firefox. | 4.0 Min. | 0.1 Hrs. | ||||
| >> How to transfer files using Adobe Dreamweaver CS4. | 11.5 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 6 | 50.5 Min. | 0.8 Hrs. | |||
| Go To Tutorial 3 Section 7 >> Includes - ASP, PHP & HTML | ||||||
| >> ASP Includes Part 1 | 14.5 Min. | 0.2 Hrs. | ||||
| >> ASP Includes Part 2 | 17.0 Min. | 0.3 Hrs. | ||||
| >> PHP Includes | 18.5 Min. | 0.3 Hrs. | ||||
| >> HTM and HTML Includes | 11.0 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 4 | 61.0 Min. | 1.0 Hrs. | |||
| Go To Tutorial 3 Section 8 >> Tables and Web Page Layout | ||||||
| >> Why Use Tables? | 3.0 Min. | 0.1 Hrs. | ||||
| >> How To Use Tables. | 27.0 Min. | 0.5 Hrs. | ||||
| Total Videos This Section | 2 | 30.0 Min. | 0.5 Hrs. | |||
| Video Totals This Tutorial | 31 | 347.0 Min. | 5.8 Hrs. | |||
| Tutorial 4 | ||||||
| Video Totals This Tutorial | 87 | 1,369.2 Min. | 22.8 Hrs. | |||
| >> Roadmap Reference 4 | 20.0 Min. | 0.3 Hrs. | ||||
| Total Videos This Section | 1 | 20.0 Min. | 0.3 Hrs. | |||
| Go To Tutorial 4 Section 1 >> How many characters can the PHP GET method handle? | ||||||
| >> How many characters will the PHP GET method return? | 13.0 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 1 | 13.0 Min. | 0.2 Hrs. | |||
| Go To Tutorial 4 Section 2 >> JavaScript Events and Web Browsers | ||||||
| >> JavaScript Events and Web Browsers | 10.5 Min. | 0.2 Hrs. | ||||
| >> Put your JavaScript in a .js file and use the Script tag to include the JavaScript in your web pages. | 13.5 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 2 | 24.0 Min. | 0.4 Hrs. | |||
| Go To Tutorial 4 Section 3 >> Intro To Data Sources | ||||||
| >> Introduction to Database Connections - Scripting Languages. | 9.0 Min. | 0.2 Hrs. | ||||
| >> Introduction to Database Connections - Data Sources. | 9.5 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 2 | 18.5 Min. | 0.3 Hrs. | |||
| Go To Tutorial 4 Section 4 >> MySQL | ||||||
| >> How to install the MySQL ODBC driver in Windows and create a DSN for the MySQL database connection | 4.5 Min. | 0.1 Hrs. | ||||
| >> How to create a MySQL database at a host - Go Daddy | 23.0 Min. | 0.4 Hrs. | ||||
| >> How to install and use XAMPP (Apache Server / PHP / MySQL) on your local machine. | 13.5 Min. | 0.2 Hrs. | ||||
| >> How to create a MySQL database on your local machine | 7.0 Min. | 0.1 Hrs. | ||||
| >> Using Microsoft FrontPage, how to connect to a MySQL database from an .asp page where the ASP web page and MySQL database are hosted on different servers. | 11.0 Min. | 0.2 Hrs. | ||||
| >> Using another VBScript method, how to connect to a MySQL database from an .asp page where the ASP web page and MySQL database are hosted on different servers. | 31.5 Min. | 0.5 Hrs. | ||||
| >> Using Adobe Dreamweaver, how to connect to a remote MySQL database from an .asp page where the ASP web page is resident on your local machine and uploaded to your host | 28.5 Min. | 0.5 Hrs. | ||||
| Total Videos This Section | 7 | 119.0 Min. | 2.0 Hrs. | |||
| Go To Tutorial 4 Section 5 >> Microsoft Office Access - Create Relational Tables - Connect to web page. | ||||||
| >> Brief Introduction To Microsoft Office Access and Relational Tables | 25.0 Min. | 0.4 Hrs. | ||||
| >> How to set up Microsoft Office Access database to be used as a data source for a web page. | 11.0 Min. | 0.2 Hrs. | ||||
| >> Hook up the database using Microsoft FrontPage and see the results on a .asp page. | 6.0 Min. | 0.1 Hrs. | ||||
| >> How to use ASP and the data management tools of Adobe Dreamweaver to retrieve data from file based Microsoft Office Access databases and Microsoft Office Excel data sources and dispaly the data both locally and from your hosted server - Part 1. | 25.0 Min. | 0.4 Hrs. | ||||
| >> Continued from above - Part 2 | 23.0 Min. | 0.4 Hrs. | ||||
| >> Continued from above - Part 3 | 26.5 Min. | 0.4 Hrs. | ||||
| Total Videos This Section | 6 | 116.5 Min. | 1.9 Hrs. | |||
| Go To Tutorial 4 Section 6 >> Microsoft Office Excel | ||||||
| >> Brief Introduction To Microsoft Office Excel | 16.0 Min. | 0.3 Hrs. | ||||
| >> Introduction To Functions and Formulas | 15.0 Min. | 0.3 Hrs. | ||||
| >> Break Up A Character String Using The Functions =Len() =Mid() =Left =Find. | 9.0 Min. | 0.2 Hrs. | ||||
| >> =Vlookup() function | 13.0 Min. | 0.2 Hrs. | ||||
| >> =if() function | 9.5 Min. | 0.2 Hrs. | ||||
| >> =trim() and =concatenate() functions | 6.5 Min. | 0.1 Hrs. | ||||
| >> Real life example - Using Microsoft Office Excel to correct a suppliers database. | 14.0 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 7 | 83.0 Min. | 1.4 Hrs. | |||
| Go To Tutorial 4 Section 7 >> Microsoft Office Excel As Data Source | ||||||
| >> Prepare Microsoft Office Excel workbook for use as a data source | 6.0 Min. | 0.1 Hrs. | ||||
| >> Use Microsoft FrontPage to create a .asp page and return data from the Microsoft Office Excel Workbook .xls file created in the previous vedio | 13.2 Min. | 0.2 Hrs. | ||||
| >> How to use ASP and the data management tools of Adobe Dreamweaver to retrieve data from file based Microsoft Office Access databases and Microsoft Office Excel data sources and dispaly the data both locally and from your hosted server - Part 1. | 25.0 Min. | 0.4 Hrs. | ||||
| >> Continued from above - Part 2 | 23.0 Min. | 0.4 Hrs. | ||||
| >> Continued from above - Part 3 | 26.5 Min. | 0.4 Hrs. | ||||
| >> Do It Yourself VBScript (ASP) database connection and returns. | 34.0 Min. | 0.6 Hrs. | ||||
| Total Videos This Section | 6 | 127.7 Min. | 2.1 Hrs. | |||
| Go To Tutorial 4 Section 8 >> Microsoft FrontPage 2003 & Using Databases | ||||||
| >> Retrieving data from a file based data sources using Microsoft FrontPage - Microsoft Office Access and Excel | 22.0 Min. | 0.4 Hrs. | ||||
| >> How to connect to a SQL Server database hosted on a server using Microsoft FrontPage. | 8.0 Min. | 0.1 Hrs. | ||||
| >> Using Microsoft FrontPage, how to connect to a MySQL database from an .asp page where the ASP web page and MySQL database are hosted on different servers. | 11.0 Min. | 0.2 Hrs. | ||||
| >> Using another VBScript method, how to connect to a MySQL database from an .asp page where the ASP web page and MySQL database are hosted on different servers - Part 1. | 31.5 Min. | 0.5 Hrs. | ||||
| >> How to manipulate the Global.asa file used by Microsoft FrontPage to manage connection strings. | 12.5 Min. | 0.2 Hrs. | ||||
| >> How to use Microsoft FrontPage to create a Microsoft Office Access database and interface to store and retrieve data. | 11.0 Min. | 0.2 Hrs. | ||||
| >> How to manipulate data results bound to an ASP page by Microsoft FrontPage. - Part 1 | 17.0 Min. | 0.3 Hrs. | ||||
| >> Continued from above. - Part 2 | 20.5 Min. | 0.3 Hrs. | ||||
| >> Continued from above. - Part 3 | 17.5 Min. | 0.3 Hrs. | ||||
| >> Continued from above. - Part 4 | 9.0 Min. | 0.2 Hrs. | ||||
| >> What ASP embedded in HTML and HTML embedded in ASP means and looks like using Microsoft FrontPage. | 12.0 Min. | 0.2 Hrs. | ||||
| >> How to enable IIS and FrontPage extensions on your local computer using Windows Vista | 5.0 Min. | 0.1 Hrs. | ||||
| Total Videos This Section | 12 | 177.0 Min. | 3.0 Hrs. | |||
| Go To Tutorial 4 Section 9 >> Data Connections Explained | ||||||
| >> Introduction to Database Connections - Scripting Languages. | 9.0 Min. | 0.2 Hrs. | ||||
| >> Introduction to Database Connections - Data Sources. | 9.5 Min. | 0.2 Hrs. | ||||
| >> Introduction to Database Connections - Connection Strings. | 10.0 Min. | 0.2 Hrs. | ||||
| >> More detailed connection string information. | 24.0 Min. | 0.4 Hrs. | ||||
| Total Videos This Section | 4 | 52.5 Min. | 0.9 Hrs. | |||
| Go To Tutorial 4 Section 10 >> Adobe Dreamweaver CS4 & Accessing Databases | ||||||
| >> Web site definition | 10.5 Min. | 0.2 Hrs. | ||||
| >> How to enable IIS on your local computer using Windows Vista | 5.0 Min. | 0.1 Hrs. | ||||
| >> How to create a system data source name (DSN) on your local computer using Windows Vista | 4.0 Min. | 0.1 Hrs. | ||||
| >> Server.Map Path and Response.Write | 8.0 Min. | 0.1 Hrs. | ||||
| >> How to use ASP and the data the data management tools of Adobe Dreamweaver to retrieve data from server based SQL and MySQL databases and display the data both locally and from your host server. | 29.0 Min. | 0.5 Hrs. | ||||
| >> How to use ASP and the data management tools of Adobe Dreamweaver to retrieve data from file based Microsoft Office Access databases and Microsoft Office Excel data sources and display the data both locally and from your hosted server - Part 1. | 25.0 Min. | 0.4 Hrs. | ||||
| >> Continued from above - Part 2 | 23.0 Min. | 0.4 Hrs. | ||||
| >> Continued from above - Part 3 | 26.5 Min. | 0.4 Hrs. | ||||
| >> Do It Yourself VBScript (ASP) database connection and returns. | 34.0 Min. | 0.6 Hrs. | ||||
| >> How to use PHP to retrieve data from a MySQL database using Adobe Dreamweaver and display the data on both locally and on your hosted server. | 12.5 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 12 | 177.5 Min. | 3.0 Hrs. | |||
| Go To Tutorial 4 Section 11 >> Microsoft Expression Web - Database Connectivity | ||||||
| >> How to create a data source name (DSN) on your local machine using Windows Vista | 4.0 Min. | 0.1 Hrs. | ||||
| >> How to retrieve data from Server based databases using Microsoft Expression Web | 40.5 Min. | 0.7 Hrs. | ||||
| >> How to retrieve data from File based data sources using Microsoft Expression Web - Part 1. | 31.0 Min. | 0.5 Hrs. | ||||
| >> Continued from above - Part 2 | 18.5 Min. | 0.3 Hrs. | ||||
| Total Videos This Section | 4 | 94.0 Min. | 1.6 Hrs. | |||
| Go To Tutorial 4 Section 12 >> Using VBScript (ASP) or PHP to connect to a data source and return data without using an editing software management tool. | ||||||
| >> Do It Yourself VBScript (ASP) database connection and returns. | 34.0 Min. | 0.6 Hrs. | ||||
| Total Videos This Section | 1 | 34.0 Min. | 0.6 Hrs. | |||
| >> Do It Yourself PHP database connection and returns. | 0.0 Min. | 0.0 Hrs. | ||||
| Total Videos This Section | 1 | 0.0 Min. | 0.0 Hrs. | |||
| Go To Tutorial 4 Section 13 >> SQL Queries | ||||||
| >> Using Microsoft FrontPage to create SQL queries with query variables. | 49.5 Min. | 0.8 Hrs. | ||||
| >> Using Adobe Dreamweaver to create SQL queries with query variables. | 8.0 Min. | 0.1 Hrs. | ||||
| >> Using the Structured Query Language to create SQL queries with query variables and wild cards. | 43.5 Min. | 0.7 Hrs. | ||||
| >> More SQL and relational tables with Microsoft Office Excel. | 19.0 Min. | 0.3 Hrs. | ||||
| Total Videos This Section | 4 | 120.0 Min. | 2.0 Hrs. | |||
| Go To Tutorial 4 Section 14 >> Building the Dinky Dog Accessories web site using ASP, PHP, and ASP.NET and using Microsoft FrontPage, Expression Web, Adobe Dreamweaver, and no editing software to build the site with Microsoft Office Excel and MySQL as data sources. | ||||||
| >> Introduction - Part 1 | 8.0 Min. | 0.1 Hrs. | ||||
| >> Introduction - Part 2 | 6.0 Min. | 0.1 Hrs. | ||||
| >> How to build the Dinky Dog Accessories web site using ASP and Microsoft FrontPage 2003. - Part 1 | 9.5 Min. | 0.2 Hrs. | ||||
| >> Continuation from above. - Part 2 | 7.0 Min. | 0.1 Hrs. | ||||
| >> Continuation from above. - Part 3 | 10.0 Min. | 0.2 Hrs. | ||||
| >> Continuation from above. - Part 4 | 9.0 Min. | 0.2 Hrs. | ||||
| >> How to build the Dinky Dog Accessories web site using ASP and Adobe Dreamweaver CS4. - Part 1 | 7.5 Min. | 0.1 Hrs. | ||||
| >> Continuation from above. - Part 2 | 7.0 Min. | 0.1 Hrs. | ||||
| >> Continuation from above. - Part 3 | 8.0 Min. | 0.1 Hrs. | ||||
| >> Continuation from above. - Part 4 | 6.5 Min. | 0.1 Hrs. | ||||
| >> Continuation from above. - Part 5 | 15.5 Min. | 0.3 Hrs. | ||||
| >> Continuation from above. - Part 6 | 11.0 Min. | 0.2 Hrs. | ||||
| >> Continuation from above. - Part 7 | 14.0 Min. | 0.2 Hrs. | ||||
| >> How to build the Dinky Dog Accessories web site using ASP (VBScript) and and NO data management software. | 50.5 Min. | 0.8 Hrs. | ||||
| >> How to build the Dinky Dog Accessories web site using PHP and Adobe Dreamweaver CS4's data management tools. - Part 1 | 6.5 Min. | 0.1 Hrs. | ||||
| >> Continuation from above. - Part 2 | 5.5 Min. | 0.1 Hrs. | ||||
| >> Continuation from above. - Part 3 | 11.0 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 17 | 192.5 Min. | 3.2 Hrs. | |||
| Video Totals This Tutorial | 87 | 1,369.2 Min. | 22.8 Hrs. | |||
| Tutorial 5 | ||||||
| Video Totals This Tutorial | 23 | 163.0 Min. | 2.7 Hrs. | |||
| >> Roadmap Reference 5 | 12.0 Min. | 0.2 Hrs. | ||||
| Total Videos This Section | 1 | 12.0 Min. | 0.2 Hrs. | |||
| Go To Tutorial 5 Section 1 >> Intuit QuickBooks | ||||||
| >> Introduction to Intuit QuickBooks Premier 2009. | 0.0 Min. | 0.0 Hrs. | ||||
| Total Videos This Section | 1 | 0.0 Min. | 0.0 Hrs. | |||
| Go To Tutorial 5 Section 2 >> Order Processing | ||||||
| >> Make a purchase and import the order into the accounting system. - Part 1 | 7.5 Min. | 0.1 Hrs. | ||||
| >> Continued from above. - Part 2 | 8.5 Min. | 0.1 Hrs. | ||||
| >> Continued from above. - Part 3 | 3.5 Min. | 0.1 Hrs. | ||||
| >> Export Invoice and PO information to invoice tracking file. | 6.0 Min. | 0.1 Hrs. | ||||
| >> Update invoice tracking file - upload to the server - send customers emails. | 7.0 Min. | 0.1 Hrs. | ||||
| >> Continued from above. - Part 2 | 7.5 Min. | 0.1 Hrs. | ||||
| >> After shipping has occurred, finish order processing by closing out purchase order in QuickBooks and email customer. | 17.5 Min. | 0.3 Hrs. | ||||
| >> Receive customer payments using Intuit QuickBooks | 6.0 Min. | 0.1 Hrs. | ||||
| >> Pay suppliers / vendors at the end of the month using Intuit QuickBooks | 0.0 Min. | 0.0 Hrs. | ||||
| >> How To Create Memorized Reports In Intuit QuickBooks | 3.0 Min. | 0.1 Hrs. | ||||
| >> How To Modify Invoice, Purchase Order, and Other Email Forms in Intuit QuickBooks | 2.0 Min. | 0.0 Hrs. | ||||
| >> How to create the QuickBooks output forms that output the data to the interim Excel file | 2.5 Min. | 0.0 Hrs. | ||||
| >> How to create the interim Excel file between Intuit QuickBooks and the Invoice Tracking Excel File | 0.0 Min. | 0.0 Hrs. | ||||
| Total Videos This Section | 13 | 71.0 Min. | 1.2 Hrs. | |||
| Go To Tutorial 5 Section 3 >> Data Exchange and Manipulation | ||||||
| >> Update your web site database using the input from your suppliers database. - Part 1 | 24.5 Min. | 0.4 Hrs. | ||||
| >> Continued from above. - Part 2 | 14.0 Min. | 0.2 Hrs. | ||||
| >> Continued from above. - Part 3 | 30.0 Min. | 0.5 Hrs. | ||||
| >> Real life example - Using Microsoft Office Excel to correct a suppliers database. | 11.5 Min. | 0.2 Hrs. | ||||
| >> Make a purchase and import the order into the accounting system. - Part 1 | 7.5 Min. | 0.1 Hrs. | ||||
| >> Continued from above. - Part 2 | 8.5 Min. | 0.1 Hrs. | ||||
| >> Continued from above. - Part 3 | 3.5 Min. | 0.1 Hrs. | ||||
| >> Export Invoice and PO information to invoice tracking file. - Part 1 | 6.0 Min. | 0.1 Hrs. | ||||
| Total Videos This Section | 8 | 80.0 Min. | 1.3 Hrs. | |||
| Video Totals This Tutorial | 23 | 163.0 Min. | 2.7 Hrs. | |||
| Tutorial 6 | ||||||
| Video Totals This Tutorial | 1 | 9.5 Min. | 0.2 Hrs. | |||
| >> Roadmap Reference 6 | 0.0 Min. | 0.0 Hrs. | ||||
| Total Videos This Section | 1 | 0.0 Min. | 0.0 Hrs. | |||
| Video Totals This Tutorial | 1 | 9.5 Min. | 0.2 Hrs. | |||
| Grand Total - All Tutorials All Videos | 146 | 1,962.2 Min. | 32.7 Hrs. | |||
Written by someone who actually builds and operates e-commerce websites. I have dealt with domain name issues, web hosting issues, shopping carts, merchant services, payment processing, data transfer, e-commerce accounting, and e-commerce legal issues. Therefore, much of the tutorial information stems from an end user or e-commerce owners perspective.
These tutorials are written for those who are interested in...
...becoming involved in the Internet realm with aspirations of developing anything from a personal website to an e-commerce web application and would like a global view of the process. Tutorial 1 is for you. Beginner!
...having a web presence but have no idea where to start, what is involved, or what to expect. Tutorial 1 covers all of the elements without going into too much detail. Tutorials 2 and 6 cover much of the same information as tutorial 1 but in significantly more detail. Novice!
...developing, owning, or operating a type of e-commerce website.
Tutorials 2, 5, and 6 are a must! Novice!
...sorting out all of the different avenues available for e-commerce and
web development and actually seeing some of them in action.
Novice!
...building their own e-commerce website using, Windows Server operating system hosting with FrontPage web creation and management tool extensions, ASP, JavaScript, and HTML will find much to enjoy in tutorial 3. Tutorial 4 explores this same environment with the addition of database development and connectivity utilizing Microsoft Office Excel, Microsoft Office Access, and Microsoft SQL Server that is offered by various hosts. Expert!
The knowledge you will gain from these tutorials will significantly contribute to a savings in time, money, and frustration when building and/or operating an e-commerce website. If you are an individual who desires to get involved with anything from a simple web presence to an e-commerce website, these tutorials offer an outstanding starting point, a global perspective of the entire subject, and pertinent details that will help you along the way.
The tutorials are broken down into subject categories so you can purchase 6 months of access to only the tutorial you need. Access to All tutorials, for a 6 month period of time, can be purchased by selecting one of the "Buy" button in the upper or lower portion of the left hand sidebar. Upon completing your purchase, you will automatically be emailed a link that when pasted into a web browser will allow you 6 months of access to the tutorial(s) you purchased. Preferred client access has no time constraint. To obtain preferred client access, select the Preferred Client Logon topic at the bottom of this page.
Tutorial 1 is for anyone who wants a global understanding of developing any web presence up to and including an e-commerce web business. It touches on the topics contained in tutorials 2 through 6.
Tutorial 2 is an in-depth look at all of the elements required to have anything from a simple web presence to developing and running an e-commerce web business. I cover subjects including but not limited to domains, website, hosting, shopping carts, and payment processing and how they relate to one another.
In tutorial 3, I globally discuss server types, coding languages, and a myriad of related topics. I build a basic static example e-commerce website using tables, HTML, ASP (Active Server Pages), Microsoft FrontPage web authoring software, and Windows hosting. I show you how to connect a 3rd party shopping cart to the website.
Tutorial 4 looks at the dynamic side of web page programming. I further develop the example website from tutorial 3 and convert it into a web application with dynamically driven components utilizing ASP (Active Server Pages) and Microsoft FrontPage coupled with Microsoft Office Excel, Microsoft Office Access, or Microsoft SQL Server data sources to accomplish this task. Why ASP? Cost and simplicity! It's all explained in tutorial 4 where I also discuss the use of PHP with MySQL and the latest web creation and management tools like Microsoft Expression Web (ASP.NET), and Adobe Dreamweaver. Over time, I intend to add sections that demonstrate the use of these advanced web creation and management tools to accomplish the same result. Unfortunately, as you will see, the programming languages and methods that accompany these advanced tools are much more complex to learn and use than ASP and largely the reason I do not currently provide examples using these methods.
In tutorial 5, I connect the example dynamic website created in
tutorial 4 to an invoice tracking systems I build using
Microsoft Office Excel. I also show you how to utilize and implement a
real accounting system. I then place "dummy" orders from the example web
application and go through the steps to process them to completion. This
system is paperless, eliminates the need to rekey data, and is relatively easy
to build and customize. Yes, you will have to learn some things about
Microsoft Office Excel, but it fulfills the cost and simplicity
requirement as opposed to other methods of achieving the same result. You
will learn how to manipulate data using
Microsoft Office Excel to make the maintenance of several thousand
products a manageable task.
I take you inside the back door of an operating e-commerce website
(appropriately modified to protect client privacy) built from the same elements
previously mentioned. This will let you have a first hand look at a real
operation along with providing you with the necessary elements to mimic the
business model being demonstrated, if you choose to do so.
I provide insight into key backend elements you are going to need to be versed
in to be able to conduct a successful e-commerce business such as what to expect
from suppliers and how to work with them, how to choose products and present
them, and how to keep everything up to date using various forms of data
exchange.
Tutorial 6 covers advertising, search engines, business integration, and legal issues as applied to e-commerce websites. The importance of these elements can not be overlooked as they are vitally important to an e-commerce success no matter which programming language your website is built with or what type of database you use. I show you where to obtain various forms of advertisement, some that cost you money, some that make you money, and some that are free. Last but not least, there are legal issues you need to be aware of so you do not accidentally infringe on the rights of others. I show you how to keep up to speed with this evolving industry so you will not find yourself in trouble.
I use several aids to help you develop a working and complete understanding of the various subjects. Below you can select from multiple windows that demonstrate some of the learning aids I use such as screen shots, video, and example website.
Part Of Tutorial 1 |
Training Website
Example Video
OR
|
Video List - All Tutorials
|
Example Graphics
TotalWebInfo.com provides material for informational purposes only. Although great effort and care has been taken to provide accurate and current information, TotalWebInfo.com does not warrant the accuracy or correctness of the contents of these tutorials. The user assumes any and all risk from using TotalWebInfo.com. While using this website, you agree that you have read and accepted the below stated Terms Of Use.
Contact Us
For any questions, comments, or concerns regarding this website
please fell free to contact us via email at:
Click Here To E-Mail Us
What are you purchasing?
When you select one of the shopping cart buttons in the left hand side bar you will be taken to a secure shopping cart where you will be able to purchase 6 months of unlimited access to the TotalWebInfo.com tutorials you selected. Upon successfully completing the check out and payment process you will be emailed a URL link that, via your web browser, will provide you with access to the tutorials you selected for duration of 6 months from the date of your order. All 6 tutorials may be accessed by selecting the button at the top or bottom of the left hand side bar. Your access to all of the tutorials will automatically terminate at the end of the 6 month period.
If you only purchase one tutorial, you will be given the opportunity to purchase the remainder of the tutorials at a lower cost. This will be displayed in the left hand side bar when you log into the tutorial you subscribed to.
| Payment Processing |
Refund Policy
TotalWebInfo.com wants you to be completely satisfied with your subscription so please feel free to contact us, before subscribing, if you have any questions, reservations, or concerns.
SUBSCRIPTION FEES ARE NOT REFUNDABLE! After you subscribe, we are not able to regulate or prevent your usage during the 6 month period of your subscription. All sales are final.
Privacy Statement
For your protection and ours:
We do not collect any personal information from our users except that which is necessary to process your order.
IP addresses are NOT logged for statistical purposes.
After processing your order, we share information about you with NO ONE.
All sensitive information regarding your purchase is held on a secure 3rd party server for 60 days. Thereafter, there is absolutely no reason for us to retain your information any longer so it is deleted.
We do not use cookies as a tracking device. There is one exception. If you are a preferred customer and use the preferred client logon, a cookie is used during your session to identify you as a preferred client.
Copyright Information
All pages and graphics in this website are the property of TotalWebInfo.com.
Pages, code, or other content from TotalWebInfo.com may not be redistributed or reproduced without the written permission of TotalWebInfo.com.
Adobe, ActionScript, ColdFusion, Dreamweaver, Fireworks, Flash, Photoshop, and Shockwave are known to be registered trademarks of Adobe Systems Incorporated in the United States and/or other countries. ActiveX, Microsoft, Office Access, Office Excel, Office Outlook, Office Visio, FrontPage, SQL Server, Expression Web and Windows are know to be registered trademarks of Microsoft Corporation in the United States and/or other countries. Apple and Mac OS are known to be registered trademarks of Apple Inc. in the United States and/or other countries. Java and Solaris are known to be registered trademarks of Sun Microsystems, Inc. in the United States and/or other countries. Linux is known to be the registered trademark of Linus Torvalds in the U.S. and/or other countries. UNIX is known to be a registered trademark in the United States and/or other countries, licensed exclusively through X/Open Company, Ltd. QuickBooks is know to be a registered trademark of the Intuit Corporation in the United States and/or other countries. Peachtree is know to be a registered trademark of the Sage Corporation in the United States and/or other countries.
TotalWebInfo is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by the Microsoft, Adobe, Apple, Sun Microsystems, Intuit, or Sage Corporations.
Linking
TotalWebInfo.com provides links to other websites. With the exception of Go Daddy, Securenetshop, Cutting Edge Bank CardServices Inc., and bytemplates.com TotalWebInfo.com has no affiliation with the companies, products, or services referred to or linked to from within these tutorials except that TotalWebInfo.com may have used or may be using one or more of any referenced companies, products, or services. All links to other websites and key words or text that are used to reference these links are listed in the Reference section at the bottom of each page. Generally, when a link is opened in a new separate window, the link is taking the user to another website not affiliated with TotalWebInfo.com.
Warranties
TotalWebInfo.com is provided without warranty of any kind. There are no guarantees that use of the site will not be subject to interruptions. All direct or indirect risk related to use of the site is borne entirely by the user. All code provided by TotalWebInfo.com is provided as examples without warranties to performance, fitness, merchantability, and/or any other warranty, whether expressed or implied.
TotalWebInfo.com, or sites TotalWebInfo.com links to, may contain inaccuracies or errors. TotalWebInfo.com makes no guarantees regarding the accuracy of the website(s) or their contents. If an error is discovered within TotalWebInfo.com, please contact us and it will be corrected as soon as practical.
Microsoft, Windows Server, FrontPage, Microsoft Office Excel, and Microsoft Office Access are trademarks of the Microsoft group of companies in the United States and other countries. Flash is a trademark of Adobe Systems Incorporated. TotalWebInfo is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by the Microsoft or Adobe Corporations.
|
|
THIS IS A LINK - In these Tutorials, text that is Navy Bold and turns to Bright
Blue when moused over denotes a link!