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. I actually really like the cover and it appears to be like much like inside the photograph. It is extremely heated but not too puffy to the point where you appear just like a marshmallow!
    [url=http://www.oakleysol.com/fake-oakley-holbrooks-c-9.html]Oakley Holbrook outlet[/url]
    Oakley Holbrook outlet

  4. Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin

  10. Hiya, I am really glad I’ve found this info. Nowadays bloggers publish only about gossips and web and this is really annoying. A good blog with exciting content, that is what I need. Thanks for keeping this web-site, I will be visiting it. Do you do newsletters? Can not find it.

  15. When I first saw this title How to Create a Basic Test Database in Microsoft Access | Shane Zentz's Blog on google I just whent and bookmark it. I delight in, result in I found just what I used to be having a look for. You have ended my four day lengthy hunt! God Bless you man. Have a great day. Bye

  16. When Dave Winer developed SOAP with Don Box and Microsoft engineers,Office 2010 serial key, you and Bill signed on and jumpstarted the Web services revolution.

  17. hansgrohehg28487621phoenixshowerrubbed.buyvl” Hansgrohe HG28487621 Phoenix Shower Rubbed by pure mistake, and in

  18. Excellent post. I was checking constantly this blog and I’m impressed! Very helpful information specially the last part 🙂 I care for such info a lot. I was seeking this particular info for a very long time. Thank you and best of luck.

  19. Is it … ?! call: Discount for Christmas – Happy holidays get discount 5+5% – viagra Kamagra side effects – Cheap Kamagra pills impotence , Kamagra blue heart shaped tablet – kamagra ajanta pharma limited or Kamagra UK Buy original – kamagra suppliers uk and bulk buy kamagra – Cheap Kamagra online Generic viagra ….Happy holidays get discount 5+5%..!!! Now Adult +++18 solo porn fingering – orgies porn ohio made porn free porn mpeg-4 I’m looking forward to seeing you again!

  22. There are some interesting points in time in this article but I don’t know if I see all of them center to heart. There is some validity but I will take hold opinion until I look into it further. Good article , thanks and we want more! Added to FeedBurner as well

    [url=http://cheapnfljerseys168.likesyou.org/]NFL Jerseys[/url]

    [url=http://jordansoutletgc.exteen.com/]jordan shoes[/url]

  23. Welcome! check: Happy holidays get discount 5+5% – Cheap Generic overnight Kamagra Online Ordering – lowest price Kamagra , Cheap pills Kamagra 100mg Online – how to Buy Kamagra now Online or Cheap Kamagra speed – Kamagra many orgasms and Buy Cheap Kamagra usa – viagra Kamagra discounts ….Discount for Christmas 5+5 % -Off!!! Now +18 – free long streaming porn – free porn videos for ipod touch gay porn sample clips downloads free orgy porn videos With kind regards!

  26. How are things?! it for you: Happy holidays get discount 5+5% – find Cheap Kamagra Fedex delivery only – no prescription kamagra oral jelly usa , Cheap Kamagra for sell – Super Kamagra inexpensive or order kamagra online – Kamagra 6 hour delivery and Kamagra Oral Jelly manufactures – buyers of kamagra ….Discount for Christmas 5+5 % -Off!!! Now +18 – lesbian porn for psp – sick hentai porn mpegs top calie marie porn gushing porn cams See you soon!

  28. Welcome! call: Happy holidays get discount 5+5% – kamagra mixed with cannabis – Kamagra Increasing the sexual functionality , buy cheao cgeap kamagra uk viagra – Buy Generic online Kamagra or Kamagra guarenteed Cheapest – Kamagra Oral Jelly 100mg UK Buy Generic viagra and Cheap Kamagra Generic viagra Buy – Kamagra 4×100 ….Discount for Christmas 5+5 % -Off!!! Now +18 – hentia bleach naruto porn – orgasm porn sites biggest in porn school girls porn free I’m looking forward to seeing you again!

  29. An impressive share, I just given this onto a colleague who was performing a little analysis on this. And he actually bought me breakfast due to the fact I located it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to talk about this, I feel strongly about it and enjoy reading more on this topic. If attainable, as you become expertise, would you mind updating your blog with even more details? It is highly beneficial for me. Massive thumb up for this blog post!

    [url=http://jerseys205.22web.org/]NFL Authentic Jerseys[/url]

  31. Good night! forward: Happy holidays get discount 5+5% – fast Kamagra without prescription – super Kamagra london , Kamagra tablets next day delivery Buy Cheap – U.S. pharmacies for Kamagra without rx or Kamagra Oral Jelly america – Kamagra tablets 100mg pills and Kamagra same as viagra – Generic online Kamagra overnight ….Discount for Christmas 5+5 % -Off!!! Now +18 – sandy summers porn videos – tamil porn downloads porn favorites amateur porn absolutely free See you later!

  32. What’s news?! call: Happy holidays get discount 5+5% – Kamagra Oral Jelly php – Cheap Kamagra for adoption , Kamagra without prescription mastercard accepted – Cheap Kamagra ajanta Jelly or Oral Jelly suppliers Europe Cheapest Kamagra – 100mg Kamagra Oral Jelly and Kamagra shop tongue – Kamagra Oral Jelly 100mg without prescription Cheap Generic viagra ….Discount for Christmas 5+5 % -Off!!! Now +18 – mrs sheilamarie porn – lmature porn free busty asian porn penetration porn Let’s keep in touch!

  33. kxeox [url=http://www.cheapbeatsuksale.co.uk]cheap beats by dre[/url] chzuvy http://www.cheapbeatsuksale.co.uk fhrk [url=http://www.cheapdrebeatssales.co.uk]beats by dre sale[/url] rwkyps http://www.cheapdrebeatssales.co.uk zbja [url=http://www.beatsbydreukstores.co.uk]beats headphone uk[/url] buqohm http://www.beatsbydreukstores.co.uk zphwo [url=http://www.drdrebeatsstores.co.uk]beats by dre headphones[/url] canesk http://www.drdrebeatsstores.co.uk pnefe [url=http://www.drdrebeatsuksale.co.uk]dr dre headphones[/url] cslqb http://www.drdrebeatsuksale.co.uk uji [url=http://www.drebeatsuksale.co.uk]cheap beats by dre[/url] vuqlp http://www.drebeatsuksale.co.uk egc

  34. How are you?! present: Happy holidays get discount 5+5% – Kamagra Oral Jelly australia discount sildenafil – Online shop Kamagra Online , Buy Kamagra in london – Buy prescription Kamagra Online fast delivery or Super Kamagra UK sildenafil citrate – Kamagra best deals and get Cheap Kamagra Online free delivery – Kamagra Oral Jelly 100mg visa sildenafil ….Discount for Christmas 5+5 % -Off!!! Now +18 – tv teen porn – mp4 mobile porn clips soft porn cowboy hbo 80 s animated mystique porn Take care of yourself!

  36. Dear Sir or Madam! it for you: Happy holidays get discount 5+5% – Kamagra Buy online UK – online Generic Kamagra c.o.d. overnight , get Kamagra Online without a prescription – Kamagra Oral Jelly 100mg california or order Kamagra online New Zealand – where can I purchase Kamagra USA and super Kamagra online ajanta pharma – Kamagra UK Online ….Discount for Christmas 5+5 % -Off!!! Now +18 – spacker porn – free gianna michaels porn videos full porn tv sex with the boss porn See you later!

  40. ofyzd [url=http://cheapbeatsbydreoutlet.co.uk]beats by dre[/url] ktacfj http://cheapbeatsbydreoutlet.co.uk qtoml [url=http://salebeatsbydreoutlet.co.uk]beats by dre[/url] yxtykg http://salebeatsbydreoutlet.co.uk ozznc [url=http://salebeatsbydrestore.co.uk]beats by dre[/url] rydhql http://salebeatsbydrestore.co.uk gkxgw [url=http://cheapbeatsbydredr.co.uk]beats by dre[/url] xbcdbh http://cheapbeatsbydredr.co.uk spude [url=http://cheapdrdrebeatssale.co.uk]dr dre beats[/url] pjtype http://cheapdrdrebeatssale.co.uk gddbx [url=http://drebeatsheadphone.co.uk]beats by dre[/url] pcwjro http://drebeatsheadphone.co.uk qjhns [url=http://beatsbydreoutletstore.co.uk]cheap beats[/url] lqyjfx http://beatsbydreoutletstore.co.uk qjei

  41. ltscq [url=http://www.drdreheadphonesaustralia.com]beats by dre[/url] wdbgxx http://www.drdreheadphonesaustralia.com rsemn [url=http://www.cheapbeatsaustraliaonline.com]beats by dre[/url] wpoles http://www.cheapbeatsaustraliaonline.com eacly [url=http://www.beatsbydreforsaleaustralia.com]beats australia[/url] fsjpv http://www.beatsbydreforsaleaustralia.com dkkfg [url=http://www.cheapbeatsbydreheadphonesaustralia.com]beats australia[/url] ijjce http://www.cheapbeatsbydreheadphonesaustralia.com rjfmt [url=http://www.cheapbeatsdreaustralia.com]beats australia[/url] hxsbv http://www.cheapbeatsdreaustralia.com zgjzg [url=http://www.cheapbeatsheadphonesaustralia.com]cheap beats by dre[/url] hqbzd http://www.cheapbeatsheadphonesaustralia.com skamv

  42. gbevn [url=http://cheapbeatsbydreoutlet.co.uk]beats outlet[/url] zznhdw http://cheapbeatsbydreoutlet.co.uk xjyqc [url=http://salebeatsbydreoutlet.co.uk]sale beats by dre[/url] zujhde http://salebeatsbydreoutlet.co.uk jawpm [url=http://salebeatsbydrestore.co.uk]beats by dre[/url] lilymk http://salebeatsbydrestore.co.uk hyeku [url=http://cheapbeatsbydredr.co.uk]dr dre beats[/url] jmhenu http://cheapbeatsbydredr.co.uk fndtp [url=http://cheapdrdrebeatssale.co.uk]beats by dre sale[/url] qhvuzs http://cheapdrdrebeatssale.co.uk epjms [url=http://drebeatsheadphone.co.uk]beats by dre sale[/url] xiznim http://drebeatsheadphone.co.uk hgkrj [url=http://beatsbydreoutletstore.co.uk]beats by dre[/url] scfouj http://beatsbydreoutletstore.co.uk iuqb

  43. dodme [url=http://www.drdreheadphonesaustralia.com]beats by dre sale[/url] xgfnak http://www.drdreheadphonesaustralia.com elgmv [url=http://www.cheapbeatsaustraliaonline.com]beats online[/url] xekcyg http://www.cheapbeatsaustraliaonline.com tzprw [url=http://www.beatsbydreforsaleaustralia.com]beats by dre sale[/url] rvcbt http://www.beatsbydreforsaleaustralia.com dvpru [url=http://www.cheapbeatsbydreheadphonesaustralia.com]beats australia[/url] ebdky http://www.cheapbeatsbydreheadphonesaustralia.com myqbm [url=http://www.cheapbeatsdreaustralia.com]beats australia[/url] wmdhm http://www.cheapbeatsdreaustralia.com wsjee [url=http://www.cheapbeatsheadphonesaustralia.com]cheap beats by dre[/url] qbnha http://www.cheapbeatsheadphonesaustralia.com pfyfz

  44. jnbko [url=http://cheapbeatsbydreoutlet.co.uk]beats by dre outlet[/url] lmszlt http://cheapbeatsbydreoutlet.co.uk mfykf [url=http://salebeatsbydreoutlet.co.uk]sale beats by dre[/url] prhvjn http://salebeatsbydreoutlet.co.uk whkrb [url=http://salebeatsbydrestore.co.uk]beats by dre[/url] rbcfhy http://salebeatsbydrestore.co.uk cnzry [url=http://cheapbeatsbydredr.co.uk]cheap beats by dre[/url] uslnqd http://cheapbeatsbydredr.co.uk cvlkb [url=http://cheapdrdrebeatssale.co.uk]beats by dre sale[/url] tyanhj http://cheapdrdrebeatssale.co.uk ncexb [url=http://drebeatsheadphone.co.uk]beats by dre sale[/url] bjckyc http://drebeatsheadphone.co.uk jnfra [url=http://beatsbydreoutletstore.co.uk]beats by dre outlet[/url] cksvxo http://beatsbydreoutletstore.co.uk cfko

  45. I realize, appropriate? You obtain the 100-year-warranty and they delay the claim until finally it expires. Bogus!

  46. Hello! Do you are aware of whenever they make any plugins to assist with Search Engine Optimization? I’m attempting to acquire my site to rank for a few targeted keywords but I’m not seeing really excellent results. For those who know of any make sure you discuss. Appreciate it!

  47. bmriv [url=http://cheapbeatsbydreoutlet.co.uk]beats by dre outlet[/url] pxmnyg http://cheapbeatsbydreoutlet.co.uk wlpea [url=http://salebeatsbydreoutlet.co.uk]beats by dre[/url] zbwjcg http://salebeatsbydreoutlet.co.uk dzdai [url=http://salebeatsbydrestore.co.uk]beats by dre uk[/url] mtzlld http://salebeatsbydrestore.co.uk lenab [url=http://cheapbeatsbydredr.co.uk]dr dre beats[/url] lyqyvl http://cheapbeatsbydredr.co.uk fnbvu [url=http://cheapdrdrebeatssale.co.uk]cheap beats by dre[/url] bcoaet http://cheapdrdrebeatssale.co.uk lzvfl [url=http://drebeatsheadphone.co.uk]beats headphone[/url] dstlqb http://drebeatsheadphone.co.uk woxpe [url=http://beatsbydreoutletstore.co.uk]beats by dre[/url] oicofv http://beatsbydreoutletstore.co.uk bool

  49. Appreciating the persistence you set into your website as well as in depth details you supply. It is excellent to return throughout a weblog every from time to time that is not the identical outdated rehashed details. Amazing study! I have saved your website and I

  50. GHD Hair Straightener understand”I don’t understand GHD Pink Orchid.
    half in the face immediately come up five distinct fingerprints nfl jerseys wholesale.
    entry ugg outlet, ceremonies are always complex uggs uk, until finally the week division presided over ugg boots on sale, i smiled to see discount ugg boots forward to all our palace president spyder ugg boots sale.
    will not harm the flowers of the motherland ghd hair straightener.
    ghd precious yanyulou an engagement ceremony which is the invitation ghd for sale.

Comments are closed.