Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access Table Primary Key

Resolved · Medium Priority · Version 2007

Reply Thu 18 Nov 2010, 09:14Delegate Andy said...

Andy has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Access Table Primary Key

If I set a Primary Key using 2 fields, if the information changes in one of the fields (e.g. a status of a Supplier changes from 0 to 1), will it affect Queries and Reports functions ability to collate historic information for that Supplier?

For upcoming training course dates see: Pricing & availability

Reply Thu 18 Nov 2010, 11:14Trainer Simon said...

RE: Access Table Primary Key

Hi Andy,

Thank you for your question and welcome to the forum.

I believe it will have an impact as all the queries and forms are based on the data in the tables.

What you could do is create a make table action query to create a new table with the current set of records before you change the Supplier from 0 to 1. This will allow you to keep the historic data in a separate table.

I see from the information that you are coming on the Intermediate course and you will learn that function then.

If you create a query in Design View and go to the Query Tools menu and Design Tab, you will see the Make Table Action query option.

Here is a link to an example:

http://www.youtube.com/watch?v=bI_3iWHBL1Y

I hope this helps.

Regards

Simon

Thu 25 Nov 2010: Automatically marked as resolved.

Access articles

· Microsoft Access: Access Its Full Potential For Business Rewards
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Understanding The Components Of Access
· A Greater Understanding Of Your Business With Access Reports
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course

Please browse our web site to find out more about
microsoft database training and other Microsoft training courses.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips