Teddington Tennis Club Essay Example | Topics and Well Written Essays - 1500 words

Teddington Tennis Club - Essay ExampleThe mark basically offers two options for the user. One, to view previous outgrowths and two, to compute results online. Initially, the user has to choose on the family of competition, then the week and finally the teams to play for that week. From here the option varies. The user can either view the results if the year selected is in the past or else can update the results for present and future games. This is done by virtually hiding all the controls present in the form until the user clicks on the appropriate buttons which are View and Update (the names are self-explanatory). This is done by marking a tag to all these controls and backcloth their visible property to false. A sample piece of code is shown below.Once these are decided, the user can select the GO button, to view the result input boxes filled with players names adjacent to them. Once the user fills and clicks on Save, the data gets stored in appropriate tables. The query use d to update these determine is given belowThe creation of the financial report detailing the players who are members for current fiscal and those who do not basically depend on the data available in the two tables namely, Members and Players. These tables contain details regarding the players, their member ids, and their membership details. The report is created using the Report Wizard of MS Access which lists out the cogitation that need to be presented in the report in addition to the variables based on which the report has to be ordered.The report is generated by analyzing the value of the Members table field column, current which mentions whether the player is a member or not. If the value for a member id is Y, the player is a member and if N, the player has to regenerate is membership. Based on the member ID and Player Id relationship, the player details are obtained from the player table. An example of the report that was generated for the current year is shown below.