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

Database Project.

Extracts from this document...

Introduction

Database Project The Problem: The Drama department have always had a highly under-organised technical store cupboard. In this cupboard, they have a stock of all sorts of technical equipment, such as Lantern Lamps, Dimmer Pack Fuses, 15Amp Extension cables etc. When there is a show in the making at the school, it is very important that the chief technician in charge is aware of what is in stock in the cupboard, and what the department is short of so that it can be ordered in. Therefore it has been suggested that a computer-based database would be extremely useful in order to allow the technicians to easily see what is in stock. Why Access? For this databases, I have chosen to use the program Microsoft Access. This is because it is a program that has been explicitly designed for anybody to design simple databases. In fact, it is such a good program, you can make your database as simple, or as complicated as you require. ...read more.

Middle

is in the store o It will be used to alert people when stock is short o It can be used as an itinerary of all the products that the Technical team have * What do I want out of the system: o To be able to clearly see the information stored in the system in a clear table o To have the opportunity to display the information in a well set out form o To be able to print records of stock, as well as the whole system o To be able to search the system for certain records o To be able to alert the user of low stock o To be able to create queries to search the system o To be able to create reports to display information Information that I am going to have to collect: In order to fill in my Database, I am going to have to acquire the following information: * The Names of products in the store cupboard * How many there are in stock * Where they were bought from * The suppliers telephone number * What price are (new) ...read more.

Conclusion

Keeping My Database safe: When some databases are built, it is important to keep the information safe, in order to prevent unauthorised access. For my database, I will set a user password, which means that only people with a password will be able to open it. To do this, I did the following steps: File: Open Now, in the "Tools" menu toolbar, you can select: Now when you open the Database, the following message appears: And you can enter the password Designing the table: Field Name Data Type Size Example Name Of Item Text 35 15Amp Extension Cable (10m) Quantity In Stock Number 3 10 Purchase Price Currency 6 �25.00 Delivery Time (Days) Number 3 2 Suppliers Name Text 25 AJS Suppliers Telephone Number 11 01234567891 Product Code Text 20 AJS-124-15a-10m Field Name Data Type Size Example Name Of Item Text 35 15Amp Extension Cable (10m) Quantity In Stock Number 3 10 Purchase Price Currency 6 �25.00 Delivery Time (Days) Number 3 2 Suppliers Name Text 25 AJS Suppliers Telephone Number 11 01234567891 Product Code Text 20 AJS-124-15a-10m Simon Woodfield 9482 51233 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software 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 GCSE Software essays

  1. Analysis section for database project based on a hotel booking system

    Scope, Objectives and Performance Indicators. The following pages has all the input and outputs needed for each process Task 1- Add a guest Quan titative performance indicators Adding a guest Input- Guest number Input- The title of the guest Input- Surname Input-Postcode Input- Address Input- Town Input- Tel no Input-

  2. ICT: Long Project Design - Travel Agency

    The name of the travel agency will also need to be put on so that it is easily recognised. These will fulfil some of Mr. Long's desires. To make the heading, I will use Microsoft Word. I will choose the font Palace Script MT.

  1. ICT PROJECT PRESENTATION

    I have used a blue line and also blue font for when I put a title there. The font looks rather presentable as well so looks more professional. However a disadvantage would be that there is not enough information about the customers. And there is no title for the report.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Step 20 Following that, I decided to include charts, so that the teacher could easily see which children were doing well and which required help, without having to look through the results, which would consume time. As by using a chart you can instantly see whether the class as a

  1. bookings database

    An improvement I would make here would be to increase the font of the Guestnumber so the user can easily see the Guestnumber. Other than this, there are no improvements I would make to improve the effectiveness of the database.

  2. Powerpoint review project

    You can also use hyperlinks to shortcut to certain topics of slides by clicking on them whilst the slideshow is running. Sound effects can be added by going to insert and movies and sounds then you can click to add from file or from clip organiser.

  1. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    01/02/2007 05/02/2007 2 To give him solutions on the problems he has mentions above. 07/02/2007 09/02/2007 3 To select the best solution for his problem. 12/02/2007 14/02/2007 4 To use a solution that can design the menu appropriately. 15/02/2007 18/02/2007 5 Take pictures of his shop and then insert them into the menu.

  2. Database analysis of 'a video lending library'.

    Use of formulae and macros in my database. 7. Do error corrections. 8. Make it easy for Mr. Hussaini to make any updates and searches for any information he needs to find in the database. 9. To make forms for the customers. 10. To create queries. 11. To create reports.

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