Download as:
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Language:EN
Pages: 3
Words: 698

Tablescompanies stores the details the company stores the information contacts stores all the various phone numbers and email addresses that might connected contact stores all status codes and corresponding descriptions holds information all your interactions with your contacts

Field name Description Note
CompanyTypeCode A single character unique identifier for the company Type. Text, field size is 1
CompanyTypeDesc The description of the Type. Text, field size is 25

ContactTypes

Field name Description Note
ContactTypeCode A single character unique identifier for each Type. Text, field size is 1
ContactTypeDesc The description of the Type. Text, field size is 25

ContactComms (Stores all the various phone numbers and email addresses that might be connected to a contact.)

Field name Description Note
CommTypeCode A single character code to uniquely identify the different Types. Text, field size is 1
CommTypeDesc The Type of number e.g. day telephone, evening telephone, email. Text, field size is 25
Field name Description Note
HistID An internal unique auto-ID to label each entry. AutoNumber
HistDate The date of the communication (defaults to today). Date/Time, Short Date, Default Value: should be set to the current system date.
ContactRef The contact the communication was with. Text, field size is 8
HistTypeCode The Type of History. Text, field size is 1
StaffInitials A code to identify the member of staff involved, called from the Staff table below. Text, field size is 8
HistDetails All relevant information resulting from the communication. Text, field size is 255
FollowUpDate The date by which any follow up action should occur, if applicable. Date/Time, Short Date
DateActioned The date the follow up was completed. Date/Time, Short Date, Validation Rule: should check if the date is not after the current system date.

Staff

Field name Description Note
StaffInitials The unique initials (and optional digit) to identify staff member. Text, field size is 8
StaffName The name of the staff member. Text, field size is 30
Current? Does the staff member still work here? Yes/No, Default Value is -1
Copyright © 2009-2023 UrgentHomework.com, All right reserved.