JML INSTITUTE ONLINE: BSC
Business School Center
Instructor: Professor Steven Lopin
________________________________________

Form wizards 
Usually every database program has a form wizard that will make a form for you. The wizard ask you how many input boxes  and labels to you form.  This form will inititally be empty until it connects to the table.   Then it ask you what do you want the field names to be.  

(ACCESS) Once the wizard has created your database and table, it offers you a choice to....
"Enter the data into the table using the form the wizard has created for me."
...the click finish and exit the form after it is displayed.  

Then you are ready to begin typing in record into the table by typing one record at a time into your form.
	
Forms:

Forms are used on computers to display data records one at a time.  The database can be on a network, an internet server or an intranet server.  The user must first create a form and save it.  Next he/she must connect to the server 
thru a provider (an interface to have access to data).   

DSNs:
Data sources like Access, Foxpro, Dbase, are used to create databases with DSNs (names) you give them, like the 
Acme Bank database or the Spelman Furniture Store database etc.  

EXTRA CREDIT:

Providers:

In 2005 A.D.  the most common providers are OLE-DB, ADO,  and ODBC neither of which are mutually exclusive or totally separate, but, upgrades and combinations of eachother.  ODBC is the oldest.  OLE-DB is the basis of ADO.  
ODBC uses SQL for data transfer and OLE-DB uses .COM interfaces.   

Types of forms:

Database forms: 	Used with their associated databases

Html(JavaScript) forms:  Used for various uses, like submitting user data to a web server site, often to a CGI-bin which is then processed by a PERL service routine or just stored to be viewed later by the site manager.

Visual Basics forms:  Used for various uses, including linking to DSNs and user interfaces for software.

Visual C++ forms:  Used for various uses, including linking to DSNs and user interfaces for software.

Indexes:
Used by the DBMS as "Keeper of data record order".  The index uses 1 field of the records and a pointer to the entire record in a table.  Sorting is done to the table index not the table, so you can have many sorts of table without the actual table being touched.  Indexes may span several tables. 

Primary keys:
The main index which may be a multiple field index.

Index Sequential ISAM:
Used by......LATER

Index DIRECT IDAM:
Used by......LATER

Trees:
Used by.....LATER