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

Evaluation of a database set up in microsoft access.

Extracts from this document...

Introduction

Evaluation In Microsoft Access it was easy to do queries because all of the fields I needed to search for information in were laid out into a neat table and I could easily tell where to type the information I was looking for. I could sort information by different fields just by selecting 'ascending' or 'descending'. Not only could I do simple searches, but complex searches were just as easy, I only had to type in a little more information. Sometimes it was quite confusing when I was searching for specific dates, because I had to work out what the short date was, whether it was '<' or '>' sign, and where the boundaries where for different years. 'And', 'or' and 'not' searches were easy to do as I only had to type 'and', 'or' or ' not' in from or between the information I was searching for. I could view all of my data inputted clearly and in the form of a table with columns. Producing graphs, forms and reports were easy because Microsoft Access has 'wizards' which take you stop my stop through the processes. ...read more.

Middle

? Some of my reports looked like tables with the contents arranged in columns. ? They could contain as much or as little information as you want - all records or just a few. ? These records could display information which was based on queries. Buttons ? These allowed me to view other pieces of information, using a link, e.g. from my welcome page to all my records in the database. ? And it quickly allowed me to see information related to the page I was already on. Macros ? These let me open a new form for example, automatically. I also used these with buttons to refer from records to welcome pages. Table View ? I could view all of the information inputted clearly and in the form of a table with columns. It was quite easy to produce tables, reports and graphs as outputs in Access. When I selected what query I wanted to use I then decided which fields I wanted to display in my output designs. This was easy as all I had to do was 'tick' or 'untick' the 'show' row in the query 'design view'. ...read more.

Conclusion

I had to change my fields types to produce the graph to my desired effect. The graph did not label the axes 'yes' and 'no', instead it was '0' and '-1' which was not what I had intended. The wizard for creating the graphs was quite good. I could also decide whether the graph had a key or legend which would help the user to identify the different information on the graph. In design view the actual graph was not displayed which made designing the graph quite difficult - only a model was shown. Compared to Excel the graphs were not as good. They did not have the same information and designing as they did in Excel, and the titles of the axes was limited. Data labels could not be added either, which could make the graph quite difficult to read for users. Overall I think Microsoft Access was the correct program to complete my work in, it had many good features which helped my throughout my project and was easy and simple to use after I had learnt the basics. If there was one thing I could change though, it was have to be an improvement on the graphs. Project 1b Evaluation Charlotte Body 11J 30/04/2007 Mr. Webster ...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 ICT in Business 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 ICT in Business essays

  1. The business I am going to set up is a snooker club,

    My business is in the tertiary sector as it offers customers leisure and entertainment services. Also it is Secondary business as it makes and sells takeaway food. 4.2.2 Suppliers A supplier is any business that sells goods to another business or an individual.

  2. Business studies project on Microsoft

    of Microsoft although as Microsoft is such a high tech company specialist expertise may be needed. This could be the reason why they own offices in over 60 countries. 5.2 Capital Bill gates sold dos to IBM, then purchased it from a man in a Seattle computer shop for $50000.Bill Gates stuck MS on it and so Microsoft was born.

  1. Estate agent.I will be creating a system that will help my client to let ...

    is that employee's can only look at their own files and house's so employees cannot help each other sell or rent houses. If they could do this then they would not only make more money for my client but they would ease their own workload.

  2. An Evaluation of Fred Dretske's Conception of Knowledge and Beliefs.

    A signal carries this information about a source in a particular state. This signal that is being carried about the source is what we can pick up and interpret. For Dretske this meant it was an objective commodity that can exist independently.

  1. An Evaluation of Performance Related Pay and its Viability Within Public Sector Education

    Here areas are found to be very different to merit systems which are based on quantity rather than quality. Before evaluation of the investigated system in the Department for Education and Employment (DfEE) can begin it is important to explain why organisations in the public sector seek to adopt PRP measurers in their human resources management.

  2. Dell - The reason for selecting Hong Kong.

    0.6 Source: 202 Manpower Survey Report: Information Technology Sector, Vocational Training Council Company size - home office, only one - individual consultants, under 20 employees - small business center under 400 employees - medium and large business with over 400 employees Location - Hong Kong Operating Variables Technology Banking and

  1. Creating a Database

    Stock information should also be stored on the new system; it should be able to, * Create Stock information - Stock Details; *New Stock details *Existing Stock Details * Stock Number * Stock Description * Price of Stock * Colour * Size * Stock Status (in stock or out of stock)

  2. Using Microsoft Access to computerise and store information.

    There is not currently a computerised, my tutor does things all by hand and everything is done using paper work. She has to collect all the information from the subject teachers and presses and analyse it by hand. With the help of this new system it will be easy for

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