• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36

Database Coursework – George Youngs Coaches.

Extracts from this document...

Introduction

Database Coursework - George Youngs Coaches Analysis Description Of Problem George Youngs Coaches is a local coach operator which specialises in National and International Coach trips. They have regular customers who organise tours through them, as well as customers who may only use them once or twice a year and people who use them for one off trips. They also do school runs for various schools around the Herefordshire and Gloucestershire regions. Ultimately they are left doing work for a lot of people, which has to be sorted to make sure they always have enough drivers to cover all the work they have. Some drivers however don't have experience abroad or can't drive certain vehicles, so they cannot do certain jobs. Furthermore George Youngs have to assure they have enough coaches to carry out the certain jobs, so they don't double book a coach or driver at any one time. Records are kept of all of the runs carried out on paper. This is a very tiresome method, especially when references are needed and monthly invoices are drawn up. Data kept includes customer and driver details, which is very sensitive information and needs to be kept safe. They need to also be able to find information very quickly, should they be talking to someone on the phone that urgently needs it, or whenever they need to post quotes, invoices or contact someone. The current paper based system makes it harder for them to search through lots of files, due to the sheer number and size of them. Organisation is another problem, because it is put back into the filing cabinet in no particular order and so is hard to find again. It is also impossible to get a copy of the data, because there is no photocopy machine available and if the information is needed, then the whole file is taken and on occasions can be left where it was taken and never returned. ...read more.

Middle

There are alternatives available. The Database section of Microsoft Works for Windows could have been used instead of Access or, straying from Microsoft products, another Office suite could have been used assuming it has a database program. These include The Lotus and Corel WordPerfect Suites. A spreadsheet program such as Microsoft Excel could've been considered, as similar results may be achievable. The only way to determine which was most appropriate was to compare all the Software available, trying out different features of it and rejecting software which would not meet the quota. Microsoft Access This was the initial first choice of software although I thought it would be appropriate to test all the options available. Microsoft Access been built up over the years and now offers a huge range if features including Tables with relationships, complex macros, running entire websites with the database acting as a 'central hub'. Although I will need to use some of the features, some will be useful and some will not. The standard features I need and must be available are tables that can draw information from one another automatically, the ability to input data easily into the tables and then recall it, in a printer friendly layout so that data can be taken or distributed where necessary. Microsoft Access incorporates all of these features with a wealth of options available for each one. It covers everything in plenty of depth and can create user-friendly interfaces with images and options similar to what can be commonly found on a webpage, and so users will be more familiar with what they are doing. Microsoft Access may seem daunting to anyone that may not have come across it before as he or she will not know where to start, so if Access is to be used then a large documentation will be required so as the user is not lost. Microsoft Works For Windows This is Microsoft's Integrated works suite, as it contains a Word Processor, Spreadsheet, Database and Contacts program. ...read more.

Conclusion

Field: Surname Data Type Text Field Size 50 Format Input Mask Caption Surname Default Value Validation Rule Validation Text Required Yes Allow Zero Length No Indexed No Unicode Compression Yes Field: Forename Data Type Text Field Size 50 Format Input Mask Caption Forename Default Value Validation Rule Validation Text Required Yes Allow Zero Length No Indexed No Unicode Compression Yes Field: Title Data Type Text Field Size 20 Format Input Mask Caption Title Default Value Validation Rule Validation Text Required No Allow Zero Length No Indexed No Unicode Compression Yes Lookup: Display Value Text Box Field: Vehicle ID Field Size Long Integer Format Decimal Places Auto Input Mask Caption Vehicle Driven Default Value Validation Rule Validation Text Required No Indexed Yes (Duplicates OK) Lookup: Display Value Combo Box Lookup: Row Source Type Table/Query Lookup: Row Source SELECT [tbl_vehicles].[Vehicle ID], [tbl_vehicles].[Registration Number] FROM [tbl_vehicles] Lookup: Bound Column 1 Lookup: Column Count 2 Lookup: Column Heads No Lookup: Column Widths 2.54cm;2.54cm Lookup: List Rows 8 Lookup: List Width 5.079cm Lookup: Limit To List Yes Field: Address 1 Data Type Text Field Size 50 Format Input Mask Caption Address 1 Default Value Validation Rule Validation Text Required Yes Allow Zero Length No Indexed No Unicode Compression Yes Field: Address 2 Data Type Text Field Size 50 Format Input Mask Caption Address 2 Default Value Validation Rule Validation Text Required No Allow Zero Length No Indexed No Unicode Compression Yes Field: Town Data Type Text Field Size 50 Format Input Mask Caption Town Default Value Validation Rule Validation Text Required Yes Allow Zero Length No Indexed No Unicode Compression Yes Field: County Data Type Text Field Size 50 Format Input Mask Caption County Default Value Validation Rule Validation Text Required Yes Allow Zero Length No Indexed No Unicode Compression Yes Field: Postcode Data Type Text Field Size 50 Format `w1 Input Mask >LL00 0LL;0;_ Caption Postcode Default Value Validation Rule Validation Text Required Yes Allow Zero Length No Indexed No Unicode Compression Yes ...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. Visual basic

    * Xor ==> Returns true only if exactly one expression is true, else returns false . * Not ==> Changes true to false and false to true. Sub Programs * Start coding by using either the Add Procedure dialog box or by typing the Sub procedure directly into the code window.

  2. Smart Card System

    Some people refer to E(K1,D(K2,E(K1,x))) as triple-DES. This method is intended for use in encrypting DES keys and IVs for ``Automated Key Distribution''. Its formal name is ``Encryption and Decryption of a Single Key by a KeyPair''. Others use the term ``triple-DES'' for E(K1,D(K2,E(K3,x)))

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

    I printed all the structures on a Lexmark Z31 color jetprinter. I also used a photocopier to copy my data collection sheets and for my questionnaires. Record Information Design Structure Design View Datasheet View Artist Title Year Price Quantity A1 Take me on 2000 �10.00 3 Architechs Body Groove 2000

  2. Describe the functions of each section within the shops and Head Office, paying particular ...

    on sale, reduce total price by 50% * display total on screen * if credit card = yes, generate credit card receipt for signature The form and content of any output * on-screen / display message * paper till receipt * paper credit card receipt * Contains prices.

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

    Hull is a competent Access user who does not have the available free time to produce a fully functioning system. His competency with Access means that the system can be quite sophisticated and I wont have to spend as much time making the system user friendly as he will be able to navigate Access with ease.

  2. Unit 6 - Advanced Spreadsheet Skills

    The range goes from small for �10, medium for �15, large for �20 and luxury for �25. All prices include UK delivery Lesco get a lower price which is small for �8, medium for �10, large for �14 and luxury for �19.

  1. Purposes and Features of a Relational Database

    instead of having to request entry and have the member of staff find the bit of paper with the data on. Purposes Manage Details and Data If a company has to use and manage data on a frequent daily basis, it is recommended that a database is used to manipulate, add, remove and check up on client details.

  2. Basic Database Building

    There are however some draw backs to this, the most notable being the fact that the switch board cannot contain more than 8 links to forms and reports. This is however avoidable but needs a certain element of underlying coding.

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