Welcome
This website has a collection of some of my business/finance articles. Project Management, Office software,Programming Office 2007, VB.Net, and more...
Visit my Home page for the main table of contents
Visit my Home page for the main table of contents
Plan Projects Using GanttProject
Free Project Management Software for Creating Gantt and PERT Charts
Plan Projects Using GanttProject: Free Project Management Software for Creating Gantt and PERT ChartsGanttProject is free user friendly project management software for private or business use. New users may view an online video tutorial to fast-track producing results.
Help with Project Management
Using Macros in MS Office 2007
How to Automate Common or Routine Everyday Tasks
Using Macros in MS Office 2007: How to Automate Common or Routine Everyday TasksMacros are available across the full range of MS Office 2007 products. Described are ease of learning, writing and running macros, and security risks.
Creating MS Access Relationships
Correctly design and link tables with referential integrity
Creating MS Access Relationships: Correctly design and link tables with referential integrity A database design begins with identifying entities from business data. Tables are designed following conventions, and linked. Only then are tables populated with data Programming MS Access Applications
Improve Functionality with Macros and Visual Basic for Applications
Programming MS Access Applications - Improve Functionality with Macros and Visual Basic for Applications An industry application written in Access 2007 is presented for inspection to learn how applications can be made more professional, using macros and VBA programming. Help with Office Software
Data Referential Integrity
- Applying Referential Integrity to a Database: Correct Table Linking at Start is Essential Cost-Effectiveness
- When not properly linked, badly connected tables can cause inefficiency to data retrieval. Eventually the database needs to be fixed by hand, at cost.
In an Access 2007 database, the heavy line between two tables indicates that referential integrity is in place. This is achieved by clicking the appropriate checkbox in the panel that opens up when the link is made. Using a query, one may detect the soundness of such table connections, by checking whether the line is a thin or heavy line. In the case of an unsound link, the data in tables should be "cleaned up", and tables connected with proper referential integrity. The latter prevents data corruption in the database, ensuring no attendant, costly exercise to clean up data. Therefore, it makes sense to implement an initial database that has proper data integrity before any the tables are populated.
HTML Help Workshop
- Microsoft HTML Help Workshop (HHW): User Documentation Support for Desktop Applications
- HHW is a free documentation project for producing an external Help module, which can be called from the main program application or from any MS Office product.
Financial Markets
- Forecasting Major Economic Business Cycles
- Technical analysis of the Dow/Gold chart reveals long-wave business cycles, allowing smart investors to position themselves when to start buying either gold or equities.
- W.D. Gann's Time Constraints on Market Prices: When the Spiral of Prices Meets the Cycle of Time
- The most influential aspect of Gann's work was his observation that time is a major constraint on price movements. When time "runs out" the market is ready for a reversal
by hschlang
Hello, my name is Harry P. Schlanger
From my early days, I've worked as a physicist, an analyst/programmer and a high school teacher. I mostly write n... (more)
From my early days, I've worked as a physicist, an analyst/programmer and a high school teacher. I mostly write n... (more)





