A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Consolidating contacts.



 
 
Thread Tools Display Modes
  #1  
Old May 13th, 2009, 11:33 PM posted to microsoft.public.access.tablesdbdesign
EdEarnshaw
external usenet poster
 
Posts: 2
Default Consolidating contacts.

I'm in the process of designing and creating a database to keep track of
people, much like a contacts database, but a little bit more complex.
Currently I have it planned so that there is a students table and an agent
table. Ultimately I need to keep track of emails from Outlook through a
linked table containing the emails. (So I'm filing emails digitally rather
than printing them off.)

My question is if it is possible to consolidate the agents table with the
students table.
The students table contains a lot more information than the agent table
So I was not sure if it would be practical to combine the two directly and
have many of the fields (those that are agents) end up remaining null.
Any help would be appreciated. Please let me know if any clarification is
needed.

Student table fields are as follows:
StudentID (autonumber)
AgencyBranch
LastName
FirstName
DOB
PermanentAddress
PermanentTelephone
Mobile
FaxNumber
E-Mail
ParentE-mail
CountryOfCitizenship
AlternateAddress
AlternateTelephone
DateCompleteApplicationReceived
ApplicationReceivedFromAgency
ApplicationReceivedFromStudent
Photo
StudentType
Session/SemesterOfInterest
Session/SemesterofInitialEnrollment
IDNumber

The Agents table contains the following fields:
ContactID_AN
ContactType
AgencyBranch
LastName
FirstName
PhoneNumber
FaxNumber
MobileNumber
E-mail
Photo
  #2  
Old May 14th, 2009, 12:26 AM posted to microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default Consolidating contacts.

On May 13, 5:33*pm, EdEarnshaw
wrote:
I'm in the process of designing and creating a database to keep track of
people, much like a contacts database, but a little bit more complex.
Currently I have it planned so that there is a students table and an agent
table. Ultimately I need to keep track of emails from Outlook through a
linked table containing *the emails. (So I'm filing emails digitally rather
than printing them off.)

My question is if it is possible to consolidate the agents table with the
students table.
The students table contains a lot more information than the agent table
So I was not sure if it would be practical to combine the two directly and
have many of the fields (those that are agents) end up remaining null.
Any help would be appreciated. Please let me know if any clarification is
needed.

Student table fields are as follows:
StudentID (autonumber)
AgencyBranch
LastName
FirstName
DOB
PermanentAddress
PermanentTelephone
Mobile
FaxNumber
E-Mail
ParentE-mail
CountryOfCitizenship
AlternateAddress
AlternateTelephone
DateCompleteApplicationReceived
ApplicationReceivedFromAgency
ApplicationReceivedFromStudent
Photo
StudentType
Session/SemesterOfInterest
Session/SemesterofInitialEnrollment
IDNumber

The Agents table contains the following fields:
ContactID_AN
ContactType
AgencyBranch
LastName
FirstName
PhoneNumber
FaxNumber
MobileNumber
E-mail
Photo


Before I would consider merging them, I'd have to ask a few
questions...
Do the Agent and Student participate in the same relationships? If
they do, then it makes sense to put them in the same table. If they
don't share more than a few attributes, then I wouldn't.
  #3  
Old May 14th, 2009, 12:38 AM posted to microsoft.public.access.tablesdbdesign
EdEarnshaw
external usenet poster
 
Posts: 2
Default Consolidating contacts.

This helps actually. Thank you.

"Piet Linden" wrote:

On May 13, 5:33 pm, EdEarnshaw
wrote:
I'm in the process of designing and creating a database to keep track of
people, much like a contacts database, but a little bit more complex.
Currently I have it planned so that there is a students table and an agent
table. Ultimately I need to keep track of emails from Outlook through a
linked table containing the emails. (So I'm filing emails digitally rather
than printing them off.)

My question is if it is possible to consolidate the agents table with the
students table.
The students table contains a lot more information than the agent table
So I was not sure if it would be practical to combine the two directly and
have many of the fields (those that are agents) end up remaining null.
Any help would be appreciated. Please let me know if any clarification is
needed.

Student table fields are as follows:
StudentID (autonumber)
AgencyBranch
LastName
FirstName
DOB
PermanentAddress
PermanentTelephone
Mobile
FaxNumber
E-Mail
ParentE-mail
CountryOfCitizenship
AlternateAddress
AlternateTelephone
DateCompleteApplicationReceived
ApplicationReceivedFromAgency
ApplicationReceivedFromStudent
Photo
StudentType
Session/SemesterOfInterest
Session/SemesterofInitialEnrollment
IDNumber

The Agents table contains the following fields:
ContactID_AN
ContactType
AgencyBranch
LastName
FirstName
PhoneNumber
FaxNumber
MobileNumber
E-mail
Photo


Before I would consider merging them, I'd have to ask a few
questions...
Do the Agent and Student participate in the same relationships? If
they do, then it makes sense to put them in the same table. If they
don't share more than a few attributes, then I wouldn't.

  #4  
Old May 14th, 2009, 07:20 PM posted to microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default Consolidating contacts.

On May 13, 6:38*pm, EdEarnshaw
wrote:
This helps actually. Thank you.



"Piet Linden" wrote:
On May 13, 5:33 pm, EdEarnshaw
wrote:
I'm in the process of designing and creating a database to keep track of
people, much like a contacts database, but a little bit more complex.
Currently I have it planned so that there is a students table and an agent
table. Ultimately I need to keep track of emails from Outlook through a
linked table containing *the emails. (So I'm filing emails digitally rather
than printing them off.)


My question is if it is possible to consolidate the agents table with the
students table.
The students table contains a lot more information than the agent table
So I was not sure if it would be practical to combine the two directly and
have many of the fields (those that are agents) end up remaining null..
Any help would be appreciated. Please let me know if any clarification is
needed.


Student table fields are as follows:
StudentID (autonumber)
AgencyBranch
LastName
FirstName
DOB
PermanentAddress
PermanentTelephone
Mobile
FaxNumber
E-Mail
ParentE-mail
CountryOfCitizenship
AlternateAddress
AlternateTelephone
DateCompleteApplicationReceived
ApplicationReceivedFromAgency
ApplicationReceivedFromStudent
Photo
StudentType
Session/SemesterOfInterest
Session/SemesterofInitialEnrollment
IDNumber


The Agents table contains the following fields:
ContactID_AN
ContactType
AgencyBranch
LastName
FirstName
PhoneNumber
FaxNumber
MobileNumber
E-mail
Photo


Before I would consider merging them, I'd have to ask a few
questions...
Do the Agent and Student participate in the same relationships? *If
they do, then it makes sense to put them in the same table. *If they
don't share more than a few attributes, then I wouldn't.- Hide quoted text -


- Show quoted text -


Ed, just an FYI... Rebecca Riordan has an article on Access Web on
subclassing... if you ever get there. It's helpful if you have IS-A
hierarchies...
For example, if you have a superclass, like "Vehicle", and then
subclasses, e.g., "car", "truck", "motorcycle" and you need to keep
track of a lot of the same attributes and then some special or custom
attributes for the subclass.
http://www.mvps.org/access/tables/tbl0013.htm
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.