hi guys i have a simple project and there are used access database. but now i need to add primary key in my access database table. please guide me how to create primary key in access database table.
thanks.
Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
AI Tools Integration
Add a field as a primary key
1. Open MS Access and select the Blank Desktop database.
See below image ->
2. after clicking the Blank Desktop database a popup will be open.
See below image ->
3. In the Navigation Pane, right-click the table and click Design View.
4. now select the column to which you want to add the primary key and click the primary key button.
see below image->
i hope it will help to you