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

Microsoft access relational database

Extracts from this document...


Section 2: Analyze Hardware � Pentium 4 3.2 processor 1GB ram 3.19 GHz 56 kb dial up modem Software � Microsoft access I will be using Microsoft access to create a relational data base. This will let me to make tables that contain data on a specific topic. I will make a relational database my creating multiple tables and linking them together through if they both a particular fields By doing this it will allow my end user to find certain data from different tables., for example they could type in the CD name which would be in one table and it would then tell them the songs on that album which would be stored on another table. ...read more.


Other ways I can sort my data is ascending or descending by the number of songs or by the length of the album but this would cause great confusion because it would mean that you would need to know the time of the album (or number of songs) to find the particular album or artist you are looking for. Input Data Item Data Type Data source Source Format Entry Method CD name Text CD Paper CD artist Text CD Paper Name of songs text CD Paper Number of songs Number CD Paper Album rating Text End user Paper Artist rating Text End user Paper Time of CD Number CD Paper Data Flow Diagram Data Item Recipient Format Output Method Notes Queries End user Visual display or print outs A way to obtain specific data in a specific table Reports End user I shall use the print button. ...read more.


I will also make sure that the back up is kept up to data so that if I or the end user were to edit the database on the end users computer and it was to become lost or corrupt then we wouldn't have to then go and manually update the back up. This backup system is fairly simple and safe to use. Security For the end users security I will put the database system into a protected folder so that to access or delete the folder the end user will have to enter his personal password to get into the database. This again is a simple way to keep the database protected, not that it would really need protecting anyway because if the database was to be accessed and changed or deleted we could simply replace it with a back up. ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Designing a booking system for an Estate Agent.

    This is something that the old system is not able to do as it was an unorganised paper based system. The new system will be using a form based systems that is operated by clicking buttons which is similar as if they were shopping online.

  2. Background and investigation for designing a database for a DVD rental shop.

    Her main role consists of dealing with customers and making rentals. She will be adding and editing members, DVDs and rental in the proposed system. The final user of the system will be Jason Bradshaw, Mr Bradshaw's son. He currently works on a part time basis, as he will not

  1. ICT Security Report

    Trojans are malicious software. These programs devised by professional hackers to detect activity on PC allowing the hacker to assume the user's identity. This is done because they carry codes that are not acknowledged for the purposed stated. Hackers are then able to run programs on the user's computer without them knowing.

  2. Home Office LTD company. Database

    Another way is for the user to use vlookup, but a problem with this is that it only works for one entry and when you want another entered, it did not work. It just changed the previous clients' information that was entered using vlookup.

  1. A Relational Database system to assist the stock control operation of Rai's Newsagents.

    5 Evidence of Requirements: 5.1 It is very important that the manual system where the shop owner (Mr Khan), it is essential to manually assign quantities and items to deliver the items on demand. Rai's Newsagent operates on a very small scale and relies on a manual method of storing stock items.

  2. Intermediate GNVQ Sample Database Assignment - Bolton Tools Database

    48.75 � 60.00 � 70.70 � 75.00 22 � 42.50 � 55.25 � 68.00 � 80.75 � 85.00 23 � 45.00 � 58.50 � 72.00 � 85.50 � 90.00 24 � 47.50 � 61.75 � 76.00 � 89.55 � 95.00 Description of user's needs The manager wants a system which

  1. Assess ways in which information technology can enable visually impaired students to access their ...

    Furthermore the Royal National Institute for the Blind (RNIB), a UK body, estimates that there are approximately 2 million people in the UK with such sight problems.1 The main categories are as follows (and are relatively self explanatory); blind with no useful vision, blind with some useful vision, partially sighted (some sight available)

  2. Evalution of my database

    good and bad features)?. I agree whit these comments I do need to improve on some of my evaluations because these will improve my marks on a whole. Effectiveness of the database as a whole and own performance in the unit The database would be very useful for a company because it will show

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