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

    Do any of the employees within the Herne Hill Branch have any ICT qualification? Not any particular qualification. As mentioned from before we have sufficient knowledge on using applications such as word processing software and spreadsheets as this is the most common software used when carrying out tasks for our jobs.

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

    Bradshaw's skill level. Ashley Bradshaw possesses limited IT skills but is keen to introduce a computer-based system again for the rentals of his DVDs if it meets the requirements. Identification of client and potential users Client The client is Mr Bradshaw who is the owner and the manager of JenJams.

  1. ICT Security Report

    This type of hacking can be seen as malicious but of a vandalising nature as he did not use it for fraudulent or theft purposes. Another example of extreme hacking is was during 1994, when the security of Citibank, the fifth largest bank in the world was breached.

  2. Home Office LTD company. Database

    amount paid and date of custom to the list so that it can be reviewed and analysed in the monthly and yearly review sheets. All of which can either be manually typed in by the user or by copying and pasting the information into the relevant sheets.

  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

    � 52.00 17 � 28.50 � 37.05 � 45.60 � 54.15 � 57.00 18 � 30.00 � 39.00 � 48.00 � 56.60 � 60.00 19 � 32.50 � 42.25 � 52.00 � 61.30 � 65.00 20 � 35.00 � 45.50 � 56.00 � 66.00 � 70.00 21 � 37.50 �

  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