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

Using Microsoft Access to computerise and store information.

Extracts from this document...

Introduction

Introduction In this IT project I am going to use access to computerise and store the information in my faculty for my tutor who is the faculty head. This will make it much quicker and easier for my tutor to access and update information on all the students. She will be able to add new students to the class, edit students details (address etc) keep up to date with student progress etc. and to have a whole picture of her tutor group and their subjects and progress. The project is based in Richmond Upon Thames College where my tutor - Kate Lane works as an IT and computing Teacher. She needs to keep up to date with the progress of all the students in her faculty so that she can monitor their progress and take any action if needed. In order to be kept informed with what her students are doing and how they are progressing she needs to have large amounts of information on each student on their subjects, grades, level of education, level of education (A level, GCSE) etc. This is difficult with paperwork and very difficult to make amendments and not very user friendly, as it is very tedious. ...read more.

Middle

This needed to be corrected with the new system. Also available for use at the college are Pentium PC�s running Windows 98 and a laser jet printer. The Windows system comes installed with Microsoft Office and includes all the major programs (Word, Access, Excel). Since all this is available to Kate Lane, and she is familiar with computers and their programs she has asked/recommended for me to design the new system in Access. She feels that a database would be the best way to tackle the problem as information can be gained quickly and efficiently and large amounts of data can be stored. Problems with the current system Before every time when a students report was written or they had some other form of assessment Kate lane had to record these results and file them away for use in the future to compare the students progress in the different subjects in the future. As the time came round to review the students progress, a few weeks after each report Kate had to search through all the documents of all the students to find the information on the particular student that she was looking for, and often many of these documents got mixed up, which meant that even more time was wasted trying to sort out the mess. ...read more.

Conclusion

Data Flows A data flow diagram of the parts of the proposed system is shown below: Students Details Tasks Kate needs to store the students, ID, name, address, name of parent, telephone number, sex and date of birth on a personal information table. Apart from this tables are needed on which subject the students are studying. Each subject has to have a code and a subject name. She also wants the level being studied and the year (1,2). The system that is going to be created needs to consist of several tables and forms so that Kate is able to: Create, delete and amend records. Input forms are needed which allow her to enter details about students, including which subject they are doing in which module and their current grade. To make this easier look up tables will be used so that she can pick the appropriate subject from a list of subjects from the class/subject ID. She wants a record of the students target minimum grade and current estimated grades for each subject so that she can monitor their progress. Any other items which are not mentioned but may have to be designed in order to make logical sense of the data base will be included in the appendix ...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 ICT in Business 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 ICT in Business essays

  1. UNIT4: PRESENTING BUSINESS INFORMATION

    Operational decisions tend to be highly structured. Role of management To manage is to forecast and plan, to organise, to command, to coordinate, to improve and to control. Planning This describes the formal procedures used in such an endeavour such as the creation of documents, diagrams or meetings to discuss

  2. Business Aims and Objectives.

    Enquiries can be received over the telephone, by email or in person. All enquiries must be answered promptly with the correct information, regardless of other priorities. Administration staff may answer enquiries themselves or pass it on to the relevant person.

  1. Business report on Marks and Spencer.

    21.1 Lap top computers The development of portable computers mean that Marks and Spencer business people can work, in different locations to their office. They allow people to continue working during train journeys, for example, and to e-mail text and image to other via satellite link.

  2. The purpose of this document is to define the Context of Cain Motors Information ...

    as Supporting Documentation: Signature: Date: _______________________ ___/___/____ PLEASE FORWARD TO THE CHANGE MANAGER FOR CHANGE APPROVAL GROUP SUBMISSION Change Request Form Change No: 3 Business Area: Estimate Change Requestor: Mr Cain Project Name: Cain Motors Change Request Date: 22/02/03 Project Manager: Mr Shirley Change Urgency: Low Change Manager: Mrs K

  1. The Use of Geographical Information Systems (GIS) And International Technology Transfer by Non-Governmental ...

    up in 1994 and has secretariat at the Geographical Survey Institute in Japan (Masser1999). 5.6 WHAT GIS PRODUCTS DO PRODUCTS MATTER Hastings and Clark (1991) identified some capabilities of GIS products that are needed especially to assist the development of an African GIS community in particular and other GIS community outside Africa at large.

  2. Implementation of ATMS at SBI. Banks in India are looking at deploying biometric ATMs ...

    � Journal Printer: This printer records all transactions / events, taking place in the ATM system. � Receipt Printer: Used to print transaction receipts, mini-statement of account, account balance, etc. � Safe: All the above units are secured within a URL safe.

  1. Free essay

    Managing information

    Disadvantages The data may not be accurate; who did it and it would need checking and may take time to do so. It can be out of date and it may not be specific to your exact problem. Secondary data has a lot of limitations and disadvantages, the limits is

  2. A proposal to modify "Exercisco Fitness Club" in Pokfulam, the location has been proposed ...

    properly and easy to use to the business, this can only be done after the system has been tested, plus the evaluation process sees if the system as met the requirements set by the client. The evaluation process also shows if the system can be developed or improved further and if it needs any modifying.

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