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

advanced microsoft access in london - creating relationships between t

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced microsoft access in london - Creating Relationships between tables

advanced microsoft access in london - Creating Relationships between tables

ResolvedVersion Standard

Emma has attended:
Access Introduction course

Creating Relationships between tables

How do you build a relationship between tables?

RE: Creating Relationships between tables

Hi Emma

Many different relationship can be formed in Access, via Relationship Window from Tools menu, adding Tables and dragging Primary key to second keys and adjusting join types. However we suggest you attend our Access Intermediate course as the whole first objective helps you to full understand these types of relationships and shows in detail how to initiate and edit relationship to develop fully formed databases.

Thank you for using the forum. Feel free to recommend it to others as well.

Regard

BEST Training

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

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.13 secs.