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

I have decided to create a database for mega video and it is to keep the records of their customers, what videos the shop has to hire, how much the videos are to lend, when they have been lent out and who too and when they have been returned.

Extracts from this document...

Introduction

Contents Page Specification Page-2 Facilities Page-3 Analysis Page-3 Design Page-4 Implementation Page-6 Testing Documentation for the Systems Administrator Documentation for the user User Training Needs Evaluation Mega Video Specification For my A-Level I.T project I have decided to create a database for mega video and it is to keep the records of their customers, what videos the shop has to hire, how much the videos are to lend, when they have been lent out and who too and when they have been returned. I have to create a relational database that will meet the requirements of the users; I must also create a user guide that describes how to use the database. The inputs for the database I am going to need are: > Customer's names and addresses. > What videos the shop has. > How much the videos are. The outputs would be: > What videos are in or being lent out. > Who they are being lent out too. > When the video was returned. > Date hired out/returned Some queries I might need are: * Who has the video and which video it is. * How much is the video. * When does the video have to be returned? * What type of film it is (e.g. ...read more.

Middle

but at least it will get the job done, it has plenty of space, a decent sized monitor with a large area of viewable space. To back up their files and be able to take them off site I have included a CD-R drive which they can use to copy their files onto a CD and be able to take them home or wherever for extra security measures. Windows XP has a password protection option that the users can activate and be able to secure the whole P.C. The keyboard will be a basic keyboard which is easy to use and understand with none of the extra new buttons you find on keyboards nowadays, like buttons to switch off the keyboard or buttons that connect you to the internet. Analysis Queries A query is what you use to find out specific information about the subject that you are making a table about, for example, if you wanted to find out some a specific video details by using the videos ID number, you can make a query to ask you for the number and it will find the video. To do this you have to go to the little icon that says queries and click design new query. It will then ask which tables of information you wood like use choose the ones you want then drag the specific information from the tables to the blank spaces at the bottom. ...read more.

Conclusion

Then you have to choose a primary key. When that is done click design view and you shall see al the information. Design A database is a collection of information that's related to a particular subject or purpose, such as tracking customer orders or maintaining a music collection. If your database isn't stored on a computer, or only parts of it are, you may be tracking information from a variety of sources that you're having to coordinate and organize yourself. Using Microsoft Access, the users can manage all their information from a single database file. Within the file, they will then divide data into separate storage containers called tables; view, add, and update table data by using forms; find and retrieve just the data you want by using queries; and analyze or print data in a specific layout by using reports. Front End Queries Macros Reports Tables Implementation Technical Documentation Microsoft Access is a software package designed to store information and create tables, forms and reports in which to put a users data. The package designed to run off any P.C with the following specifications in mind. CPU 133 MHz or higher Pentium-compatible CPU (300 MHz recommended) Supports single and dual CPU systems (NOTE: Check driver availability for peripheral devices.) RAM 64 MB (minimum) - 4 GB RAM (maximum) (128 recommended) Disk Space 2 GB Hard disk, 650 MB free installed on standalone PC, 700 MB if installed over server (1G recommended) Daniel Birtle A-Level ICT 27/12/00 1 ...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 Studies Coursework - start up video rental and buy shop

    What do you come to rent? Videos DVD Games Accessories These results tell me that the consumers prefer to buy DVD's than to buy games and videos so this section of information tell me that I should provide the company with more DVD product than anything else.

  2. I am opening a new shop in my local area; this shop is going ...

    I have decided to set 3 aims which will help my business run smoothly. My aims and objectives will be: 1. Survive the first year. I will be able to achieve this if I at least break even. This means that my business neither a profit nor a loss.

  1. This case study is based on HMV which is one of the largest retailers ...

    The marketing and sales department is responsible for many aspects of the business they have to carry out market research to find out: * What goods and services the customers want * What the customers think of the goods and products * Expected trends in market and in demand for

  2. Business Report on Manchester Airport PLC.

    Co-ordinating and linking together the activities of these individuals and groups in a formal network of relationships based on high-quality organisational principles and good communication systems so that overall aims are achieved without gaps or overlap in the flow of work.

  1. At present, the owner (Mr Chohan) has a pizza outlet in West Bromwich. He ...

    From this foot-count, I could probably predict what kind of market I would be aiming the pizza shop at. I will also gather ward information from other sources to give me a background about the people within the two areas.

  2. System design for Hollywood Nights Video Rental

    If the person fails to return a video for greater than the specified days they will be contacted and charged by referring to the logbooks to find the customers details. To reserve a vireo over the phone which is on loan, a member asks the cashier and leaves their membership number.

  1. In this report I intend to create a detailed report of Tesco's.

    It has been a sole trader business a partnership an ltd company and now it's a plc. However there are a few types of business that Tesco's hasn't been. * A charity: this is obviously because Tesco's is a profit organisation and wouldn't want to give away all there profit.

  2. "Why Should We Hire You?"

    This is seen when the author says, "Many students place so much trust in the educational system that they fail to look onward to life beyond graduation." The fourth and final point is, "to plan ahead to acquire knowledge of what employers want."

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