MS Access 2007 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.
Figure 2-7: Right-click on the field name in the table Design View to
exposes Primary Key command.
________________________________________
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: