Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Looking for Access Test Plan database template

Posted on 2011-02-17
Medium Priority
Last Modified: 2012-08-13
Can someone point me to a sample/template of an Access 2007 Test Plan database.  I am in the beginning stages of converting multiple Access 2003 databases to 2007.  I was hoping to find an example/free download of a Test Plan Database I can use to establish and track my Test Plan for each of these databases I need to convert.  I found the Bug template at MS website, so I was hoping that there is template for creating a Test Plan.

Question by:Karen Schaefer
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34921537
I don't know if anyone would create a free template for something as complex as Software test Plans.

Why reinvent the wheel?

Why not buy one of the many packages available off the shelf.

This can potentially be a tremendous undertaking.
IMHO, doing this from a template in MS Access may be more headaches that you would want to deal with.




Author Comment

by:Karen Schaefer
ID: 34921603

I am not looking for a complex Test Plan - I am looking for more of a Log of issues and steps to following while click on every button/form/table, etc within the old A2k3 versions running in the A2k7.  To track issues/bugs and resolutions along with steps to follow with similar databases to be converted.

I have looked at the Bug template and the Issue Template that is offered from MS on A2k7 versions, however, they both single do not cover my needs and with time being short I was hoping for a template like those mentioned that might be assistance to me with little modification..

Thanks for you input.
LVL 21
ID: 34921667
I actually use the free ToDoList app for my projects just like what you are doing.

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

by:Karen Schaefer
ID: 34927222

Thanks for the link, I was wondering is there a way to move the columns around within the tool?

LVL 21
ID: 34927505

Don't know if it is possible. I have never try to move the columns around.  


Author Comment

by:Karen Schaefer
ID: 34927557
Thanks for the suggestion, however, I was hoping for an Access Database, this way I wouldn't have to learn a new tool.  I guess I will have to create one myself - since after my 2 days of searching have not been able to find any good examples to fit my needs.

LVL 21
ID: 34927996

I know you want to something in Access. Unfortunately I don't thing you will find anything Access based for free that will be very close to your needs. If it must be Access based then you will probably have to create your own.

If you do consider a none Access based solution then there as some free/open source alternatives:

I would look at this Open Source/Free: project management solution  

How I started using ToDO List::
Years ago I to was thinking about creating an Access application to tracking software projects.I decided fir4st to do some research to see what was already available.   Most were very expensive. I tried some demos just to learn about how they worked. I also ask around. I heard about several Task manages also.  Someone suggested trying out the ToDoList. I tried it on a small  project.   I found it very easy to learn and use.  So easy in fact I never stopped using it. Today I have been using the ToDoList for projects for many years now. I never did go back to take the time or money to write my own.

Author Comment

by:Karen Schaefer
ID: 34928075
Thanks again for the suggestions, however the project management solution would be to complicated for my needs - since I will not be having a team of people assisting me with the project - it will probably be me, myself and I and hopefully 1 other person.  I was looking for a tool that would allow me to write the step by step play of what to test, note any issues and then track and fix issues.  Since most of my databases are various versions of the original is why I want to create some kind of check list or test plan without getting to elaborate.  This is why I was looking for the non-existing template that I could modify without to much effort.

Thanks for all your suggestions,

LVL 21

Accepted Solution

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 2000 total points
ID: 34928386

Sounds like a good plan to me.

This might help: Project Management Template

A side note:
There are some great tools to help with this type of project.   I would check out the tools at FMS Inc . The Total Access Analyzer will probably help you a lot. You can get the 2007 version and run it against your 2003 MDBs.


Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question