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

Implementation of a switchboard.

Extracts from this document...

Introduction

Implementation Here is my switchboard. I have hid border margins and other abilities so the user focus's on the switchboard and nothing else. I used the main colour as green because the Peterborough City Council logo is usually green. I have created 4 buttons, which all use either a recorded macro or some VB coding. Here are the recorded macros: And here is the coding for my "exit" button on VB: When clicking the application form it goes straight onto my user form called "application form". ...read more.

Middle

shown here: Here is some of the coding my user form (application form): For my next button called "Contact Details" on my switchboard I used a recorded macro. When pressed this button brings up another user form called "Contact Details" as shown here: I chose a user form instead of designing it on Excel itself because I thought it looked a lot more professional and presentable. I didn't use much VB coding for this, only for the "OK" button which then exits the user form. ...read more.

Conclusion

There is 2 recorded macro buttons. "Back" goes back to the switchboard and "Print" prints a copy of the database. Information is automatically stored into this database as soon as the user presses send on the application form as already shown. I used simple VB (Visual Basic) coding to get the data to be layered row after row. Here is the coding for this: When pressing the "Exit" Button on my switchboard it closes AND saves the database and the whole program. As shown here: Overall I used a lot of VB, to edit and use codes to make my system work. ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. User Guide to my minibus hire database.

    How to print data When dealing with forms there is no real need to print off any of the forms as most of the data on a form is put into a report anyway. The report you will be wanting to print will be the receipt report, to print this

  2. Cunha & Ribeiro Ltd: Stock Control & Invoice Database

    cannot keep records of deliveries because he doesn't have an efficient diary system, as well as occasionally forgetting clients details because he does not have an efficient system for storing client's addresses. Furthermore, he has to write all of the invoices for the customers by hand which is both time-consuming as well as being a hassle.

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