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


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.


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.


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 report on Marks and Spencer.

    include, the subject, also it will start with Dear Mr/Mrs and would usually end with Yours sincerely 20.2 Interviews This is another form of external verbal communication is an interview with someone from outside the business of Mark and Spencer who may be interested in the business e.g.

  2. Apple Incorporation - Case Analysis

    0 0 0 Dividend Yield 0 0 0 0 0 0 Apple has not paid dividends for a number of years, even during the profitable times. That results in a zero dividend payout and dividend yield. An earnings per share is a calculation of the total earning divided by the number of outstanding shares.

  1. A feasibility study for Grott Video.

    for hire at the same price as the videos, they should sell the consoles and they should also have a substantial selection of refreshments including ice-cream, confectionary and crisps. By storing the Band Rate List in a computer system it can be used to attach 'payments due' automatically to each video when a member returns it late.

  2. My business idea is to open a fish and chip shop.

    The shop is too far away to cause any competition to my business. The competition is extensive as many competitors. The average fish and chip shop makes a turnover of over �1500 - 2000p.w. There is tremendous potential for my fish and chip shop.

  1. Business Studies Coursework - start up video rental and buy shop

    a dividend to its shareholders and invest money to allow it to grow and expand. Another I need to always have a product development so the customer will always come and my turnover and market share will increase. Questionnaire 1.

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

    There is centralised decision making in my business. Emma and I are the two main decision makers and if Megan or Lucy has any ideas they will pass the information to either one of us. With there only been 4 people, including me, working in my shop there will be no need for any other communication apart from talking.

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

    desk research: this method is used to collect secondary data this is data recorded for a specific purpose such as government purposes, trade figure publications and academic research this research does not have to be done in the field .

  2. Business Report on Manchester Airport PLC.

    as accounting, legal, finance, planning, public affairs, government relations, quality assurance and general management Whatever the size or type of business, the primary and secondary activities used to combine inputs are performed by a mixture of functions, based on the principle of division of labour and specialisation.

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