Anonymous Post |
||
| data entry | Post Reply | |
| Question: Is there a command that you enter in the database that could detect and eliminate duplicate records? | Number of Replies: 3 | |
| Date Posted: 2012-05-15 | ||
List of Replies |
||
| #1 | ||
| Answer: | Well it depends on a number of things. First thing... Depending on the kind of information that a database is suppose to collect, it is good practice to set the key fields so that duplicate information is not entered. In the event that you are allowed to enter duplicate information then you can create queries that will detect and list all duplicate records. What database are you using / referring to? We may be able to help you more if we have more information. | |
| [Date Posted: 2012-05-15] | ||
| #2 | Anonymous | |
| Answer: | microsoft access. Also, are there any other database programs that can generate a list of names including images? | |
| [Date Posted: 2012-05-16] | ||
| #3 | ||
| Answer: | First thing you should realise is that the database does not perform the queries needed to generate reports etc. Such is done using scripting languages through ASP, PHP etc. In Microsoft Access...You can eliminate duplicate records by setting the (indexed) option of the fields in a table to No Duplicates. You can create queries in Microsoft Access that will generate reports from the data stored in the tables. The queries are built on the Visual Basic (VB) scripting language. | |
| [Date Posted: 2012-05-16] | ||