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

Creating a Database

Extracts from this document...

Introduction

The SOFTWARE TO BE USED The new system that I will design will be in the form of a database. A database is a collection of tables that contain data on a similar subject. The database will help manage all customer, order and stock data, and the database will store all the necessary information needed. A database can be created using a database management system, this is a suite of computer programs that allow people to create, add/delete/change/change data, search for data, print subsets of the data and also controls access to the data. The database will contain information such as: * Order Information * Customer Details * Stock Information * Delivery Information The database management system that I will be using is Microsoft Access. Microsoft access is a powerful database engine that is Designed to combine with a variety of sources and viewers (including Web browsers), Access users can convert forms and reports into Web pages, and edit these Data Access Pages from within their browsers. Access allows you to create different types of project databases such as tables, reports, quires, forms, etc. Here are some of the good features of using Microsoft Access * Simple input masks and data validation * Select and parameter queries * Data entry using fully customised forms * List boxes or combo boxes to facilitate data entry * Output fully tailored to user requirements * Macros to automate commonly used features * A switchboard * Subforms to display information in related tables ...read more.

Middle

The users should have limited access to the stock information as well, e.g. the two workers, Jean & Martin should not be able to change stock information such as the price. The owner, Paul, should be the only one that should have access to change some of the information such as price. The other 2 types of data that will be needed on the system are order and delivery information: * Create order Descriptions - Order Details; * Order Number * Order Description * Other necessary information e.g. Size, Colour, etc. * Create Delivery information - Delivery information; * Delivery Date * Delivery Address * Delivery Time The HARDWARE TO BE USED As the company I have chosen doesn't have an existing computer based systems, the will not be any constraints on hardware because, a new computer system will have to be bought and Microsoft access will have to be compatible with the new computer system. In order for Microsoft Access to work on the new system, the new system must meet the minimum requirements for Microsoft Access to function properly. With the new computer system, either Windows 2000 professional or Windows XP will be installed, and the minimum requirements for this are; WINDOWS 2000 Professional * 133 MHz or above Pentium/AMD processor * 64mb of RAM, more RAM improves performance * 2GB install with 650mb of free space * CD-ROM or DVD Drives is needed as well as a Keyboard/Mouse * VGA or higher resolution monitor WINDOWS XP PROFESSIONAL ...read more.

Conclusion

I have also looked at inkjet printers that could be purchased as well, here is one of the items looked at: With the new system, there will only have to be one computer and all there will be three users, and one user will be the admin, and will have access to change all information such as prices and stock. PERIPHERALS As the company only deals with furniture it doesn't really need extra peripherals such as barcode readers and touch screen systems, although it would be an advantage to have a touch screen system as it can make things more efficient, but having a touch screen system can be expensive, ranging from prices of around �400. Touch screens are also suitable for clicking buttons, but a lot of information will be typed out, so it is probably easier not to have a touch screen. BACKUP The minimum device that will be used for backup will be a floppy drive, and this will store information on a floppy disk, if ever the is a problem with the system and work needs to be saved. The floppy disk can only store 1.44mb of data, so in case data doesn't fit on the floppy disk, it would be convenient to also have a CD rewriter drive, where this will store information on a compact disk, and this can store information up to 700mb, so this can store large amounts of data. AS ICT Project ...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. The purpose of this document is to define the Context of Cain Motors Information ...

    They should be documented in the Project Initiation Document. Activity network A flow diagram showing the activities of a plan and their interdependencies. The network shows each activity's duration, earliest start and finish times, latest start and finish times and float. Also known as 'planning network'. See also Critical path.

  2. Evaluation of a database set up in microsoft access.

    This made my output results clearer and contain only the information that I was searching for. It was easy to see what the table looked like by simply clicking on the datasheet view in the top left of the screen.

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

    I will list some of them below and explain why I didn't use them. Interviews Advantages: You get to have a one on one conversation with people and get their view. And they can see what they feel and can answer your questions thoroughly and you are not limited with you answers.

  2. For my Coursework I have looked at how Steve Edwards at Airbus UK uses ...

    ( Less paper is used than when sending a letter, which helps the environment. There are also some disadvantages to using email: ( The recipient may not check their inbox often; therefore, they may not get the information on time.

  1. Mind Tools Memory System Grades.

    Beside the path someone has planted giant CORN in a WALL (Cornwall), but it's beginning to WILT (Wiltshire) in the heat. She knocks on the Door (Dorset), which is opened by the Devil (Devon). In the background she can see a kitchen in which a servant is smearing honey on a HAM (Hampshire), making in Glossy (Gloucestershire)

  2. Tutor R Us - Creating an IT system.

    observe reaction to the questions ask and also allows me to take my own notes to the questions. It also allows me to maybe ask a question that I might've forgotten to put on the questionnaire. QUESTIONNAIRE Name: Occupation title: Is any aspect of your business computerized?

  1. Invention (device or process).

    to make pottery, the development of simple political systems, and the invention of the wheel. The period of recorded history began with the invention of writing, and writing as a means of mass communication became important with the invention of movable type in the 15th century.

  2. ITC - Database storage.

    The security and data protection will have a password protection system that only the employees working at the shop can obtain. The input of the system will be the stock previously ordered, this would be stored data. With the process calculating the stock and the output will be the available stock left in the shop.

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