• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
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

Datbase Project newsagent shop

Extracts from this document...

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. ...read more.

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. ...read more.

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. ...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. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    Sony's market strategy stated that they propose to launch the PSX 2 in the UK by Autumn 2000. They further predicted to shift 1 million units in Europe on the first day of release. These strategic estimates made by Sony were on the basis that they would produce 300,000 units per month.

  2. ICT Security Report

    Then he logged on numerous times over a period of weeks and transferred approximately $3.7 million through wire transfers to various accounts his group controlled in the United States, Finland, the Netherlands, Germany, and Israel. Levin and his accomplices can be again as malicious hackers but this time as those

  1. ICT Solutions for people with Special Needs.

    This high-quality Sony device feature convenient voice-activation. It costs around �38.00 Age Range = 7 - Adult For dyslexic users, I will choose to select the Quicktionary Reading Pen 2, because I believe that it will be the most beneficial solution out of the ones I have selected above.

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

    * Are there any limitations on data handling? * What type of retrieval and documentation functionalities the vendors provide? * Will the vendor provide data model documentation that explains all the data? Because most of the times vendors keep their data models confidential, to make the purchasing company buy additional product licenses to access the CRM data.

  1. Free essay

    Data Protection

    This will help you recover from a hardware theft as well as hardware failure and is a good business practice consider. * Make sure that your work area is secured and that you have locked the doors - even if you need to pop out for a few minutes.

  2. Design a computer system for a video hire shop.

    It takes a long time to find records, as they are stored in a filling cabinet. When editing a record you must remove the entire card and rewrite it, it is time consuming to add new records. To re-sort the records would take a very long time as it would obviously have to be done manually.

  1. Critically assess the personal attributes you would expect to find in a successful project ...

    Part 2: Evaluate the effectiveness of the systems approach in building up a full picture of a project. Project management has historically relied on techniques such as critical path analysis, earned value concept, configuration management, risk analysis and other such methods.

  2. The Development of Object-Oriented Database Systems.

    To illustrate, think of a motorised vehicle as the object. Basically it has two states: on and off. When the vehicle is in the on state, the on behaviour describes how it should behave in the on state, i.e. starts engine, etc.

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