Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12

This database will consist of lists of food-items, drinks, sweeties and confectionaries that he owns. I will add the names of the components into a table. This table will show that

Extracts from this essay...

Introduction

DATABASE COURSEWORK. IDENTIFY My Uncle Samuel is the salesman of a newsagent shop called Samuel and son's co. limited. He is busy and disorganized because he is always away on trips and is never around to take inventory of his stock. So I decided to create a database for him to help him make his business more efficient. This database will consist of lists of food-items, drinks, sweeties and confectionaries that he owns. I will add the names of the components into a table. This table will show that all the information required in the database has been entered. I spoke to him about this and he has given me this criteria: > The database must allow him to see the details of customers quickly and easily. > He must be able to see who owes him money. > He wants to be able to check out customers in a location and be able to specify their location. > He wants to be able to enter a price and see all the items and commodities above or below that price. > He wants to be able to print a commodities price list. > He wants the database to be password-protected, so as to stop a competitor from stealing the database. > Finally, He says that because he is not so good with computers, I should make the database very easy to use.

Middle

In Access, you can do complex searches (called Queries); produce quality reports and convenient data entry forms. You can also improve your database by making it 'relational'. Excel is more suited to performing calculations or data modelling functions. A relational database application such as Access is better than a flat file database program, such as Excel and information workshop because it can mean spending less time on data entry and fewer errors. The file format that I am going to produce will be in MDB (Microsoft Database) format. It compresses all your tables, forms, queries and reports into a single file. My output will be shown on the screen and will also be printed to enable the user see information on the database. DESIGN. I want to design a database for food-item stock inventory and customer details (between me and my uncle.) IMPLEMENT. I will now try to create this database, and I shall explain the steps I used to create it along the way. I started off by first deciding to create a database for my Uncle because of his unorganised business. I designed this because he will need it to attend to lots of customers it the future and it will make his business o lot more efficient and effective. This database will consist of some of the food-items and confectionaries that he owns. I will add the names of them components into a table.

Conclusion

Once the forms were made, I began to create the report and query. These were really for presentation. I then put all these pages together and placed a front page with the title of the database in front so when the database is opened, the front page pops up. It was seen that my pages looked pretty boring without any pictures or background. This upset my uncle so I decided to create a suitable background by using saved pictures, adding colour to the text boxes and outlines to where they are needed on the pages. It can be noted that the design for the database was slightly different to the implementation. It will be seen that the front-page design is different from the created one and also the created form is different from the designed one. This is because my uncle decided to introduce more fields into the form and add background to both the form and front-page. It should be noted that all changes were made on user's requirements. By adding scrolls and background pictures, a vast improvement has been made to the whole project. Although it is seen that in this project is that when presetting the database the information in form of a table should never be seen. However in database that piece of information is if the viewer accesses the query option. It should also be noted that password set was "ifeoma" and can only be access when file is opened exclusively.

The above preview is unformatted text

Found what you're looking for?

  • Start learning 29% faster today
  • Over 150,000 essays available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Over 180,000 student essays
  • Every subject and level covered
  • Thousands of essays marked by teachers

Related AS and A Level Management & Manipulation of Information

  1. ICT Security Report

    who use it for fraudulent and theft purposes in order to gain something out of it and in this instance nearly $4 million. Viruses and Trojans A virus is a computer program that is able to copy itself and infect a user's computer without the user's permission.

  2. ICT Solutions for people with Special Needs.

    The Quicktionary Reading Pen 2 was used by a group of adult students and their tutors to discover its utility in increasing reading decoding and comprehension. Users who participated in the study were all enrolled in a metropolitan adult literacy program.

  1. Evalution of my database

    bike all these can help a company to make a lot of profit and boost sales.

  2. Designing a booking system for an Estate Agent.

    The database would also need to include the addresses of properties they are selling. This way when an appointment is booked the user can link the address to the system. The address will need to include its post code, House number, address 1 etc.

  1. Database Design

    Reports Once this was done, I created my reports. I did this by clicking on 'Create report by using wizard'. Once clicked on this, a window popped up like this I selected all the appropriate fields to do with the report I was creating (Invoice report).

  2. Free essay

    Data Protection

    Set the alarm if there is one available. * Mark all of your hardware with assets tags and ultra violet pens. Write in big letters "STOLEN FROM XXX COMPANY POSTCODE XXX" using a UV pen will make sure that it is seen when it is examined.

  1. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    Robert, Deanne& John (2001) also acknowledges by saying that this kind of performance requirements will foster the customer relationships. And to provide efficient Customer Relationship Management the website should be running round the clock 24-by-7 and should have trouble shooting tools to alert the technical administrators for any problems.

  2. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    Apart from better enhanced graphics Sony admitted that the PSX 2 "Is no great leap forward in gaming technology" The total worldwide shipments of PSX 2 hardware were 85.44 million units by June 30th 2001. The total worldwide production shipment of the PSX 2 software resulted in a total of 783 million units as of June 30th 2001.

  • Over 180,000 essays
    written by students
  • Annotated by
    experienced teachers
  • Ideas and feedback to write
    your own great essays

Marked by a teacher

This essay has been marked by one of our great teachers. You can read the full teachers notes when you download the essay.

Peer reviewed

This essay has been reviewed by one of our specialist student essay reviewing squad. Read the full review on the essay page.

Peer reviewed

This essay has been reviewed by one of our specialist student essay reviewing squad. Read the full review under the essay preview on this page.