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

Testing to see whether the macro Enter New Data and Event Records work

Extracts from this document...


Testing Testing for Menu 1a and 1b Testing to see whether the macro EnterNewData and EventRecords work Above is the sheet from which the macros run, below are the two sheets to which the macros take the user. 1a 1b 1c and 1f These are password protected integrated macros, the same happens for each macro if the password is incorrect (the running of macro 1e) but depending on which macro is run the user will be taken to a different sheet if the password is correct (1c runs 1d and 1f runs 1g). The two macros run from the same sheet as 1a and 1b. When run both bring up the below left screen. If an incorrect password is entered then 1e is run. 1c and 1f 1e If the correct password then 1d and 1g are run and the two screens below appear. 1d 1g Testing for Options The above sheet is the sheet from which all of the 2 macros run. ...read more.


2i This macro is found on every sheet except for the main menu, this is because it takes the user from anywhere to the main menu screen, a before and after shot will be needed Before After Testing for LookupMenu 3a Takes the user to table Starter on the sheet "LookupMenu". A before and after shot will be taken. The test proved the macro to work correctly. 3b to 3f All of 3b to 3f perform the same function as 3a, screen shots will not be taken but the results of the tests will be input on the table below. Module Before After Was Test Successful 3b User is on the LookupMenu screen User is on the LookupTables sheet and centred on the Meal table Yes 3c User is on the LookupMenu screen User is centred on the Dessert table on the LookupTables screen Yes 3d User is on the LookupMenu screen User is centred on the Wine table of the LookupTables screen Yes 3e User is on the LookupMenu screen User is taken to the Decoration table on the LookupTables ...read more.


Any tests which are failed will be noted and a reason or explanation suggested. Before Extreme Data (Low) Incorrect Data The cells B24 and F24 are not protected against text being input so the formulae that use these cells do not work, this is not a problem with the formula but a problem with the validation of the sheet. 4d Tests on the lookup functions within the sheet such as those involved in the Combo Boxes and the formulae associated with them i.e. the INDEX formulae. Two screen shots will be shown, both of the sheet at different stages of testing, a shot showing the sheet before the testing will not be needed as this exists already in other modules. Any faults found will be noted. Testing for EventRecords 5a This test is to see whether the macro PrintLine works as specified. This test could not be performed as the macro has not been written yet. On completion of the macro it will be tested as planned. Daniel Heaton AS Level ICT Project 2002 ...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 Computer Science section.

Found what you're looking for?

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

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 Computer Science essays

  1. Computing Project

    unit URegisterMember; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, ExtCtrls, Grids, DBGrids, DB, ADODB, DBCtrls, Mask; type TFmRegAMem = class(TForm) ADOMembers: TADOTable; DSMembers: TDataSource; DBMembers: TDBGrid; LblEdForename: TLabeledEdit; LblEdSurname: TLabeledEdit; LblEdHouseNumber: TLabeledEdit; LblEdStreetName: TLabeledEdit; LblEdTown: TLabeledEdit; LblEdAddNotes: TLabeledEdit; BtnNewMember: TButton; DBNavigator2: TDBNavigator; Label1: TLabel; Button1:

  2. ICT Sample Work Welcome Centre Requirements

    The Welcome Centre staff will use it to know what they will charge Customers for a particular booking, and it will therefore serve as the basis of the invoice. Customers will use it to know how much they are likely to pay for an event if nothing changes on the day.

  1. Computing Project

    Once that is selected at the screen below will appear, there are no details at the moment, but once show details button is pressed all the details will appear. The instructor now needs to press the back button until he arrives back at the main menu, and then select availability details.

  2. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    so that Mr Hull can compile each customers individual order from the available stock. After each order has been assemble customer-shipping labels will have to be printed by the system as this would save a lot of tedious hand written work.

  1. Ilford Cricket Team Data Analysis Project.

    use the system to analyse data from a match and pass the information to his captain to act upon it. The coach will need full access to the system because he will need to input information into every part of the system.

  2. AS ICT Corsework - Mr Brookes K-Fit Ltd

    Link - Worktops Worktops <-- The hyperlink worked correctly first time resulting in no need for re-testing Although I decided to change the roll over colour for my links from green to light grey to make the website aesthetically better.

  1. ICT Sample Work India Red

    India red is a bar and an Indian cuisine restaurant that was launched last year (2008) in December. It has been very popular with Asian customers. We have been getting very good feedback from them. 2. Who are the staff at India Red and what do they do?

  2. Computing Module 3 Writeup

    Presence Check Required = Yes Validation Of Data Entered In Visual Basic: For entering data to the Add Centre Form, I used the following validation: Private Sub CmdAddCen_Click() If (Validate() = True) Then datCentre.Recordset.Update datCentre.Recordset.AddNew End If End Sub Private Sub CmdCloseCen2_Click()

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