Course Outline Database Basics Logging on Navigation Submitting

Course Outline • • • Database Basics Logging on Navigation Submitting Transmittals Assigning Usage

Basics • A Database is a mechanism to store and manipulate data.

Basics • Data is stored in TABLES Name Address Phone John Smith 12345 Center Street 555 -1212 Sue Brown Apt 3 G BR-549 Rick Rude 1425 Main 555 -3456

Basics • Data is stored in TABLES • Tables contain individual RECORDS Name Address Phone John Smith 12345 Center Street 555 -1212 Sue Brown Apt 3 G BR-549 Rick Rude 1425 Main 555 -3456

Basics • Data is stored in TABLES • Tables contain individual RECORDS • Records consist of individual FIELDS Name Address Phone John Smith 12345 Center Street 555 -1212 Sue Brown Apt 3 G BR-549 Rick Rude 1425 Main 555 -3456

Basics- Relational Databases Name Address Phone Company ID Type Member John Smith 12345 Center Street 555 -1212 Delta 053 Air Carrier Sue Brown Apt 3 G BR-549 United 120 Air Carrier Rick Rude 1425 Main 555 -3456 Nordam 555 Repair Station

Basics- Relational Databases Name Address Phone Company ID Company Type Member John Smith 12345 Center Street 555 -1212 053 Delta Air Carrier Sue Brown Apt 3 G BR-549 120 United Air Carrier Rick Rude 1425 Main 555 -3456 555 Nordam Repair Station

Basics- Retrieving Data • We can view it and manipulate it using forms; • Or print it using reports • Do not try to print a form!

Getting On

Getting On • Web Based Log in • www. caseinc. org • Click “Member Login”

Getting On

The first log on is called the “NT Log in”

The second log on is called the “Access Log in”

Navigation

Navigation • The Message Box

Navigation • The Message Box • The Main Menu

Navigation Sin

Navigation • The Message Box • The Main Menu • The VCR Buttons

Navigation

Navigation • • The Message Box The Main Menu The VCR Buttons The Find Button

Navigation

Navigation • • • The Message Box The Main Menu The VCR Buttons The Find Button The Magic “Right Click”

Navigation

Submitting Transmittals

Oops! I screwed up and forgot something on my transmittal Now what do I do?

Submitting Usage

Fini • If you would like to see other procedures or have suggestions for improvements, send an email to geneswan@web-ster. com • This is a work in progress so check for revisions