• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Testing Database

Extracts from this document...

Introduction

Testing Testing strategy The basic objective of testing the system is to ensure that everything is working as expected. During the testing we should look out for the following: * Macros should work as expected * Queries should run and return accurate outputs (and store required information property where appropriate) * Forms should display fields correctly * Command buttons should run actions as expected * Report should be printed correctly * Input should be validated correctly where appropriate * Required fields should not be empty. System should detect required fields that are empty The testing of the system will be divided into 3 parts: * Functional - the testing of individual components of the database. This is done when the component is created and will be documented in the implementation * System testing - the testing of the full system from beginning to end. ...read more.

Middle

6 Queries Run all queries in the database All queries in database should run smooth and display the correct data Evidence of Testing Test 1: Switchboard & Switchboard Options Switchboard should load as expected The command buttons opened the correct forms as expected Test 2: Add/Edit customers details in Company's Add/Edit customers details in Company's Record 1: A new record was added and saved correctly to the tables as expected. Record 2: When erroneous data is entered (Postcode was missing 3 characters) the system validation rule showed the following message Record 3 When erroneous data is entered (a mobile number, four digits short) the system validation rule showed the following message. Record 4: When trying to enter extreme data the form (typing "adfgrthjs" into the company phone) The system will not allow me to as I expected. ...read more.

Conclusion

Edit Record 2: When I edited the "Prop data" in record 2, the cells allow me to edit dates and save them as shown below of the Wants table: "Add/EditWants_Exit", marco opened and closed the correct forms as expected. Test 4: Command buttons in the user interfaces Frm company interface The frmCompany loaded as expected All my command buttons in "frmCompany" worked and carried out all tasks as I expected. When manually clicked Interface of frmCampaign All the command buttons in "frmWantsCampaign" worked and carried out all tasks as expected. When click manually clicked. Test 5: Add/edit Wants and campaign Record 1 When editing Wants and Campaign a new record is added Record 2 When adding a text which is not recognised by the system 'Microsoft Access' detected it and a validation message appeared. Test 6: Queries I ran all queries and they run smoothly. Below is a screen shot of all queries. ?? ?? ?? ?? [Type text] Eyram Tetteh Candidate No: Centre No. 12125 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Information Systems and Communication section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Here's what a star student thought of this essay

4 star(s)

Response to the question

The report shows the user clearly testing the database, and explaining why it's necessary for the user to carry out tests on the database. However, in some areas, there could be an improved level of detail. The testing plan states ...

Read full review

Response to the question

The report shows the user clearly testing the database, and explaining why it's necessary for the user to carry out tests on the database. However, in some areas, there could be an improved level of detail. The testing plan states a number of key areas where the user is going to test, these are clear and straight to the point.

Level of analysis

When the user was testing the database it may have been useful if the user were to note down the process in more length in undertaking the test. At this stage, the report states what the test should achieve, and whether the test is successful or not. For higher marks, the report could mention the process taken to test the aspect within the database.

Quality of writing

The report clearly states each of three parts of testing the database. The terms 'Functional', System Testing' and 'End-Use Testing' are all explained thoughtfully, and it's clear that the user understands how to test a database using these three aspects. Some of the presentation of the screenshots of the database, could be improved a little. It does appear a little messy and can be quite confusing to follow.


Did you find this review helpful? Join our team of reviewers and help other students learn

Reviewed by danielbeal 18/02/2012

Read less
Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    These formal methods are referred to as "System development life cycle models", and the model that I will be following consists of five main stages: System Investigation, Analysis, Design, Implementation and Review The first thing I will do for my project is the conduction of preliminary investigations into Fred's Car Rentals' current system.

  2. Marked by a teacher

    E-Commerce Laws and Legislation - The Data Protection Act

    4 star(s)

    The bank will then have to chase the customer for the payment instead of the business. The consumer credit act also guarantees customers a cooling off period in case they change their mind about a product. For mail order this has to be at least 14 days - however companies

  1. Marked by a teacher

    I have been asked to create an ICT solution for a local events and ...

    The problems which I have pointed out need to be solved as soon as possible, so that business can expand. For my solution to the advertising issue which I have pointed out in the above paragraph, will benefit the client in many ways.

  2. ict as level coursework

    Fruit Lip Balm Organic lip balm Max Moisture lip balm Quantity Desired number of product wished to be purchased. Number will show up on invoice Cleanser Drop down menu of available cleanser will be selected by user. Makeup removal cleanser Dry Skin cleanser Light non greasy clenser Quantity Desired number of product wished to be purchased.

  1. A2 ICT CouseWork

    Pages, and this will differ depending on who's buying it, so we are going to display our advert on both Booklets to reach all audience's. Billboards we don't just promote our business on the Thompson Local and Yellow pages we also use other methods of Advertising our Business Locally.

  2. Threats to Data

    they can ring you up and try to sell you something or your e-mail address so they can send you spam. A large organisation will employ many people and it cannot be sure that they are all honest. The data held gives the less honest members of staff an opportunity

  1. Implementing a new system for Mastercare.

    Your Name:_________________________________________________ 2. Name of the company you work for:_____________________________ 3. Your Job Title:_______________________________________________ 4. Is your current system computerised or manual? (Please Tick) [] Computerised [] Manual 5. What are the problems with the current system that you use?

  2. Communication & Employability Skills for IT. OCR Cambridge Technicals Unit 1 LO1-P1

    The speaker must use vivid language to insure that the listener doesn?t get confused. The speaker needs to minimalize their use of slang words. Numerical Skills- This is having the ability to add figures to a speech or to normal work, an employee must have basic numeracy skills Computing Skills-

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work