<div>
That's quite a broad question (especially for 50 points!) but the one thing I would suggest is that you DON'T go deleting records in your 'data entry' table; instead, I'd suggest copying 'validated' records across into a 'final data' table (and flagging them in the first table so you know they've been dealt with).<br />

</div>


That's quite a broad question (especially for 50 points!) but the one thing I would suggest is that you DON'T go deleting records in your 'data entry' table; instead, I'd suggest copying 'validated' records across into a 'final data' table (and flagging them in the first table so you know they've been dealt with).


<div>
<div class="content wysiwyg-content">
I need to develop a database system with sql server 2000 on the back end and access 2003 on the front end.The nature of the system is such that you should capture a form twice (double entry) .One person should enter the form into the table and a different person should enter the same form into the same table and some checks are to be done to make sure all the entries by the 2 people do agree and if they are the same one is deleted so that one entry remains in the table.If there any different values in the fields the two forms are saved in the same table and later the forms can be opened to modify until all fields do agree for the 2 entries and one is deleted .Any help how i can implement this 
</div>
</div>


I need to develop a database system with sql server 2000 on the back end and access 2003 on the front end.The nature of the system is such that you should capture a form twice (double entry) .One person should enter the form into the table and a different person should enter the same form into the same table and some checks are to be done to make sure all the entries by the 2 people do agree and if they are the same one is deleted so that one entry remains in the table.If there any different values in the fields the two forms are saved in the same table and later the forms can be opened to modify until all fields do agree for the 2 entries and one is deleted .Any help how i can implement this 

Implementing double entry system in access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.