RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Access DB
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Data Manipulation
«Prev
Next»
Access Database
Database Features
Open Access Database
MS Access Window
Access Help System
Access Database Window
Access Interface Conclusion
MS Access Database
What is Database
What is Relational Database
Design Relational Database
How Data is stored
Access Database Objects
Database Analysis
Create Access Database
Steps For Creating Database
Design Tables Conclusion
Creating Access Table
Creating Access Tables
Access Datasheet
Edit Access Datasheet
MS Access Functions
Importing Data
Import Access Table
Building Modifying Forms
Table Manipulation
Primary Key - Exercise
Understanding the primary key
Objective:
Create a primary key field in the Projects and Clients tables.
Exercise Scoring
You will receive 2 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit for the exercise is click the
Submit
button.
Overview
Neither the Projects table nor the Clients table currently has a primary key. Since every table needs a primary key if it is going to be linked with other tables in the database, you will create one for both of these tables.
Instructions
Open the Clients table. Define the Company field as the primary key.
Save the table design and close the table.
Open the Projects table.
Create a new field in the Projects table Design view called Project ID, make this field an AutoNumber field. Traditionally, the Primary Key field is the first field in the table, so you might want to insert or move this new field so that appears first.
Once you have created the new field, make it the primary key.
Save the table design and close the table.