0

I have an assignment to create and test database specifically on Microsoft Access. I have layed out architecture of it that means I have created tables and relations.

Yet I am not feeling ultra excited about filling every table with content copying and pasting fro lorem ipsum page...

Can a MS Access database be automatically populated with random content? If so how?

Jérôme
  • 2,070
  • 15
  • 21
PovilasID
  • 883
  • 10
  • 34
  • You could write a VBA program to populate it - better than the manual tedium alternative, and you may learn something. – ron tornambe May 26 '13 at 00:36

2 Answers2

1

The easiest way I've found to generate random test data is to do it in Excel and then copy/paste into Access.

If you're populating user records, then you can use http://www.fakenamegenerator.com/ which will create huge users lists of totally fake data with almost any attribute you need.

Samuel Neff
  • 73,278
  • 17
  • 138
  • 182
0

The best way is to use microsoft online templates. See the below screenshot

enter image description here

santhosha
  • 351
  • 2
  • 8
  • 20