Test Methodology Summary

Application or System Testing   

When conducted properly, should follow a logical progression of test phases, where each subsequent phase builds upon the proofing provided by the former phase(s)

Order of Test Phases

 Unit >>
  Smoke / Sanity testing >>
    Integ >>
      Func >>
        System - Functional and Non-Functional >>
          Perf >>
            Regression >>
              UAT >>
                Pilot/Field >>
                  PVT 

Purpose of Test Phases

• Smoke or Sanity
  ** Non-extensive software testing, makes sure that the most crucial functions of a program work, but not bothering with finer details.
  
• Unit
  ** Verify individual hardware or software units
• Integration (Integ)
  ** Verify inter-unit and external interfaces
• Functional (Func)
  ** Verify small groups of units and their interface ability to perform specific system and process functions
• System (ST)
  Verify the complete system meets Func and Non-func Objectives and Requirements
  Functional ST includes: External Interoperability of all data and control elements
  Non-functional ST includes: Useability, Reliability, Efficiency, Portability, Maintainability
• Performance (Perf)
  Covers Load, Volume, Stress and Exception testing
• Regression
  Ensures that changes have not adversely affected the pre-existing system(s) or application(s)
• User/Acceptance (UAT)
  Validates the complete and integrated system against acceptance criteria and customer expectations.
• NOTE: Acceptance criteria are arrived at by aid of the System Requirements Specification (SRS), the Request For Proposal (RFP) and/or the Integration Test Plan (ITP)
• Pilot/Field
  Verifies the complete system co-operates with business processes and workflow, to meet stakeholder expectations in a production-like environment.
• Production Verification (PVT)
  A repeat of the Pilot testing but under full production and business conditions

Test Phases Explained

• Smoke/Sanity Testing: Performed by developers before releasing the build to the testing team.
  May also be performed by testers to decide whether to accept the build for further testing or not.

Got an Excel automation Question?

Can't get an Excel formula to work?

Cant' get some Excel VBA right?

Got a spreadsheet problem to solve but can't quite figure out how to go about it?

Want to do some fancy Excel filters, lookups or formatting?

I use VBA extensively (and an occasional recorded macro!), to perform some fairly complex system integrations and automation of data Extracts, Transforms, Loads and Informs, using  Excel, Access, Word, Outlook and a range of legacy applications.

Ask your question in the comments and I'll see if I can solve it for you.

MS Access questions here