| Video Reference Guide
|
| Grand Total - All Tutorials All Videos
|
121
|
1,383.2 Min.
|
23.1 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.
|
| >> Email
|
|
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 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.
|
| >> Email
|
|
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.
|
|
1,000.0 Min.
|
16.7 Hrs.
|
| >> JavaScript open page in new window code.
|
|
1,000.0 Min.
|
16.7 Hrs.
|
| >> JavaScript and web browsers open page in new window demonstration.
|
|
1,000.0 Min.
|
16.7 Hrs.
|
| >> JavaScript open page in new window diagram.
|
|
1,000.0 Min.
|
16.7 Hrs.
|
| >> 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 |
63
|
788.7 Min.
|
13.1 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 >>
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 4 >>
Microsoft Office Access
|
| >> Brief Introduction To Microsoft Office Access
|
|
12.0 Min.
|
0.2 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.
|
| Total Videos This Section
|
3
|
29.0 Min.
|
0.5 Hrs.
|
|
Go To Tutorial 4 Section 5 >>
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 6 >>
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.
|
| Total Videos This Section
|
2
|
19.2 Min.
|
0.3 Hrs.
|
|
Go To Tutorial 4 Section 7 >>
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.
|
| Total Videos This Section
|
11
|
172.0 Min.
|
2.9 Hrs.
|
|
Go To Tutorial 4 Section 8 >>
Data Connections Explained
|
| >> Introduction to Database Connections.
|
|
24.0 Min.
|
0.4 Hrs.
|
| Total Videos This Section
|
1
|
24.0 Min.
|
0.4 Hrs.
|
|
Go To Tutorial 4 Section 9 >>
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.5 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 dispaly the data both locally and from your hosted 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 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.
|
| >> 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
|
11
|
144.0 Min.
|
2.4 Hrs.
|
|
Go To Tutorial 4 Section 10 >>
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 11 >>
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 12 >>
SQL Queries
|
| >> Using Microsoft FrontPage to create SQL queries with query variables.
|
|
49.5 Min.
|
0.8 Hrs.
|
| >> Using VBScript to create SQL queries with query variables.
|
|
43.5 Min.
|
0.7 Hrs.
|
| Total Videos This Section
|
5
|
93.0 Min.
|
1.6 Hrs.
|
|
Go To Tutorial 4 Section 13 >>
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
|
|
5.0 Min.
|
0.1 Hrs.
|
| >> Continuation from above. - Part 3
|
|
7.5 Min.
|
0.1 Hrs.
|
| >> Continuation from above. - Part 4
|
|
6.0 Min.
|
0.1 Hrs.
|
| >> Continuation from above. - Part 5
|
|
5.5 Min.
|
0.1 Hrs.
|
| >> Continuation from above. - Part 6
|
|
6.5 Min.
|
0.1 Hrs.
|
| >> Continuation from above. - Part 7
|
|
6.0 Min.
|
0.1 Hrs.
|
| >> How to build the Dinky Dog Accessories web site using ASP and and NO data management software. - Part 1
|
|
6.0 Min.
|
0.1 Hrs.
|
| >> Continuation from above. - Part 2
|
|
6.0 Min.
|
0.1 Hrs.
|
| >> How to build the Dinky Dog Accessories web site using PHP and Adobe Dreamweaver CS4. - Part 1
|
|
6.5 Min.
|
0.1 Hrs.
|
| >> Continuation from above. - Part 2
|
|
5.5 Min.
|
0.1 Hrs.
|
| >> Continuation from above. - Part 3
|
|
6.0 Min.
|
0.1 Hrs.
|
| >> How to build the Dinky Dog Accessories web site using ASP.NET and Microsoft Expression Web 2. * - Part 1
|
|
7.0 Min.
|
0.1 Hrs.
|
| Total Videos This Section
|
19
|
130.5 Min.
|
2.2 Hrs.
|
| Video Totals This Tutorial |
63
|
788.7 Min.
|
13.1 Hrs.
|
|
Tutorial 5
|
| Video Totals This Tutorial |
22
|
166.0 Min.
|
2.8 Hrs.
|
| >> Roadmap Reference 5
|
|
0.0 Min.
|
0.0 Hrs.
|
| Total Videos This Section
|
1
|
0.0 Min.
|
0.0 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.0 Min.
|
0.1 Hrs.
|
| >> Export Invoice and PO information to invoice tracking file.
|
|
5.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.
|
|
16.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 interim Excel file between Intuit QuickBooks and the Invoice Tracking Excel File
|
|
0.0 Min.
|
0.0 Hrs.
|
| Total Videos This Section
|
11
|
62.5 Min.
|
1.0 Hrs.
|
|
Go To Tutorial 5 Section 3 >>
Data Exchange and Manipulation
|
| >> 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.0 Min.
|
0.1 Hrs.
|
| >> Continued from above. - Part 3
|
|
3.0 Min.
|
0.1 Hrs.
|
| >> Export Invoice and PO information to invoice tracking file. - Part 1
|
|
5.0 Min.
|
0.1 Hrs.
|
| >> Continued from above. - Part 2*
|
|
0.0 Min.
|
0.0 Hrs.
|
| >> 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.
|
| Total Videos This Section
|
9
|
103.5 Min.
|
1.7 Hrs.
|
| Video Totals This Tutorial |
22
|
166.0 Min.
|
2.8 Hrs.
|
|
Tutorial 6
|
| Video Totals This Tutorial |
1
|
8.0 Min.
|
0.1 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
|
8.0 Min.
|
0.1 Hrs.
|
|
|
| Grand Total - All Tutorials All Videos
|
121
|
1,383.2 Min.
|
23.1 Hrs.
|