Home > Topics > Access > How to set primary key in access?

How to set primary key in access?

藏色散人
Release: 2022-01-12 15:38:15
Original
57986 people have browsed it

How to set primary key in access?

How to set the primary key in access?

If you have a table where each record has a unique identifying number (such as an ID number, serial number, or encoding), this field can make a good primary key. For a primary key to work properly, the field must uniquely identify each row, never contain a null or Null value, and rarely (ideally never) change.

To set the primary key explicitly, you must use Design view. Click the Office Button, and then click Open. In the Open dialog box, select and open the database. In the Navigation Pane, right-click the table on which you want to set the primary key, and then on the shortcut menu, click Design View. Select one or more fields to use as primary keys. To select a field, click the row selector for the desired field.

To select multiple fields, hold down Ctrl and click the row selector for each field. On the Design tab, in the Tools group, click Primary Key. A key indicator is added to the left of the field or fields that you specify as primary keys.

The above is the detailed content of How to set primary key in access?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
Access error using alias
From 1970-01-01 08:00:00
0
0
0
Single module access
From 1970-01-01 08:00:00
0
0
0
About Mac MAMP PRO deploy thinkphp5.1 access 404
From 1970-01-01 08:00:00
0
0
0
My access page reports 403
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template