microsoft access courses - Keys

The UK's most regular instructor-led training courses.
Training information: microsoft 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

Keys

Jenny has attended:
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Jenny [6 posts] (2007 Jul 19 Thu, 09:50) Reply

In a table can you combine two foreign key attributes to make a primary key without causes problems in the table. How do you do this

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	1	book now	£235	£240
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Keys

by - trainer Richard platinum contributer [785 posts] (2007 Jul 20 Fri, 10:21) Reply

You can make a primary key out of two fields.
Simply select BOTH fields in the design view and then click the Primary Key button.

This may or may not cause problems in your database, depending on how it is setup and layed out. Suggest backing up your database and testing it out first.

· Learn about Subqueries in Access Courses
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Microsoft Access Courses
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Reasons to Consider Microsoft Access Training

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips