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

    The accidents form will include these things: * Who was injured * What their injuries were * Who dealt with the matter * Names of witnesses * Date of the accidents * What caused the accident * How it was dealt The accident form help improve the businesses health and

  2. 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).

  1. Database: Feasibility Report.

    Client 1's Laptop Client 1's Laptop contains a Windows XP version of an operating system, 128MB Ram, 15GB Hard-drive, and 550 MHz Intel Pentium 3 processor. Client 2's Laptop Client 2's Laptop contains a Windows 2000 operating system, 256 MB Ram, 10 GB Hard-drive, and 1.1 GHz Intel Celeron processor.

  2. AN UNDERSTANDING OF THE NERVOUS SYSTEM

    The forebrain is composed of the cerebrum and related parts, and functions in pattern and image formation, memory, learning, emotion, and motor control. In addition, the right side functions more in artistic and spatial concepts, while the left side controls speech, language, and calculations.

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

    The potential and limitations of GIS for decision-making was emphasised, to enable them appreciate its usefulness and its limitations. Joint training for district medical officers and for members of the GIS task force ensured that everybody has the same basic knowledge.

  2. Business options

    The bad: McAfee Internet Security 2009 stumbles a bit on installation and technical support. The bottom line: Once it's up and running, McAfee Internet Security 2009 is competitive with Norton on speed, detection, and removal of malicious software. Specifications: License qty: 3 users ; License type: Complete package ; OS

  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. The purpose of the new system is to extend the current computerised room booking ...

    Every Year in July they have meetings and decided how much they will charge to let a room. Every week The Estates Department produce letting lists and send them to 20 people. EXISTING SYSTEM DEFICIENCIES The main problems with the current system follow from the fact that it does not cover anything to do with rooms.

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