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

Video Club Database Project

Extracts from this document...

Introduction

Oceanic Video Club is a private business, run by its owner Mr. Michael Coleman. Oceanic is a video club which is in the selling of films. The owner Mr. Michael has built up a large customer base and this is increasing year by year. The business is going well as the amount of clients is increasing. As Mr. Michael hold a list of customers on a paper-based filling system, so Mr. Michael does not worry about the client as they are being informed automatically. Consequently, he has decided to make an investment on a comprehensive customer information system so that he can hold details on his customers, who have been purchasing films in the last few years and now. Also to take their opinions about the video club so that he can offer his customers a better service. . o An interview with Mr. Michael was arranged. These included: > The objectives of the business. > The precise objectives of the new system. > The method currently used to record data. > The information that needs to be kept on each customer. > Any hardware or software constraints. > The required output. > The volume of data to be processed. > The problems with the new and manual system. 1. How many employees do you have? 2. Do you sell on credit or cash? 3. Do you have any problems with debtors? 4. What are the expenses which you make each year? 5. What types of music do you sell? 6. Do you own or rent this place? 7. What problems do you get with the manual system? ...read more.

Middle

* Add a new Customer. * Look though all the existing records for the current Customer and bring up more details if necessary. The Customer details form will be as shown on the next page. This form will be used for several purposes so it needs facilities to * Check to see whether music is already on the database. * Add a new music * Look though all the existing records for the current music and bring up more details if necessary. The music details form will be as shown on the next page. Customer File FILM File The format of all the reports will be similar. The layout of the Customer report is shown below. The menu structure is as follows: A password will be attached to the database so that it is only accessible to someone who knows the password. Different access levels are not needed as Mr. Pascal is the only person who will be using the database. 9. Test Strategy The test strategy will include five different types of testing as described below: LOGICAL TESTING This will be used to test every aspect of each form, report and query as soon as it is implemented, using valid, invalid and extreme data. Test data will be added to test each code module and results compared with expected results. Sufficient data will be added to ensure that there is at least one customer in each category. The test data that will be added initially is shown in Appendix. Subsequent test will often involve adding new data, which will then be deleted when the test works satisfactorily. FUNCTIONAL TESTING Each menu item will be tested in turn to ensure that no function has been missed out. ...read more.

Conclusion

On Error GoTo Err_Exit_Click DoCmd.Close Exit_Exit_Click: Exit Sub Err_Exit_Click: MsgBox Err.Description Resume Exit_Exit_Click End Sub FilmFile Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click DoCmd.GoToRecord , , acNewRec Exit_Add_Record_Click: Exit Sub Err_Add_Record_Click: MsgBox Err.Description Resume Exit_Add_Record_Click End Sub Private Sub Delete_Record_Click() On Error GoTo Err_Delete_Record_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_Delete_Record_Click: Exit Sub Err_Delete_Record_Click: MsgBox Err.Description Resume Exit_Delete_Record_Click End Sub Private Sub Save_Record_Click() On Error GoTo Err_Save_Record_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Exit_Save_Record_Click: Exit Sub Err_Save_Record_Click: MsgBox Err.Description Resume Exit_Save_Record_Click End Sub Private Sub Film_Report_Click() On Error GoTo Err_Film_Report_Click Dim stDocName As String stDocName = "Film Report" DoCmd.OpenReport stDocName, acPreview Exit_Film_Report_Click: Exit Sub Err_Film_Report_Click: MsgBox Err.Description Resume Exit_Film_Report_Click End Sub Private Sub Back_Click() On Error GoTo Err_Back_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Main Menu" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Back_Click: Exit Sub Err_Back_Click: MsgBox Err.Description Resume Exit_Back_Click End Sub Customer File Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click DoCmd.GoToRecord , , acNewRec Exit_Add_Record_Click: Exit Sub Err_Add_Record_Click: MsgBox Err.Description Resume Exit_Add_Record_Click End Sub Private Sub Delete_Record_Click() On Error GoTo Err_Delete_Record_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_Delete_Record_Click: Exit Sub Err_Delete_Record_Click: MsgBox Err.Description Resume Exit_Delete_Record_Click End Sub Private Sub Save_Record_Click() On Error GoTo Err_Save_Record_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Exit_Save_Record_Click: Exit Sub Err_Save_Record_Click: MsgBox Err.Description Resume Exit_Save_Record_Click End Sub Private Sub Customer_Report_Click() On Error GoTo Err_Customer_Report_Click Dim stDocName As String stDocName = "Customer Report" DoCmd.OpenReport stDocName, acPreview Exit_Customer_Report_Click: Exit Sub Err_Customer_Report_Click: MsgBox Err.Description Resume Exit_Customer_Report_Click End Sub Private Sub Back_Click() On Error GoTo Err_Back_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Main Menu" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Back_Click: Exit Sub Err_Back_Click: MsgBox Err.Description Resume Exit_Back_Click End Sub ?? ?? ?? ?? 1 ...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. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    We are advocates of Interactive Prototyping, especially in combination with business analysis and user feedback sessions. However, there are times when the use of alternative approaches makes more sense. Benefits of Software Prototyping The main benefit of software prototyping is in obtaining feedback on a proposed design at an early stage in a project.

  2. Computing Project

    The system must be able to assign rented DVD's to people who have borrowed them * The system must also print out a receipt for the customer * The system must also be able gather a list of all loans which are overdue and be able to print this list

  1. System I designed in order to produce a promotion package for her newly formed ...

    I received feedback from my family, friends and relatives. I later typed the data up in Microsoft Access. The table is shown below: Customer ID Last Name First Name Gender Birthdate Place of Birth 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

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

    Evaluation: I will evaluate the system I have made based on the performance criteria outlined earlier in the design section. The first criterion was to be able to enter a customers' full details within 20 seconds. After trying and timing my self the best time I have been able to achieve is 18 seconds.

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

    Worktops --> Worktops Test Two - Image Loading This is what I am testing: Do all the product images load up correctly.

  2. Computing Project

    Will you be the only user? Yes I will be the only user to access the details and your software, it would be necessary to have it password protected for data protection purposes. Can you use software such as access to input and view data? Yes I have had training on this, this is what they

  1. Analysis of Johnson Music

    * Human error can be a problem, with staff possibly forgetting to change the stock levels of products being sold, or possibly forgetting to order more of a certain product in when it has been sold out * Searching through paperwork can result in papers being misplaced, and can be

  2. Basic Database Building

    So in my case the most relevant information that needed charting was the equipment that had been used, this could actually however have been on many things, * Chart on peoples ages * Chart on what membership type people have * Chart on location lived All of these would have

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