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?

1
  • You could write a VBA program to populate it - better than the manual tedium alternative, and you may learn something. Commented May 26, 2013 at 0:36

2 Answers 2

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.

Sign up to request clarification or add additional context in comments.

Comments

0

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

enter image description here

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.