|
|
tblCourses
| Field Name |
Data Type |
Length |
| fldCourseID |
AutoNumber |
Long Integer |
| fldNumber |
Text |
50 |
| fldName |
Text |
100 |
| fldDescURL |
Text |
100 |
| fldWebPageURL |
Text |
100 |
tblCoursesTaught
| Field Name |
Data Type |
Length |
| fldCourseID |
Number |
Long Integer |
| fldFacID |
Number |
Long Integer |
tblFaculty
| Field Name |
Data Type |
Length |
| fldFacID |
AutoNumber |
Long Integer |
| fldUserID |
Number |
Long Integer |
| fldName |
Text |
255 |
| fldPictureURL |
Text |
255 |
| fldPosition |
Text |
255 |
| fldOffice |
Text |
255 |
| fldPhone |
Text |
50 |
| fldFax |
Text |
50 |
| fldEmail |
Text |
50 |
| fldVitae |
Text |
255 |
| fldResearchInterest |
Memo |
|
| fldBS |
Text |
255 |
| fldMS |
Text |
255 |
| fldPhD |
Text |
255 |
| fldHonors |
Memo |
|
| fldServices |
Memo |
|
| fldTimeStamp |
Date/Time |
Long Date |
tblMiscCategory
| Field Name |
Data Type |
Length |
| fldMiscCatID |
AutoNumber |
Long Integer |
| fldFacID |
Number |
Long Integer |
| fldMiscTitle |
Text |
255 |
tblMiscData
| Field Name |
Data Type |
Length |
| fldMiscDataID |
AutoNumber |
Long Integer |
| fldMiscCatID |
Number |
Long Integer |
| fldInformation |
Memo |
|
| fldLocation |
Text |
255 |
tblUser
| Field Name |
Data Type |
Length |
| ffldUserID |
AutoNumber |
Long Integer |
| fldLogonName |
Text |
50 |
| fldAdmin |
Text |
50 |
| fldActive |
Text |
50 |
| fldLastLogin |
Date/Time |
Medium Date |
|