Adding a Table

[GaleT]

I am new to Access and in the process of creating a database to replace one written in Lotus Notes. I have a single table that contains all of the data from the other database. I also have a functioning form to Edit and Add records.

Now I want to move the Building Address out of the first table into a new table... because it repeats. Each Building Address has an associated 8 Character Building Code i.e. S1876C89 912 N 12th St Phoenix AZ.

I want to add a second table to contain the Building Addresses by Building Code.

It seems logical to add the new table, remove the Building Address column from the first table and then update the form.

Is this a good approach or am I missing something?

Gale

 

[theDBguy]

Hi Gale. Yes, it's considered best practice to reduce redundant data as much as possible. There is a process for it called "Database Normalization."

 

[GaleT]

Thank you, I have seen that term used here and wondered what it meant... now I know. So I am doing a good thing, I just didn't know how to refer to it.

Gale

 

[theDBguy]

You are doing a very good thing. Let us know if you get stuck.

 

[GaleT]

Thank you Pat, I appreciate the information. In this case the addresses are only used in a contract narrative so no advantage to breaking them up. But I can see this would be good to apply to the customer addresses.

Gale