Microsoft Office Tutorials and References
In Depth Information
• Click the Yes button to complete
the deletion of the ﬁ eld.
• With the Client Number ﬁ eld
selected, click the Primary Key
button to designate the Client
Number ﬁ eld as the primary key.
ID ﬁ eld has
• Click the Save button to save the
changes (Figure 1–37).
When I attempted to save the table
I got an error message that
indicates index or primary key
cannot contain a null value. What
did I do wrong and how do I ﬁ x it?
You inadvertently added a record
to the table by pressing some key
after you pressed the DOWN ARROW
key. To ﬁ x it, click the OK button
(you will need to do it twice) and
then click the Primary Key button
to remove the primary key. Click
the Save button to save the table
and then click the View button
near the upper-left corner of the
screen to return to datasheet view.
Click the little box immediately to
the left of the record you added and
press the DELETE key. Click the Yes button when Access asks if it is OK to delete the record.
Click the View button again and continue with these steps.
ﬁ eld selected
key symbol indicates
Client Number ﬁ eld is
now the primary key
• Close the Client table by clicking
the Close ‘Client’ button
Client table no
Client table in