Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access 2002 training - Access

microsoft access 2002 training - Access

ResolvedVersion Standard

Mon 5 Nov 2007, 16:45 Delegate James said...

James has attended:
Access Introduction course

Access

How do you make relationships between queries.

Tue 6 Nov 2007, 10:13 Trainer Richard said...

RE: Access

Do you want to create a relationship between tables or queries. Both are possible.

The simple answer is to drag one of the fields from the one field list in a query to the one you want to link to.

You can do this in the RELATIONSHIPS window, which you can find under TOOLS > RELATIONSHIPS.

You can also do it in the top window when you are designing a query.

Does that answer your question?

Regards

Richard

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

microsoft access 2002 training - Access

Access

RE: Access

Access articles

Access tip:

Choosing data types in Access