Looking for Access Test Plan database template

Posted on 2011-02-17
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
  • 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.


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?

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

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 500 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

758 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now