How to Choose a Primary Key in Access 2007

This "How to Choose a Primary Key in Access 2007" video requires the latest version of Adobe Flash Player.
Download Flash

Get Flash

More From Software

Please Rate

Send

Send to Your Friends

Use Your Email Software Or:

Send to: (enter email addresses, seperated by commas)

Your Name:

Your Email:

Your personal Message (optional):

Favorite

Favorites

This video has been added to 'My Favorites' in your studio.

This video has been removed from 'My Favorites' in your studio.

Loved this video? To add it to your faves, please Log in or Sign up now!

Flag

Flag this as Inappropriate

If you find this video to be inappropriate or offensive for any reason, please select a reason for reporting it from the dropdown menu below.

Reason

We are committed to reviewing each and every one of your submissions.

If you are the copyright owner of this video and believe it has been uploaded without your permission, please follow these instructions in order to submit a copyright infringement notice.

Videos Shared:

513

Member Since:

9/22/09

By: TechTutor.tv

We produce professional, specific, high-quality, easily available, and absolutely free software tutorials.

Video Info:

How to videos/ Tech videos / Software videos

Views:1,772 Rating:0 Comments:0

How to Choose a Primary Key - Access 2007 -

In this Access 2007 tutorial, learn how before you set the primary key in, you should make sure that you...

How to Choose a Primary Key - Access 2007 -

In this Access 2007 tutorial, learn how before you set the primary key in, you should make sure that you choose a field that will have unique data in each entry.

Added: 9/29/09

Tags:

How to Choose a Primary Key - Access 2007 access 2007 access help access tips access tutorials how to choose a primary access key how to use access software help software tips tech help techtutortv

URL:

Embed: (More)

Comment on this Video

Your Name: Email (optional):

Are you human?

Comments
Add-ons
Links
Transcript

Get it off your chest – be the first to comment on this video!

How to Choose a Primary Key in Access 2007

Every database needs to have what’s called the primary key and this primary key is a field that is unique for every single record. So, for instance you would not want to choose a primary key for my first name field because I might have two work contacts whose first name is Susan, and even last name I might come across two people at the same last name, company same thing, so you need to pick a field that’s going to be really unique for every single entry. An easy way to do this is when you first create a table, when you open Access you’re going to usually have an ID, field name created for you, and this is a great one to make your primary key because it assigned to unique ID number to every single record in your database. So, to make it a primary key field just right click over to the left, and then click on primary key and that will set your database for your ID as being your primary key.

techtutortv

Top tips from the basic to the advanced on numerous software.

http://www.techtutor.tv

Every database needs to have what’s called the primary key and this primary key is a field that is unique for every single record.

So, for instance you would not want to choose a primary key for my first name field because I might have two work contacts whose first name is Susan, and even last name I might come across two people at the same last name, company same thing, so you need to pick a field that’s going to be really unique for every single entry.

An easy way to do this is when you first create a table, when you open Access you’re going to usually have an ID, field name created for you, and this is a great one to make your primary key because it assigned to unique ID number to every single record in your database. So, to make it a primary key field just right click over to the left, and then click on primary key and that will set your database for your ID as being your primary key.

Transcription by: Scribe4you Transcription Services