How to Create a Basic 'TEST' Database in Access

Published by Shane-Zentz

Create a basic test database in access 2010:
This tutorial covers how to create a ‘test’ database in Access 2010. You might say, why create a test database? Well, the answer is that sometimes it is much easier to start with a simple database with only a few tables and forms to see how your project will work when it is scaled to a much larger level. The main reason is simplicity and testing. Testing and coding is always much easier when working on a smaller scale. If you are familiar with programming then you know that it is easier to code one small module (or function, or method) at a time instead of trying to write the whole program line by line. It is the same principle here. So if you have a project to do in access, whether large or small, hard or easy, for work or school, then this tutorial will show you how to quickly set up a test database in Access 2010.

Let’s say, just for an example, that your project involves a large amount of data and data sets, but you are currently stuck on a certain relationship between two tables or a design problem between two tables or a programming issue between two tables. Then instead of working with a large set of data and tables (and queries, relationships, modules, ect.) it may be easier to just create two example tables that are at least similar to the ones that you are currently stuck on, and then add a little bit of test data just to work with. This should be easier than working within your complex project and then when you have the problem solved or have a worked out solution, it will be much easier to just import that solution into your project.
So for this lets assume that you are stuck on some problem that exists between one table which contains customer data and another table which contains data for a business. In this scenario, I would create a simple access test database with only two tables. The tables will be called ‘customer’ and ‘business’ to keep it pretty simple. And the tables will have the expected data fields to go with them as well. So the first step is to open access and create the two tables:

And add all the necessary fields, but remember that this is just a test so there is no need to add each and every field, we just want some example data to work with and we still want to keep it pretty simple to make it easier to work with.

Then, once you have the two tables and the data fields that correspond to those tables, now it is time to add some ‘test’ data. Just make up a few customers and a few businesses, in this case. Now we have our test database set up and we are ready to solve our problem.
Is it a relationship problem?

Is it a design problem?

Is it a module/coding problem?

As you can see it is sometimes easier and beneficial to just create a simple test database to solve a problem that would be more difficult to solve on a larger scale, then import the solution into the more complex project. So I hope that this advice will help with your next access database project or assignment.

Thanks for reading this post!

Shane Zentz

656 thoughts on “How to Create a Basic 'TEST' Database in Access”

  2. We stumbled over here coming from a different page and thought I might check things out. I like what I see so now i am following you. Look forward to looking at your web page for a second time.

  3. I’m not sure exactly why but this site is loading very slow for me. Is anyone else having this issue or is it a problem on my end? I’ll check back later and see if the problem still exists.

  4. I would like to use the chance of saying thanks to you for your professional instruction I have often enjoyed viewing your site. I’m looking forward to the commencement of my school research and the overall preparing would never have been complete without checking out this site. If I might be of any assistance to others, I will be happy to help by way of what I have learned from here.

  5. Hello every buddy, it’s a fantastic entertaining at here viewing these funny YouTube video clips at at this place, pleasant data, thanks to admin of this site

  6. Consume both before and after your training session. A treat with lots of healthy proteins can make the best way to get ready for or body fat will keep your body correctly powered. Hypergh 14x UK Once you are more along with you muscles-developing endeavours, you could possibly benefit from stepping within the protein consumption by utilizing very careful dimension and planning of food with increased depth.

  9. Very nice post. I just stumbled upon your weblog and wanted to say that I’ve truly enjoyed surfing around your blog posts. After all I will be subscribing to your feed and I hope you write again soon!

  11. Do all insurance work in advance so the lender should first confirm that the fact that the many Western economies still haven’t recovered from the comfort of your own home. The primary goal is to refinance the property is vacant, under-performing or producing sufficient cash flow. The process can take a while.

  12. There has been a financial state which can be fairly powerful so you may not want to consider the interest they charge. In the case of not timely payment. To find out the cover that the loan lebron basketball shoes.

  13. Magnificent goods from you, man. I have understand your stuff previous to and you are just too great. I really like what you’ve acquired here, really like what you are saying and the way in which you say it. You make it entertaining and you still care for to keep it sensible. I can not wait to read far more from you. This is really a great website.

  15. I’m truly enjoying the design and layout of your site. It’s a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a developer to create your theme? Outstanding work!

  18. Interesting blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog stand out. Please let me know where you got your design. Bless you

  19. I’m curious to find out what blog system you’re utilizing? I’m experiencing some small security problems with my latest blog and I’d like to find something more secure. Do you have any recommendations?

  22. I want to show some thanks to the writer just for bailing me out of this type of condition. Just after browsing throughout the the web and obtaining opinions that were not productive, I figured my entire life was well over. Being alive without the strategies to the issues you’ve solved all through your entire guideline is a crucial case, as well as the ones which may have in a wrong way damaged my entire career if I hadn’t encountered your website. The mastery and kindness in handling the whole thing was invaluable. I don’t know what I would have done if I hadn’t encountered such a subject like this. I can also at this time relish my future. Thanks very much for your expert and result oriented guide. I won’t think twice to refer the sites to anyone who would like direction on this issue.

  23. Right now it sounds like BlogEngine is the best blogging platform out there right now. (from what I’ve read) Is that what you are using on your blog?

  24. I simply couldn’t depart your site prior to suggesting that I extremely enjoyed the usual info an individual provide for your guests? Is gonna be again regularly in order to check up on new posts

  25. Thanks for another fantastic article. Where else could anybody get that kind of information in such a perfect way of writing? I have a presentation next week, and I’m on the look for such information.

  27. You recognize that there are the means by which many people obtain the check to complete your requirements. The real issue is that their turnaround time is very hard to get the funding from the first party to recover their investment. The application process takes about 15 minutes in most cases. When you evaluate your use of money lending industry is a requirement for almost all lenders out there.

  28. I’m commenting to let you understand of the beneficial encounter my princess undergone reading through your web site. She learned several details, with the inclusion of what it’s like to have an amazing giving heart to let other individuals just fully grasp certain impossible matters. You really surpassed readers’ expected results. I appreciate you for presenting the important, dependable, informative and in addition fun thoughts on your topic to Julie.

  29. Great goods from you, man. I’ve understand your stuff previous to and you are just extremely excellent. I actually like what you’ve acquired here, certainly like what you’re saying and the way in which you say it. You make it entertaining and you still take care of to keep it smart. I cant wait to read far more from you. This is really a tremendous web site.

  30. Chemicals, of course, represent a problem in commercial farms as it is quite expensive, and doesn’t always work. Doing everything you can use a mixture of soap and water in it. Be careful when applying Orange Guard Water Based Indoor/Outdoor Home Pest Control directly via one of the pest without damaging the environment.

  32. Youre so cool! I dont suppose Ive read something like this before. So good to seek out someone with some unique ideas on this subject. realy thank you for starting this up. this website is one thing that’s needed on the web, somebody with a little bit originality. helpful job for bringing one thing new to the internet!

  36. Hi there to every body, it’s my first pay a quick visit of this website; this webpage contains remarkable and genuinely fine stuff designed for visitors.

  37. An impressive share, I simply given this onto a colleague who was doing a bit evaluation on this. And he in actual fact bought me breakfast as a result of I discovered it for him.. smile. So let me reword that: Thnx for the deal with! But yeah Thnkx for spending the time to discuss this, I feel strongly about it and love reading extra on this topic. If doable, as you turn out to be experience, would you thoughts updating your blog with extra details? It’s highly useful for me. Massive thumb up for this weblog post!

  39. I have read much concerning without charge blogging web pages, but I have no clear idea about that, can any one tell me which one is most excellent in favor of free blogging?

  42. It’s genuinely very complex in this full of activity life to listen news on Television, thus I only use the web for that purpose, and get the most up-to-date information.

  46. If you are going to watch humorous videos on the net then I suggest you to go to see this site, it carries actually therefore humorous not only videos but also additional material.

Comments are closed.