microsoft access courses - 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 Access Training and help » microsoft access courses - Keys

microsoft access courses - Keys

resolvedResolved · Low Priority · Version Standard

replyReply Thu 19 Jul 2007, 09:50Delegate Jenny said...

Jenny has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Keys

In a table can you combine two foreign key attributes to make a primary key without causes problems in the table. How do you do this

For upcoming training course dates see: Pricing & availability

replyReply Fri 20 Jul 2007, 10:21Trainer Richard said...

RE: Keys

You can make a primary key out of two fields.
Simply select BOTH fields in the design view and then click the Primary Key button.

This may or may not cause problems in your database, depending on how it is setup and layed out. Suggest backing up your database and testing it out first.

 

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

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