This website uses cookies to ensure you have the best experience. Learn more

Designing An Application To Replace The Current Manual Record Keeping System For Terry's Turkeys

6889 words - 28 pages

Designing an Application to Replace the Current Manual Record-Keeping System for Terry's Turkeys

I have been asked to design/ create an application, either programmed
or using a relational database or using a combination of both, to
replace the current manual record-keeping system for a company called
Terry’s Turkeys; a small farm which supplies fresh, home-grown turkeys
at Christmas. Initially, at least, there will be only one standalone
workstation with a printer attached. This is to be kept locked in the
farm office.

There are a number of methods of developing the new system.

1. Manual system. Improve the system that Terry uses at present;
however this would be very tedious as invoices have to be word
processed, printed and then kept in a folder for future reference.

2. Spreadsheet system. This would allow Terry to keep details of
customers, turkeys and orders on separate sheets. The calculation
of invoices would be made easier to some degree. However, it would
take a long time to enter data and is less user friendly. Also the
format of reports is much harder in Excel.

3. A purposely designed system. Written using a ‘high’ language such
as Pascal. This would obviously have a lot of advantages as the
system would cater for every aspect of Terry’s activities; because
it’s been specifically designed for the task. However the cost of
this kind of package is very high and Terry would spend a lot, if
not all of the farms profits. Also it takes a long time to code
some areas whereas in Access they are easily done in tables.

4. Access database. The new system can be developed using Access,
making a relational database with different tables storing the
customer, turkey and order details.

For this project a relational database (Access) will be used. This
package is suitable as it has many features which can be used in
developing the system, such as:

* The ability to link tables via a primary key and foreign key;

* The ability to set a password to prevent unauthorised access and
to protect customer details.

* Facilities which allow the creation of reports which can be
formatted as required (labels), and previewed before printing.

* The ability to create a menu by using the “switchboard” function.

* Access can perform advanced queries.

* Access can make forms to insert data.

* Access is very user friendly.

* It has a query language, which means it can perform advanced
searches.

* You can hide certain forms out of view.

* Access can have relational tables, which are linked together. This
avoids repetition in entering in data as more than one department
of the system can share one bit of data.

The database could eventually be extended into an...

Find Another Essay On Designing an Application to Replace the Current Manual Record-Keeping System for Terry's Turkeys

Planning & Designing Experiment: Investigating the current - potential difference relationship (IV Characteristics) for a metal wire

1281 words - 5 pages Title: Investigating the current - potential difference relationship for a metal wire. Aim: To design an experiment that will facilitate an I - V Graph to be ascertained of a metal wire and thus find the resistance of the wire by deriving the inverse of the gradient of the graph. Skill: Planning & Designing Theory: Resistance is a property of any object or substance to resist or oppose the flow of an electrical current. The quantity of

Zen to the Rescue of an Instruction Manual

1443 words - 6 pages bother the eyes and create a nervousness which is NOT an environment for calmness and balance. Further, Datsuzoku refers to freedom from rules and conventions. This manual is far from fulfilling this ideal because it is laden with conventions, rules, and warnings from the very beginning. While one cannot just delete such conventions because of law repercussions and class actions for instance, the rules can be presented more clearly and

Electronic Record Management System for Central Bank

819 words - 4 pages a human framework that would make use of a state-of-the-art electronic document and records management system (EDRMS) and at the same time of raising awareness within the ECB of the importance of records management/archiving in order for the ECB to be in a position to manage its information and compile a documented history for European citizens and generations to come. DISCUSSIONS OF THE ARTICLE I. The Pilot According Moreq, 2001 the starting

Designing Effective Training Programs - University of Phoenix (HR Class) assignment for addressing the secret of designing an effective training program

829 words - 3 pages and change behavior is to use a variety of proven techniques. This paper will discuss the strategy needed for designing effective training programs. Additionally, this paper will introduce a seven-step approach, which will assure a successful training program.Designing Effective Training ProgramsThe lyrics of a popular song from the sixties include a line that seems as appropriate now as it did then "The times, they are a-changing'." They are

Rose Bay Point Piper Marina Redevelopment: An unbiased report analyzing the current redevelopment application for what will become the largest floating marina in Australia

1074 words - 4 pages Rose Bay and Point Piper Marina Re-developmentIn November 2006, Addenbrooke Pty Limited, a company which deals with private developments lodged an application to redevelop the Rose Bay and Point Piper Marinas. The proposal is under review by Woollahra Council and has divided the local community. Both sides are providing strong arguments and campaigning intensely by creating petitions, distributing pamphlets, displaying banners and holding

Designing an ESP Course for Metallurgists

1981 words - 8 pages that it assists students in integrating each new idea, topic, or theme with the preceding ones as the course proceeds”. [32; p.128] Another view concerning the designing a course is expressed by the idea that the course should have a composition like in a story that is why it should has a beginning (responsible for the introduction of the key issues, tensions, and players), a middle (the task of which is to develop and explore these issues), and an

Designing an ESP Course for Metallurgists

1468 words - 6 pages teaching. The tone for the course also depends on a well-composed syllabus. Students may have negative attitude towards the course in case of misunderstanding some points given in the syllabus which are not correctly defined. Even an especially good syllabus may be changed when it is used for the next time to teach. There are some steps you for effective designing and creating a well-written syllabus. The course and contact information should be

Designing an ESP Course for Metallurgists

1753 words - 7 pages be chosen. For example, a syllabus which is based on the theory of leaning developed by cognitive code teaching would give prominence to language forms and whatever definite descriptive knowledge about those forms. A syllabus based on an acquisition theory of learning, however, would stress unanalyzed and carefully selected experiences of the new language. [19; p. 40] The choice of a syllabus is a rather serious step in designing a course. There

Introduction to Starting an Independent Record Label

682 words - 3 pages The purpose of establishing an independent record label is to capitalize on the growth of the music business - an industry that continues to grow despite the sluggish state of the world's key economies. Music has become the most popular form of entertainment. Some current statistics which have contributed to this, include the fact that Americans spend more money buying prerecorded music and videos than they do going to the movies or attending

The Key to Designing Safely

4054 words - 16 pages maintainability not to mention other factors would be open to debate. CONCLUSIONS Health and Safety need to be considered as a part of project risk along side programme, environment and budget etc. For only when all risks are considered and controlled as an integral part of the project will benefits be seen? Designing for safety at an early stage would lead to greater appreciation of project risk and its proper

Case Study: McDonald's Corporation - Designing an Incentive System

2088 words - 8 pages along with the front-line crew and it is crucial to draw up an effective compensation plan that will keep them motivated to work hard.McDonald's has to consider various factors in order to design an optimal compensation plan for the first-line managers. Unless otherwise specified, managers will be taken to mean first-line managers in this report.2. FACTORS TO CONSIDER IN DESIGNING A COMPENSATION PLAN2.1 Financial and Non-Financial

Similar Essays

If We Were To Overthrow The Current Political System, What Should We Replace It With?

2150 words - 9 pages civil right and duties. As already said, this is the basis requirement for the social contract, even if some people may dislike it. In fact, once people agree on which is the best system they need some rules to defend it. In this case, democracy needs this constitutive rule. All considered, the social contract is not an easy and direct model of society. It is a picture of how society should be, so far from how it is nowadays. The neat distinction

Electrolysis: Chapter 4 Results Of A Gravity Pulled System To Replace A Direct Current Power Supply

772 words - 4 pages as before. Thus, measurement of the gas production rate cannot be carried out through the plunger concept (in U-shape tube). Nevertheless, I managed to capture a picture of the hydrogen gas’s production as shown in the Figure 4.2.4. Figure 4.2.4 On the other hand, this project needs further improvements as well as developments in order to measure the hydrogen gas production rate, so, the effect of the booster (electrolyser) system can be determined when the system runs compared to the conventional way (Direct Current Power Supply without pulse).

Designing An Information System For Football Management

2768 words - 11 pages Overview A system for a football club is to be designed that will ensure that the same information has being passed on to all parents of the relevant under-age players with regards to match details. The system is to replace a current text messaging service that has proven to be unsuccessful due to communication issues between team managers and the person in charge of the text system. The system is expected to pass the responsibility of

Designing An Enterprise Business System Essay

520 words - 2 pages Business System have included useful mapping tools for the design phase. The previous phase of analysis calls for three business-model mapping tools - Activity-flow, Dataflow, and Role activity. The purpose of these tools is to analyze problems in the current business process so that an optimal design can be created.Those previous steps are truly necessary in the business-system design process. Without the information from these models, an automated