How to Rename a Primary Key
Microsoft Access is a database program that allows users to create tables, forms and reports. Data can be added to a database by typing directly into a table or form or by importing data from a spreadsheet, text or database file. Access provides users will the option of creating relational databases in which data are linked between multiple tables. With each data table created, a primary key is assigned. A primary key is a field that must contain a unique entry such as an ID number, social security number or phone number. Once a primary key is set, the user can reassign the primary key to a different field or rename the title.
Other People Are Reading
Instructions
-
-
1
Open the Microsoft Access Database program and the database file you want to edit.
-
2
Double-click on the table name you want to edit from the Database Navigation menu located on the left side of the screen.
-
-
3
Under the "Home" Tab, click on the "View" drop-down arrow.
-
4
Click on "Design View."
-
5
Under the "Field Name" heading, locate the primary key field. This field will display a key icon to the left of the name.
-
6
Highlight the text in this field and type in the new title for the primary key field.
-
7
From the top menu bar, click "File" and then "Save."
-
8
Click on the "X" located on the top right of the table design screen to close the Design View.
-
1
References
- Photo Credit Walker and Walker/Digital Vision/Getty Images
