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
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
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
- Slides: 50