primary keys

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 KEYS

PRIMARY KEYS

resolvedResolved · Urgent Priority · Version 2007

George has attended:
Access Intermediate course
Access Intermediate course

PRIMARY KEYS

WHEN WOULD YOU USE MULTIPLE PRIMARY KEYS AND GIVE EXAMPLES

RE: PRIMARY KEYS

Hi George

Thank you for your question

Multiple or compound keys are used in place of an autonumber field, where there is no one existing field that is unique to individual records.

For example if you had a staff database with no unique fields you might decide to use a key compounded out of first name, second name and date of birth fields

The important consideration would be the uniquness of each combination. In the above example the developer would have to consider the likelihood of two people sharing the same first and second names as well as a date of birth

Hope this helps

Regards

Stephen

Thu 5 Mar 2009: Automatically marked as resolved.


 

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips


Server loaded in 0.09 secs.