primary key

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Primary Key

Primary Key

resolvedResolved · Low Priority · Version 2003

Graham has attended:
Access Intermediate course

Primary Key

is it possible to see which is the Primary key from tabe view?

RE: Primary Key

Dear Graham

Thank you for attending Access Intermediate course. I hope you enjoyed teh course and benefited from it.

Unfortunately the only way you can find out the field that has been assigned as priimary key is either the Design view or the relationship window where you can see the bold fields are the primary key.


The only other way to find out is by common sense. If you see that the data is not duplicating on a field and the heading suggests something like Cust No. or Cust ID, etc... then that will be the primary key.

I hope that has answered your question. Please mark this post as resolved.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007


 

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Server loaded in 0.09 secs.