• 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

Fab Food Pix I.T. System

Extracts from this document...

Introduction

Coursework 2 Choice of Problem: I have noticed that at Fab Food Pix, photographic library, a manual filing system is used, I feel they would benefit from having a computer version running help save both time and effort for the receptionists. I have chosen to design and implement a database for Fab Food Pix, Photographic Library. At present Fab Food Pix stores client information on paper, in a manual filing system. The aim of the project is to explore the advantages and disadvantages of computer and paper filing systems to find to most profitable and use it to store the client information in a more beneficial way. The particular problem, which is to be addressed, is that Fab Food Pix stores all client information on paper. Description of Problem: A computerised filing system will help potential users by being more accessible - particular records can be found quickly and easily without having to search through filing cabinets and papers. Also, one computer can store more information than 8 filing cabinets therefore computerised filing systems take up less space. A computerised filing system will store all the specified information in one place, so there will be no need to go from room to or search through numerous cabinets to find the desired information. As well as information being quick and easy to find, searches can be carried out instantaneously rather than having to wade through many manual records. This particular problem is interesting as it provides an opportunity to analyse the information, design and implement different ideas, also to develop, refine and then proceed to test and evaluate the ideas. Feasibility: Advantages of a computerised filing system over a manual filing system: * Easy to access particular files and records * Doesn't take up a lot of space * Easy to edit previously entered information. * Terminals can be used; so many people can access the same information at the same time. ...read more.

Middle

Quad Speakers and Headset and Optical Mouse and a 56 Kbps V90 Modem. The software, which could be used to design the database is; Microsoft Word 2000, Microsoft Desk Top Publishing 2000, Microsoft Excel 2000 or Microsoft Access 2000. The computer that will be used in the work place will be a Power Mate I-Select XL2 P1400. This computer has an Intel Pentium 4 Processor with 1.4 GHz, 128 MB RDRAM and a 40 GB Hard Drive. It has 17" NEC CRT Monitor (15.7" viewable) a 10/100 MB Network Card and a Software Package. Although four programs have been mentioned, only one program can be used to create the database. So, I will now proceed to investigate the different types software mentioned to find which is the easiest and most effective to design, implement and use. I predict that word will not be exceptionally beneficial when used to create a database as it was preliminarily created as a word processor. Any database that is created is in the form of a table, in which no searching or sorting can be done. Microsoft Word 2000: Name Address Direct Line Company No. Company Amount Paid D. Smith 34 High Rd Finchley N23 GHI 0207634523 02078964050 Radius �14,000 P. O'garro 10 Low St Highgate N34 BFG 02096541233 02074456879 Dragon �17,500 T. Hill 9 Middle Av. Crouch End N76 SKH 02074321899 02086751235 Findus �23,900 This database was complicated to create and it is not possible to type in for instance, T. Hill and for the computer to then search and display the fields connected to that particular field. So, therefore, my prediction was correct and Microsoft Word 2000 is not appropriate to use in order to create a database. The same is true for both the desktop publishing (Microsoft Publisher) and the spreadsheet programs, on the desktop publishing and word processing programs little can be done in the way of sorting the data for both these programs. ...read more.

Conclusion

The validation rule for the Client ID field is 'Auto Number', this means the computer will automatically fill in this field with a unique number, there will only be one each number. This rule prevents a Client ID number from being entered more than once. Other fields have been set, so that unless information is entered, the user is not able to progress any further. Relating the Database In order to relate the two tables effectively, the primary key field 'Client ID', in the Client Details table was made an automatic number (i.e. all the numbers included in this field were unique.) this primary key field was used as a foreign key in the Job Details table, which was not an automatic number, as a client could have numerous jobs with the same photographer. Therefore, I created another key Job Dates, this key along with the Client ID key made each record unique. Building a Macro Button How do you do that sir?? Sir says 'open access' User Guide. 1. Opening Microsoft Access It is possible to open Microsoft Access from the desktop by simply locating the icon on the desktop and double-clicking on it. However, it is also possible to open it through the shortcut in the Start menu: 2. Opening the Database Once the right side of the mouse is clicked, the program will open. This screen will then appear: To open a previously created database, click OK after highlighting 'Open an Existing Database'. Then clicking on client database and click 'OK' 3. Entering into the Forms This screen will then appear: Depending on which database is needed, either 'Client Details' or 'Job Details' will then be double-clicked upon. This will subsequently open the selected database. The screen will then proceed to the display below if 'Client Details' is selected: Troubleshooting Guide This guide will help with problems, which may be experienced while using this particular database: * If a Testing To make sure the database works to it's full potential ...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. Business Aims and Objectives.

    Sometimes the form can be used as a report in legal action. In particular, administrative staff are involved in the following areas of health and safety: * All employees have a duty to work safely.

  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. Evaluation of a database set up in microsoft access.

    Design View ? This allowed me to see exactly what would actually appear on my screen. ? In reports and records I could change the appearance (colour etc.) of the information, and make it easier to read (by making the font larger for example).

  2. Database: Feasibility Report.

    Definition of current system Boundaries and constraints I have talked with my client and agreed how the new database will be set out. The client would like a database where all information can be used but they do not want the system to be very complicated to use.

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

    http://rclsgi.eng.ohio-state.edu/~bailey/p1-bailey.txt Timing is a major issue between those orchestrating the technology transfer process and those associated with the development of the technology.( especially the educational goals and strategies for shaping the human infrastructure to receive the technology must be developed for both the receiver and the sender).

  2. Business options

    I have chosen this application because it is free and there are regular updates which are also free. Zone alarm is a firewall which blocks hackers and viruses from accessing your computer and causing serious damage. There are also many different features which make the package easier to use.

  1. Estate agent.I will be creating a system that will help my client to let ...

    their so if someone contact's wishing to buy a house my client will be able to check the entire system for the type of house they want making them money. Analysis Investigation techniques: There are many different methods I could have carried out this experiment.

  2. Report for StGeorges School computer system

    be able to process information that it receives in the forms that have been identified in the report and fairly fast. They process the information that is collected in the form of phone, letter, email, invoices, etc.

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