ms excel training - primary keys
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Primary Keys

ms excel training - Primary Keys

resolvedResolved · Low Priority · Version Standard

replyReply Thu 21 Jun 2007, 16:59Delegate Tristan said...

Tristan has attended:
Access Intermediate course

Primary Keys

Can you assign two primary keys to a table? If so how? Cheers!

For upcoming training course dates see: Pricing & availability

replyReply Tue 26 Jun 2007, 13:00Trainer Tracy said...

RE: Primary Keys

Hi Tristan,

Thanks for the question

The answer to that is no, within a table you can only have one primary key, similar to the concept of everyone has a national insurance number. It is possible to not assign a primary key but you cannot have more than one.

kind regards

Tracy

 

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard