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


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.


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


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. Business report on Marks and Spencer.

    The business ICT performance has been doing well also the business has been showing signs of improvement also sales has increased and also the market share for food and clothing has showed signs of improvements.

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

    Some people started up their businesses based on their training and work experience. Their expertise can help them get their businesses off the ground. 3.3 Business planning A good business plan can be useful in organizing your thoughts and giving you a clear idea of where you're headed.

  1. ICT Coursework Two - Database Project

    Member Information Customer ID -- Yes -- Video Rental Information Video ID -- Video Name -- Loan ID -- Cost of Rental -- Issue Date -- Returned "No" No -- Date Due -- Yes Date Due: [Issue Date]+2 Days Overdue -- Days Overdue: DateDiff("d",[Date Due],Date())

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

    they need to concentrate on and they are convinced that they will be rewarded for their effort. Encourages good performers/discourages poor ones The right system can also discourage poor workers. Where a system is based on individual, rather than group performance the more effective workers will be motivated and stay with the company.

  1. Business studies project on Microsoft

    They also own offices in 60 other countries including the United Kingdom, Russia, and Australia, Sweden... Other possible reasons for locating there main office in Seattle could be;- 5.1 Labour Seattle has a large population, which would be extremely ideal, as they would be able to work in the offices

  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. Dell - The reason for selecting Hong Kong.

    , limited number of larger supplier (good reputation in the past co-operation) and short channels (high speed) , critical to success customer service (on going information service and after sales service , personal selling approach, Current relationships: strong relationship on existing customer, longer term and closer relationship with fewer suppliers,

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

    And if they are a year or two old then they will not be much use to me, as they will not show me how the business is doing. Group Discussion Advantages: You get a wide range of views and most people will participate.

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