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

I am going to create a database for a local computer club that I attend.

Extracts from this document...


Database project Report on work undertaken 1.0 The database I will create I am going to create a database for a local computer club that I attend. The club meets every Thursday, Friday and Wednesday at different times. They have 40 members so far but interest is rising. I will need to create a database that will hold personal information about the members such as their telephone number, address, emergency contact and their class details. 2.0 What I hope my database will achieve In creating this database it will make it easier for the organiser to be able to change records, it's a lot quicker and simpler to operate and you can also do search for a particular piece of data. ...read more.


4.1 Member's details Field Name Data Type Field Size Required Primary Key Personal Reference No Number Long Integer Yes Yes First Name Text 20 Yes No Last Name Text 20 Yes No Address Text 255 Yes No Postal Code Text 7 Yes No Home Phone Text 50 Yes No Mobile Phone Text 50 Yes No Emergency Contact Name Text 50 Yes No Emergency contact No Text 50 Yes No Class Text 15 Yes No Doctors Name Text 30 Yes No 4.2 Doctors details Doctors Name Surgery Name Surgery Address Postal Code Surgery Phone Dr A Kinch Health Matters Solihull S46 4SG 0121 7878747 Dr B Dover Up Hill Health Portsmouth P65 4HK 0121 754 6477 Dr B King Northfield Health Centre Northfield B31 5PL 0121 445 6878 Dr N Cage Millennium Point Practice Weoley Park Surgery B31 5GH ...read more.


of class Time of class Beginner Mr James Thursday 7:45 pm Expert Ms King Friday 7:30 pm Intermediate Mr Jones Wednesday 7:00 pm 5.0 The relationships I will use I will connect all three of my tables together, I will do this by creating a relationship between them. I will link the doctor's name field from the doctor's table to the doctor's name field in the member's table. Then I will connect the class field from the class table to the class field in the member's table. 6.0 How I created my database This section shows how I created my database. 6.1 Creating the tables After loading up access you will get this screen. 6.2 Setting up the table structure To get the below screen you will need to click on this button 6.3 Creating the primary key ...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. I was hired by Mr Davies to create a website for a newly built ...

    The total of all proposals should be included. 5.2. proposals submitted to a company, sorted by a proposal date 5.3.Total value of accepted proposals in the last two months 5.4. Value of proposals compared with types of business 5.5. Data on all proposals over �100 submitted in the last three months 5.6.

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

    If I feel that something interesting arises from a response to one of my questions, I will pursue that line of enquiry but that is the only circumstance under which I will digress from my main list of questioning. I will take a notepad with me during the interview to record his answers to my questions.

  1. ICT Security Report

    conference rooms, and the fact that the conference room network connections are always at the least functional location possible. However, wired network access can be controlled because the data is contained within the cabling that connects the computer to the switch.

  2. The business that I am going to study called 'Sangeet Videos'

    Test 1 Description of function Worksheet Expected Outcome Invoice Menu Macro causes sheet to move from menu to invoice Customer list Menu Macro causes sheet to move from menu to customer list Price list Menu Macro causes sheet to move from menu to price list Pivot Table Menu Macro causes

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

  2. Intermediate GNVQ Sample Database Assignment - Bolton Tools Database

    broken) and change the details of any particular tool. * The manager must be able to record when a particular tool is hired out to a customer and record when it is returned to stock. * When a customer comes into the store and asks for a particular tool the manager must be able to say whether he has

  1. The Development of Object-Oriented Database Systems.

    The shortfalls of the relational model together with the increasingly successful use of object methodologies in application development has led to some acceptance of the use of an object-oriented approach in database technology and as such there are several object-oriented database development systems around today to choose from.

  2. An analytical report to discuss the HEG Infoway project, its implementation and the reasons ...

    HEG is an ISO 9002 company. > It has the largest integrated graphite electrodes plant in South East Asia & Middle East. > Processing technology for the sophisticated UHP (Ultra High Power) Electrodes has been sourced from SERS - a subsidiary of Pechiney, France. > Winning the country's top export award (CAPEXCIL)

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