Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access training - relationships between tables

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Relationships between tables?

microsoft access training - Relationships between tables?

ResolvedVersion Standard

Gemma has attended:
Access Introduction course
Access Intermediate course

Relationships between tables?

If I want to link two tables do they need to have a unique key that they share or would a matching address field i.e. postcode be enough?

I have a database that my company uses. It records the contact details of our customers. We also purchase a list of UK Businesses. I would like to add information from that list to our database. However due to us using a different type of recording ID's to the purchased list, the only thing they may share is address details such as postcode.

Can the postcode be the relationship?

Thanks

RE: Relationships between tables?

Hi Gemma

Thank you for your question.

I would say that you couldn't use the postcode as the primary key as there is a small chance that you could have more than one business that has the same postcode. The primary key definitely has to be unique for each business.

Amanda

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.