ms+access+courses - Realtionships

The UK's most regular instructor-led training courses.
Training information: ms+access+courses · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

6 posts

ReplyWed 31 Jan 2007, 10:44Delegate Emily said...

Emily has attended:
Access Introduction course

Realtionships

Hi

I've have created 3 tables. One of these is the main table which holds all of the information I need to know for the events i'm organising this year. these include details such as wheere they're being held, whose working, whether it needs catering etc. I have now created 2 other tables, 1 called 'correspondence' and the other 'booked ambassadors'. Both of these tables hold extra information that i would like to view from the main table but are something that is not visible form the outset (otherwise it would be a very big table!) Now I have already created these tables could you please tell me how to link them togther, adn also from my explanation do you think this is the easiest wa to show this infomration?

Thank you for your help.

regards,

Emily

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Tue 3 Aug 2010	Bloomsbury	1		£215	£220	£235
2003	Fri 20 Aug 2010	Bloomsbury	7		£190	£195	£235
2007	Fri 27 Aug 2010	Bloomsbury	9		£180	£185	£235
2010	Thu 16 Sep 2010	Bloomsbury	7		£250	£255	£299
2007	Wed 29 Sep 2010	Bloomsbury	8		£176	£181	£235
2003	Fri 8 Oct 2010	Bloomsbury	10		£142	£157	£235
Full Schedule: See all 35 Access Intermediate course dates. Bookings currently available until 28th September 2011.

835 posts

ReplyWed 31 Jan 2007, 12:13Trainer Richard said...

RE: Realtionships

Hi Emily

Thank you for your question. We cover table reationships in our Access Intermediate course. Also bear in mind that to create effective relationships it does take time and understanding. You may go through several versions of trial and error in trying to create what you are looking for.

We also offer consultancy which mean that we can supply a trainer / consultant to assist you with the creation of your database. Our rates start at �650 per day.

Here is a simple outline of creating relationships, however, you do need to bear in mind that the structure of your tables influences the way the relationhsips are created and work.

In Access, click TOOLS > then RELATIONSHIPS. The tables in the database are shown, and to create a relationship, click and drag a field in a table and drop it onto a field in the table you want to link to.

To understand more about the process, you can look at topicsin help like:
Creating database relationships (the process)
Normal forms (organising data in tables)
Referential integrity (how data in one table relates to a another field in a different table based on the relationship).

· Access And Its Uses On The Web
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· So You Want To Create Forms In Access 2007?
· User-Level Security In Access
· User-Proofing Your Access Database: Part 1