• 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...


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.


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.


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.

    To do this first open up the table located in the navigation pane to the right like so: Once you have the table open, simply click on the record you want to delete, right click, and select the "Delete record" option like so: Again you will be prompted with a

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

    The problem is that because he has plenty of paperwork around the office he sometimes loses important documents as he has to store documents in folders which sometimes get placed in the incorrect folders. Also, since he has deliveries to make he tends to forget when deliveries are made and

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