BlueJacket
Registered User.
- Local time
- Today, 15:14
- Joined
- Jan 11, 2017
- Messages
- 92
Trying to figure out how to break up a table I've imported from Excel. The table has 32 fields and 85%-90% of the fields are filled in with data. Here is the table broken down by field:
tblPropertyDetails
PropertyID
Client
Tag
DateAquired
County
ParcelID
ParcelLink
PreviousOwner
PhotoLink *
StreetNumber
StreetName
ParcelMap
City
ZipCode
GoogleMapLink
Zoning (residential, commercial, agriculture, etc)
ResidentialUse (single fam, multi-fam, condo, townhouse, etc)
ImprovedUnimproved
Acreage
LandValue
ImprovedValue
AccessoryValue *
TaxAssessorFMV
ZillowLink *
TruliaLink *
Bed
Bath
SquareFeet
YearBuilt
LastSaleDate
LastSaleAmt
Notes *
* Means there are a good amount of blank records.
Save for those fields marked by an "*", pretty much all of that data is filled in. My thought process is this: I can leave the table as it is for the most part and just create "tblNotes," "tblAccessoryValue," "tblZillowLink", etc. Pretty much just separating out the fields that have a lot of blank records and link them through the "PropertyID" PK, though this would still leave me with roughly 28 fields left in the table (how many fields is too many?).
OR
Still have a main "Property" table listing all the properties with just the basic information, then create multiple other tables to fill in all the other information. Like "tblLinks," "tblTaxAssessorValue," "tblImprovedInfo," "tblLandInfo," etc. However, while this will create many different tables with much fewer fields, there will be slightly more blank records.
OR
I can normalize the crap out of it and create a ton of 2-3 field tables to link back to the main "Property" table so that there are hardly any blank records anywhere. This is what I'm leaning towards, but it will create more work each time we import a new bulk of properties from an Excel file.
Thank you in advance for your help. This forum has been immensely helpful to me and continuously expands what I know about Access (which isn't much).
tblPropertyDetails
PropertyID
Client
Tag
DateAquired
County
ParcelID
ParcelLink
PreviousOwner
PhotoLink *
StreetNumber
StreetName
ParcelMap
City
ZipCode
GoogleMapLink
Zoning (residential, commercial, agriculture, etc)
ResidentialUse (single fam, multi-fam, condo, townhouse, etc)
ImprovedUnimproved
Acreage
LandValue
ImprovedValue
AccessoryValue *
TaxAssessorFMV
ZillowLink *
TruliaLink *
Bed
Bath
SquareFeet
YearBuilt
LastSaleDate
LastSaleAmt
Notes *
* Means there are a good amount of blank records.
Save for those fields marked by an "*", pretty much all of that data is filled in. My thought process is this: I can leave the table as it is for the most part and just create "tblNotes," "tblAccessoryValue," "tblZillowLink", etc. Pretty much just separating out the fields that have a lot of blank records and link them through the "PropertyID" PK, though this would still leave me with roughly 28 fields left in the table (how many fields is too many?).
OR
Still have a main "Property" table listing all the properties with just the basic information, then create multiple other tables to fill in all the other information. Like "tblLinks," "tblTaxAssessorValue," "tblImprovedInfo," "tblLandInfo," etc. However, while this will create many different tables with much fewer fields, there will be slightly more blank records.
OR
I can normalize the crap out of it and create a ton of 2-3 field tables to link back to the main "Property" table so that there are hardly any blank records anywhere. This is what I'm leaning towards, but it will create more work each time we import a new bulk of properties from an Excel file.
Thank you in advance for your help. This forum has been immensely helpful to me and continuously expands what I know about Access (which isn't much).