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

Microsoft Excel and Microsoft Access

Extracts from this document...

Introduction

Spreadsheet - Microsoft Excel Microsoft Excel is a spreadsheet application, which will enable the analysis of data because it is able to perform calculations and routine mathematical operations for example a cash flow forecast. Spreadsheet files are known as workbooks, in which you work and store your data. Because each workbook can contain many sheets, you can organise various kinds of related information in a single file. Simple formula such as using Sum will add up column or rows of data quite easily, while more complicated formulas using IF statements can compare different values and then inserts the appropriate result. Worksheets are able to list and analyse data. You can enter and edit data on several worksheets simultaneously and perform calculations based on data from multiple worksheets. ...read more.

Middle

(Relate this to your idea) Excel also has some other special facilities that enable you to do specific things. For example you can use filters at the tops of a lists to extract just certain pieces of information. Or you can create lookup tables to obtain information you do not want stored within your main spreadsheet. Excel also comes with the advantage that you can use it as a data source to merge with a mail-merge document within Word. Databases - Microsoft Access Microsoft Access is a database, which is a collection of information related to a particular subject or purpose, such as tracking customer orders or maintaining a music collection. Access is one of the best database applications available as it offers powerful, searching and sorting capabilities. ...read more.

Conclusion

Tables By using a table you can add, edit, or view the data. You can also check the spelling and print your table's data, filter or sort records, change the datasheet's appearance, or change the table's structure by adding or deleting columns. A report is an effective way to present your data in a printed format. Because you have control over the size and appearance of everything on a report, you can display the information the way you want to see it. A macro is a set of one or more actions that each performs a particular operation, such as opening a form or printing a report. Macros can help you to automate common tasks. For example, you can run a macro button that prints a report when a user clicks the button. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Financial Model to help organise the year eleven prom

    next page: 0Test What is tested How its tested Results of test Action taken 1. A system that when research is done allows mechanical calculations to be done in a couple of minutes. Enter data from research and see if calculations are done automatically by the program "excel".

  2. GCSE Excel Project ICT

    and price. The information will be inserted onto static tables, which are referenced from by other sheets. Data flow diagrams the explanations of what happens to the data between input and output. Alternative methods of output considered Display (on Screen)

  1. DTP analyse

    These catalogues will then be distributed by hand to local customers in Southside. There are two types of paper layout I can choose from. One is an A4 portrait/ landscape paper. And another is an A3 portrait/ landscape paper. A3 paper is double the size of an A4 paper you can get more information, and spread it out evenly.

  2. ICT Access

    Another Method that the current system can be improved is by the organization of files into alphabetical headings and entering them into separate files labeled clearly however this possesses many faults as it would require a lot of space and would take a long time to organize each clients files.

  1. System requirements analysis

    Patient and Practice Management Software for Windows(tm) This is more suitable software that is perfect for the health centre. It has many qualities that are necessary for the health centre. The appointments page allows you to navigate from page to page by the click of a button.

  2. One of the most tools provided by Microsoft Access is the ability to keep ...

    Queries will be created from information in the Table and can only be used in the program, Microsoft Access. I will be creating queries so I can sort and analyze data from the Accommodation table (which was provided by Stuart)

  1. GSCE ICT Microsoft Excel Coursework

    The problem with this is that each fighter can work there way up the ladder very quickly if they fight those above them. If this system was to be put in place those fighters who are challenged by some one below them will have to accept their challenge, if the

  2. System administration report

    I explained what my intentions in regard to the coursework and what my aims are. 23.10.02 Received a letter from Mrs. Rutten, agreeing to let me carry out my coursework with the Moat House. Send a questionnaire through e-mail, received the reply's on the exact same day.

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