Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access training - Primary Key

	98.1 % recommend us
	More live stats...

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

Training information:

ms access training - Primary Key

Resolved · Low Priority · Version Standard

Reply Wed 18 Jul 2007, 10:02Delegate Tim said...

Tim has attended:
Access Introduction course

Primary Key

If when you upload a new database what affect does having a primary key have on the database?

For upcoming training course dates see: Pricing & availability

Reply Fri 20 Jul 2007, 10:01Trainer Richard said...

RE: Primary Key

Tim,

The primary key is a unique number that identifies each record, in relation to other tables.

When you see a primary key of say a Supplier table in another table, lets say Products, it is known a sa foriegn key. Basically it identifies the related records.

Regards
Richard

Access articles

· Why go on a Microsoft Access Training Course?
· Tips for designing databases in Microsoft Access
· How Does The Startup Work When Access 2010 Launches The Northwind Database
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· MS Access and Database Normalisation

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy