How to Rename a Primary Key

Save

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.

  • Open the Microsoft Access Database program and the database file you want to edit.

  • Double-click on the table name you want to edit from the Database Navigation menu located on the left side of the screen.

  • Under the "Home" Tab, click on the "View" drop-down arrow.

  • Click on "Design View."

  • Under the "Field Name" heading, locate the primary key field. This field will display a key icon to the left of the name.

  • Highlight the text in this field and type in the new title for the primary key field.

  • From the top menu bar, click "File" and then "Save."

  • Click on the "X" located on the top right of the table design screen to close the Design View.

References

  • "Microsoft Access 2010 Step by Step"; Joan Lambert; 2010
  • Photo Credit Walker and Walker/Digital Vision/Getty Images
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!