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

    Safety and Environment requirements; In some areas dangers to the local community may mean selecting a different location. Environmental restrictions may also impact on the site, for example the Government are trying to limit construction on out of town sites and are in favour of using existing sites.

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

    Observation Advantages: You get to see first hand how the business is run. Disadvantages: People might behave differently when being observed. The reason that I have chosen to do an observation is so I can see first hand how the business is run and no one will lie.

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

    Type 3 representational systems are not assigned a function; the function is part of its existence. Dretske belives that beliefs are a Type 3 representation. Information is a key concept to grasp when it comes to understanding Dretske. He believes that information is to be something that comes from a source.

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

    inflation rates of around 20% made this sum become very small increase in real terms. Throughout recent years with inflation rates decreasing to single figures it has become much easier to award noticeable pay increases based on performance. This chapter will continue with the aim of explaining the principle of performance related pay along with its advantages and disadvantages.

  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

    function should be where stock can be searched for using the stock code or description. There should also be a report function, which shows all the orders for a period of time, e.g. a month, and the total value can be printed out.

  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