• 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. A Relational Database system to assist the stock control operation of Rai's Newsagents.

    9 Deliverables: * Report of interview conducted with Mr Khan owner regarding implementation of database. * Specify the design, of the relational database system including the features that are going to be implemented. * Produce a working prototype of the database system to show to Mr Khan.

  2. Home Office LTD company. Database

    There then is a monthly sales total for the number of sales and the money spent. The managing director from there can then create graphs and charts from the information. Screenshot of the cell and their names (only 11 examples - all 31 days would be used for the user)

  1. Designing a booking system for an Estate Agent.

    However, they do not mind having extra functions to help keep the booking system more organised and efficient to use. To construct this proposed system the main feature that it will contain is data. Data will need to be processed to give out information.

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

    The amount of time it takes to document a new member With the manual system it can be very time consuming, just entering data for the new member. The form has no tick boxes and the staffs have to write it all in full by hand.

  1. Video World Database as ICT project.

    Unique Primary Key VideoID Automatically incremented Long Integer Unique Primary Key Date Rented Date/Time Date of Return Date/Time Cost of Rental Currency Design of Input Forms Four Data Input Forms are needed * Customers * Staff * Videos * Rentals Customers Form This will be needed to input and update the Members of Video World.

  2. ICT Security Report

    This is more often than not done through spoof emails. The fraudulent, provides an email or emails that contain familiar logos and appear to either report a technical fault or a new option that has become available, which requires you to enter your username and password.

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

    and colour blindness (where people are unable to differentiate between certain colours - usually green and red. Incidentally the website of Vischeck provides excellent examples of what colour blindness is actually like2). Why then is it difficult for people, or students, with such sight problems to become integrated into the education process, or working environment?

  2. Video World Data System

    Because all the data is kept in files you must continuously check if people are not bringing data back. Obviously this can be very time consuming and errors are likely to be made, resulting in lost videos, lost assets and revenue.

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