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

Introduction

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.

Middle

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.

Conclusion

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. Home Office LTD company. Database

    Both the total cells have been named so that they can be used in the yearly review sheet, so that the totals automatically go to the yearly review sheet. The user gathers the information for each day by going to the customer database and filtering the order date.

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

    Under what circumstances is a letter sent out to a customer? Currently we do not send out letters as finding customers contact details involves searching for their membership form which is an inefficient task. However I would like the new system to give us the ability to produce letters to be sent to members.

  1. Video World Database as ICT project.

    A main menu should be loaded automatically when the database is loaded, and the whole system should be menu driven. Quantitative 1. It should be possible to rent a video without referring to video or member input screens. 2.

  2. ICT Security Report

    With a wireless network, the "cabling" between the computer and the switch is called "air", which any device within range can potentially access. If a user can connect with a wireless access point from 300 feet away, then in theory anyone within that radius can also connect to the same wireless connection point.

  1. Beanie Project.

    o It will automatically (on recent versions) correct minor errors and does show what is wrong when there is an error. o There are various templates that can be used to create a new document and has the ability to adapt and record macros to perform functions within the program.

  2. Proudlie's Xtreme Sports Club.

    If traveling from Hong Kong Island via the Cross Harbor Tunnel, take the left most exit immediately following the toll gates on the Kowloon side. Look for exits marked for Jordan Road. If traveling south on the main Kowloon Expressway, exit at Tsim Sha Tsui, staying in the right hand-lane.

  1. The purpose of this document is to provide a design for an electronic payment ...

    As the card processing is dealt with outside the scope of this project, references will only be made to the SecPay system and no details of that systems design will be included in this document. Image delivery will also not be covered within the scope of this document.

  2. Video World Data System

    There is no way to check if the video is in or out before he goes into the storeroom. This can be quite serious because while he is in the storeroom it can leave the shop unstaffed with potential thieves in the shop.

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