| Web Access | How to query a database and display the results
via a web page
| ||||||||
| CM Data | There are several types of configuration data that should be
a part of every database
| ||||||||
| Lookup Tables | Most databases contain some fields which should be restricted to a limited set of values (valid state abbreviations). These are some of the trade offs and techniques. | ||||||||
| Object Oriented Design | In an Object Oriented Design, the table structure and the methods that operate on the data (forms and reports) define an object. An object instance, contains just data (tables) - the methods exist only once (in the class definition). | ||||||||
| SQL | This is the language used to access and modify databases. (Only MS Access examples provided) | ||||||||
| Field Types | A simple comparison of various field types - Paradox, MS Access, dBase/Foxpro, SQL, Interbase/Firebird, MySQL | ||||||||
| Referencing Tables | How to reference tables and the fields they contain. | ||||||||
| Picking a Record | How to use a comboBox to select and display records. | ||||||||
| MouseOver Help | How to provide context sensitive help for User Interface objects when the mouse simply points to them. | ||||||||
| Right Click | How to control what happens when you Right Click an object. | ||||||||
| Highlighting Records | How to specify the parameters (such as color) for records meeting some criteria. | ||||||||
| Opening a Form or Report | How to open forms and reports via code. | ||||||||
| Remote Access | How to access tables, forms, reports, and code modules not located in the current database (ie, how to access a library). (This mainly applies to MS Access, for the other environments this is trivial.) | ||||||||
| Graphs | How to plot your data. | ||||||||
| Queries In Code | How to execute a query via your code. | ||||||||
| Report Design | Notes on designing reports | ||||||||
| Database Engines | Notes on BDE, Jet, ODBC, ADO, and DAO. | ||||||||
| Dates and Times | Functions to work with Dates and Times, includes field info. | ||||||||
| Calendars and Dates | How to pop-up a calendar so that you can select a date. | ||||||||
| Using Data in MS Excel | How to link MS Access data to MS Excel. | ||||||||
| Exit | How to quit Subroutines, Forms, and Applications. | ||||||||
| Compacting Tables | Some databases waste extreme amounts of memory. This page discusses the problem and provides examples. | ||||||||
| Form Controls |
| ||||||||
| Null Values | How to test for Null and Empty values | ||||||||
| Debug tips | |||||||||
| Template |
| Paradox | Very powerful database tool. Unfortunately, it requires 2 runtimes - the BDE and Paradox - on each client machine. |
| MS Access 97 | All tables, forms, and reports are stored in a single mdb file. Can NOT use ODBC to access MS Access tables in additional mdb files. Requires MS Access on each client machine. |
| MS Access XP | Warning: Code examples for MS Access 97 won't work with MS Access XP |
| Delphi | This produces executables. Supports ODBC for all accesses. The BDE is required for ODBC accesses but not for ADO connections. |
| Firebird | An open source (free) version of Borland's Interbase SQL database engine. |
| MySQL | An open source (free) SQL database engine - available on Windows, Linux, and many ISP's. |
| VisualBasic | This produces executables which require a 1.2 MB runtime. Supports ODBC for all accesses. |
| ASP | This shows how to use ADO to connect to an MS Access database. |
| ASP.Net | Microsoft's attempt to kill Java. Its actually pretty good ... if you can find enough documentation. |
References / Additional Reading