access+courses+in+london - Relational DB

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

Resolved · Low Priority · Version Standard

Relational DB

Pajam has attended:
Access Introduction course

by - delegate Pajam [1 post] (2007 May 23 Wed, 14:03) Reply

How do I creat a Relational DB?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Relational DB

by - trainer Richard platinum contributer [818 posts] (2007 May 24 Thu, 16:45) Reply

Hi Pajam

Using access to create a relational DB can be a complex series of steps. Essentially you need to create a minimum of two tables and then link them together by a common field using a relationship.

As an example, you might have a suppliers table and a products table. Each supplier provides many products. So the products table would have a suppliers field that would link the product with the supplier.

In principal, that is how it works.

Regards

Richard

· Microsoft Access Courses
· Microsoft Access Mistakes to Avoid
· Access VBA Handling Errors and Debugging Code
· Microsoft Access Tighten your Security Controls
· Microsoft Access Training Unleashes the Power of the Pivot Table

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips