Double data input at same time ?

[Accessdummy]

Hi everyone,

In the database I have created, I want patient data to be
filled in twice (double data entry) using forms. This
means that I will get every line twice in every table,
only with two different data entrist IDs. In the end I
will run queries which then compares the lines, and see if
any mistakes have occurred.

However, I want to know if it is possible that two data
entrists will be filling data in the same database at the
same time ? (Most likely it won't be happening that they
fill in data for the same patient at the same time.) And
if it is not possible, then how can I make it happen
anyway ?

And, like my 'name' will tell you, I am an Access Dummy,
so can you explain it in a simple way ?

 

[Arvin Meyer]

Absolutely possible. You should make sure that the data tables are split
from, and linked to, the rest of the application. There is a wizard to help
you do that (Tools ... Database Utilities ... Database Splitter) although it
is as easy as copying the entire file, opening each copy, and deleting the
desired elements, then linking the tables.

Understand, that the 2 lines may not necessarily be next to one another, but
you can write a query, or use the Find Duplicates query wizard to put them
together.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Mike Painter]

Hi everyone,

In the database I have created, I want patient data to be
filled in twice (double data entry) using forms. This
means that I will get every line twice in every table,
only with two different data entrist IDs. In the end I
will run queries which then compares the lines, and see if
any mistakes have occurred.

Which means a lot of extra work just finding the records that may be in
error.

When I've had that requirement I had the person enter the data twice while
they had the documents, then popped up a list if the two entries werer not
the same so they could select the correct one rather than forcing a third
typing of the information which could also be in error.

 

[Arvin Meyer]

One of the techniques used in critical data-entry situations is to have 2
different people enter the data. The theory being that if both enter it
exactly the same, it is more likely to be accurate than if 1 person enters
it. The technique usually prescribes that when an error is found, both
entries are discarded and 2 new entries are made. This continues until all
data is entered.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access