• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7

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. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    What firms supply the business with the vehicles? 15. Do you store details on the suppliers? If so, what details and how are they stored? 16. What is the average rental price for a vehicle? 17. What is the lowest rental price, and the highest rental price?

  2. User Guide to my minibus hire database.

    To run this query you will need to be on the minibuses form and click on the button "search for buses hired between dates" like so: Once you have clicked this button a parameter box will then appear which will ask you to type in the start date and then

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