• 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 Ulogin; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, DB, ADODB; type TFMLogin = class(TForm) EdUserName: TEdit; EdPass: TEdit; Label1: TLabel; Label2: TLabel; Label3: TLabel; Btnlogin: TButton; ADOuandpsetup: TADOTable; DSuandpsetup: TDataSource; procedure BtnLoginClick(Sender: TObject); private { Private declarations } public { Public declarations } end;

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

    database will consist of four forms for data entry and five for navigation, product information and customer information. I will first give a description of the data entry forms with screen shots where necessary. Form name: Customers: This form will be where new customers can be added to the system and where existing customers details can be updated and amended.

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

    the business to pick up its revenue and hopefully bring in more money. Ben Allington - And how exactly are you planning to do that? Mr Brookes - Well I have already made the first stage into the process by investing a sum of money in the development of a

  2. ICT Sample Work Welcome Centre Requirements

    * Search for and display information entered automatically, so that the user does not have to keep flicking between different screens to remind themselves of prices or what they have previously entered. * Automatically calculate certain fields to save time and to reduce data input.

  1. ICT Sample Work India Red

    There are several other employees. Sachin Patel, Ahmed Patel and John Thompson. Sachin and Ahmed are also responsible for order taking and calculation of prices but they are also responsible for rechecking of details and producing invoices. They are both assistant managers, Sachin's main responsibility is keeping track of expenses

  2. Computing Project

    [StudentID] Null Erroneous Data Error Message, please enter number AS EXPECTED 4. [Name] Sean Ensure data entry possible 'Sean' Stored AS EXPECTED 5. [Name] 'aaaaaaaaaaa' Extreme Data Data Stored AS EXPECTED 6. [Address] 125 Buckingham Avenue. Ensure I can add address Data Stored AS EXPECTED 7.

  1. Computing Module 3 Writeup

    Unload Me End Sub Private Sub Form_Load() datCentre.Recordset.AddNew End Sub Public Function Validate() As Boolean Validate = True If (txtCentreNo.Text = "") Then MsgBox ("Centre number has to be entered") Validate = False Exit Function End If If txtCentreNo.Text < 10000 Then MsgBox ("Centre number must be between 10000 and 79999")

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

    All files are separate to the program. Password file The password file will hold just 2 usernames and passwords which will allow the users of the program to logon. To deter and prevent hackers the file will have to use a filename which has will not attract attention to it.

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