answersLogoWhite

0


Best Answer

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

A primary key field is always unique. Any other field that you have can be set to not allow duplicate values if necessary too.

This answer is:
User Avatar

User Avatar

Anonymous

Lvl 1
3y ago

Duplicate credit cards

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What type of field cannot hold duplicate value in ms access?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is a field that stores the value of mathematical operation in access?

A Calculated Field


Can a primary key have a blank or null value entered into its cell?

No. A Primary Key is the Unique identifier and cannot be null and cannot be duplicate.


When using Access the content of any given field is known as what?

field value


What is the type of field is used for money value in access?

Dear Sir, Currency is used as a type of field for money values in access. Dev


What a pre-filled user field called in access?

It is a field with a default value, so it is a default value field. Autonumber fields can also put values in themselves, as can calculated fields.


In Microsoft Access if the value 1000.5 is entered in a field in access that has been defined as currency data type then the value will display how?

$1,000.50 (depending on how you configure comma and currency symbol)


What is the field value may contain in ms access?

1picture 2 text 3 both1and2


What field property changes how a field will appear when displayed or printed but does not change the value stored in the field?

This question is in regards to Access 2010. The answer is one of the following... A.) Format B.) Caption C.) Default Value D.) Input Mask


Is it true or false that certain Access data type have a predefined field size that cannot be changed?

The Field Size Property defines a field values maximum storage size for Text, Number, and AutoNumber fields only. The other data types have no Field Size property because their storage size is either a fixed, predetermined amount or is determined automatically by the field value itself.TRUE


What field is used to retrieve values from another table or a value list in access?

See discussion, please.


How is a default value set in MS Access?

When you provide a default value for a field in Access, Access will automatically insert this value into the field when a record is inserted that has no value (NULL) for this field. Default values are used when there is a sensible default for a field.


How would you define MED as a default value in a field called client type?

In Access, when creating field, first set it to be a text type. Then in the Properties window there is an option to set a default value. Type MED in there.