primary key use
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 Access Training and help » Primary Key use

Primary Key use

resolvedResolved · Low Priority · Version Standard

replyReply Mon 25 Feb 2008, 15:55Delegate Craig said...

Primary Key use

How does the primary key help to link tables

For upcoming training course dates see: Pricing & availability

replyReply Fri 29 Feb 2008, 16:56Trainer Rajeev said...

RE: Primary Key use

Dear Craig

Thank you for attending Excel and Access courses. I hope you enjoyed them and they were beneficial to you.

If believe you asked this question when you did Access Intro where we didn

 

Please browse our web site to find out more about
ms+access+course/ and other Microsoft training courses.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access 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