MS Access 2003 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 2: MS Access Local & Linked Tables
How to Create a Primary Key?
Creating
Primary key is fairly simple. All you have to do is to open the table in
Design View and right click on the column you would like to make as
‘Primary Key’ column. Select the option ‘Primary Key’ from the popped up
menu. Remember in developing Primary-Foreign Key relationships between
tables the story begins with developing primary key first.
Before making the column as primary key make sure
that all the values in that particular column should be unique or will
be unique if it’s the first time you are creating the table. Once you
create the primary key column the following things get effective.
• You would not be able to insert duplicate values in that particular
column.
• MS Access will create an implicit index on that particular column.
Chapter 2: MS Access Local & Linked Tables
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: