• 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

    is shown in the appendix under D. that has been made efficient because its on a completely different sheet and has plenty of room for new data. The list of further investigations that I took is listed on the

  2. GCSE Excel Project ICT

    Microsoft Excel Microsoft Excel 2007 is a great new application with almost limitless data storage it has 1'048'576 Rows, 16'384 Columns, 17'179'869'184 Cells each can contain 32'767 Characters, which means a total number of 562'932'773'552'128 Characters per sheet! Data Validation can be inserted into cells to ensure correct details are inserted.

  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

    This software has a range of features that would be needed for the Howard Health Centre. Here is a list of The features that would be needed for the health centre, that the company claim to offer: * Provides improved internal and/or public access to services and assets for customers

  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

    Administrative procedures: How consumables and other equipments is purchased or organised and how they are kept, and the general work of the system administrator. Backup procedures: What data is backed up, and how and when, is at regular intervals or the end of every working day.

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