Faking It – a Suggestion (Access All Versions)

Topic

New Reply

Some other Scramble Data solutions:

DataScramble.mdb (intermediate
http://www.rogersaccesslibrary.com/downloa…ataScramble.mdb%5B/url%5D

Data Anonymous (Scramble That Data) I
http://www.utteraccess.com/forums/showflat…=&Zt=3e8&Zs=&Zy%5B/url%5D

HTH John

Reply | Quote

Replies

Occasionally, I need to build a database without data. This could be for a couple of reasons; 1) the data is too sensitive for me to take away, or 2) it is for a new function and no data has been collected yet.
Yet there is nothing like having data to test what you build.
I also hate data entry.
If you are in a similar situation you may find the attached Excel file to be useful. I use variations of this file to create all sorts of fake data.
A couple of points: 1) The file makes extensive use of the RANDBETWEEN function. This requires the installation of the Analysis Toolpack (Excel 2003) Add-in.
2) Obviously, the data I’m generating is Medicine Hat-centric, but you can find sites like Top 100 Baby Names , Wikipedia Most Common Surnames, and Vancouver Street Name List to customize your output.
I hope you find this helpful.

Reply | Quote