access class microsoft training - Primary key

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

Resolved · Low Priority · Version Standard

Primary key

John has attended:
Access Introduction course

by - delegate John [1 post] (2007 Jul 23 Mon, 09:58) Reply

what is a primary key?

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

RE: Primary key

by - trainer Tracy platinum contributer [586 posts] (2007 Jul 23 Mon, 10:21) Reply

Hi John,

Thank you for the question

A primary key is a field that is used to uniquely identify a record in a table. The primary key field also helps you to relate two tables.

Tracy

RE: Primary key

by - delegate Reza [10 posts] (2007 Aug 19 Sun, 14:52) Reply

Hi Tracey,

I have got two questions; In regards with primary key, how can access increment user specified PK. In other words, if I decide to set my OWN primary key (i.e. 9874, 9875, 9876,...) how can we assign Access to increment by one each time we enter the new data/record in form.

My next question is, I have seen in other forms that once user enters the date into one field, the information for other specified field retrieved automatically. For example, as soon as I insert the Date into my Date Field of my form, the Week number pops out into my Week Number field. I think this is something to do with Lookup/Searching wizard.

Thank you

· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Access VBA Handling Errors and Debugging Code
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Microsoft Access 2007: New Features
· Discover the Secrets within Your Business through Microsoft Access Training

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips