• 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

    in edusername and place into the field called username in an access table ADOuandpsetup ['Password']:=EdPassword.text take the text in edpasssword and place into the field called password in an access table ADOuandpsetup.post;//send the text Showmessage ('Your Username and Password has Been Saved');//showmessage username and password saved end; end; end.

  2. Different ways of data capture

    type of printer chosen for a job depends on these factors: * Volume of data * Quality of print required * Location of printer * Requirement for multiple copies * Requirement of colour Different types of printer are: * Dot matrix - very cheap, slow, noisy and poor quality *

  1. Computing Project

    15/03/2008 18:00:00 21347418 36 Burleigh Road, Loughborough, LE115DS Katy Buckland 15/03/2008 15:30:00 21547854 32 Oxford Road, Cambridge, CM115KP Lyne Payne 14/03/2008 14:15:00 22174895 6 Stewart Drive, Manchester, MN148SK Richard Talver 14/03/2008 08:00:00 22531484 78 Kerrysdale avenue, Rushden, NN83LB Anne Smith 14/03/2008 16:45:00 23597854 21 Albert road, Leeds, LD128FF John Smith

  2. CP3 - Proposed Solution to a Realistic Problem - Apartment Administration software

    Save any changes made before changing record inc(pos); // Add one to current array positio If pos > noofrec then pos:=1; // If new position is greater than the amount of records in array then positon = 1 showrecord; // Show this record end; procedure TFormCustomers.BTdelClick(Sender: TObject); begin If pos

  1. Definition-nature of the problem solved - Car Mechanic business

    This leads to a great deal of memory being used up by the system. With a very large amount of data the system may become slower because of the number of details being processed all at once. Solution 3- with a spreadsheet having a number of more complex inputs such

  2. ICT Sample Work Welcome Centre Requirements

    Customers use the services provided by the Welcome Centre for various reasons from large conferences, to small meetings and training days. 2. Who are the staff at the Welcome Centre and what do they do? Tony Williams is the General Manager, whose role includes creating the rota of when his

  1. ICT Sample Work India Red

    John Thompson is the reception worker, who takes order therefore he will fill in the order form once created. IDENTIFICATION OF ANY AUDIENCE The Audience is anyone who may look at the outputs, but not change the content of the solution.

  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