Hi Mark,
It's a matter of your judgement based on how the entry of data is being carried out.
If you are importing the data then you don't need to change anything.
If the data are being entered manually then you would benefit from having ComboBoxes for Fields that have many instances of the same value.
The obvious Fields are CityTown, StreetType, SoilType and ZoningDesignation.
Each ComboBox would have an underlying Table containing the possible values, and use the NotInList Event of the ComboBox to allow or not the addition of new entries.
The Field SpecialFeatures is an oddball. It could have mutiple values like "Pool Jaccuzi Sauna Disabled Berth" in which case you would need to have a OneToMany link to SpecialFeatures Table that would the formal way of Normalizing the database.
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "Mark" <mmirrlees@...> wrote:
>
> Also I forgot to add that what I want to do is make sure "roll number" is visible in all 3 tables when I use the table analyzer.
>
> Any suggestions?
>
> Thanks,
> Mark
>
> As what I want to do is make sure "roll number" is visible in all 3 tables when i use the
>
> --- In MS_Access_Professionals@yahoogroups.com, "Mark" <mmirrlees@> wrote:
> >
> > Hi thanks for your help as it seemed to do the trick. Now I do have a follow up question...how can I "normalize it" the data into 3 tables. As when I use the analyze table option it seems to make several tables...the primary key should be rollnumber.
> >
> > Mark
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@> wrote:
> > >
> > > Hi Mark
> > >
> > > First, I apologise for all the BBCode tags that were sprinkled through my
> > > first answer. I had not yet had my second coffee for the morning and I
> > > thought I was posting to a different forum :-/
> > >
> > > More importantly, it appears that your file is NOT fixed width, but is
> > > actually variable width with "%" as a delimiter.
> > >
> > > In the import wizard, select "Delimited" and click Next. Then select
> > > "Other" as the delimiter and type % in the adjacent box. Also, select the
> > > "First row contains field names" option, then click Next.
> > >
> > > You will then need to change the data types of some of the fields.
> > > RollNumber should be changed to Text (because the 19-digit numbers are too
> > > long for a numeric data type). You may also want to change StreetNumber
> > > (Integer or Text?), and AssessedValue (Currency?).
> > >
> > > Then all the records should import without errors.
> > >
> > > Best wishes,
> > > Graham
> > >
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Mark
> > > > Sent: Tuesday, 15 May 2012 08:44
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: Re: [MS_AccessPros] Importing text file into Access 2007 problems
> > > >
> > > >
> > > > Hi there,
> > > >
> > > > Also I put a file in the files section called "Text file of import
> > > problem" under the 2_AssistanceNeeded folder to show what i'm talking about.
> > > >
> > > > Thanks again,
> > > > Mark
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno"
> > > <graham@> wrote:
> > > > >
> > > > > Hello Mark
> > > > >
> > > > > You say you: "[i]...selected 'fixed width format' since that's what
> > > Access
> > > > > believes it is[/i]
> > > > >
> > > > > [b]Is it [i]actually[/i] fixed width format?[/b] You should be the one
> > > to
> > > > > make that call, not Access.
> > > > >
> > > > > It seems strange that the message pops up before you have even defined
> > > the
> > > > > number or lengths of the fields. It almost sounds as if the
> > > [i]record[/i],
> > > > > not the [i]field[/i] is too long.
> > > > >
> > > > > [b]Are you sure there are actually line breaks between the records?[/b]
> > > > > (Open the textfile in Notepad and make sure each record starts on a new
> > > > > line)
> > > > >
> > > > > Finally, [b]can you identify anything that is different between this
> > > import
> > > > > and the others you have done successfully?[/b]
> > > > >
> > > > > Best wishes,
> > > > > Graham
> > >
> >
>
Tidak ada komentar:
Posting Komentar