Question

A type of database that prevents duplication of data ( in Microsoft access )

Answer 1

Answer:

Hi,

I have created a form that has a drop down list that allows the selection of multiple values. After entering a few test records, I closed and reopened the database, and I found that I have duplicate form records. I originally entered 3 records, which included a date, name, personnel number, and action type (multiple value field). I choose 3 action types on each test record. Now, I have 9 records, with 3 total duplicate records for each entry. There is only one row per entry in table view, though.

I will be using this database for multiple users and predict that this behavior will confuse people if they need to go back through form records for review/printing. How can I prevent Access from creating multiple/duplicate records in form view?

Thanks in advance for your time and assistance!

hope this will be helpful..

mark as brilienest....

Answer 2

Explanation:

You can prevent duplicate values in a field in an Access table by creating a unique index. A unique index is an index that requires that each value of the indexed field is unique.

There are two basic ways that you can create a unique index:

Set the field's Indexed property to Yes (No duplicates)    You can do this by opening the table in Design view. This method is easy and a good choice if you only want to change one field at a time.

Create a data-definition query that creates the unique index    You can do this by using SQL view. This method is not as easy as using Design view, but has an advantage: you can save the data-definition query and use it again later.

#Learn more :

Where is microsoft access database used

https://brainly.in/question/1630995