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


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.


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


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. GCSE Excel Project ICT

    Written explanation of initial designs. Sheet6 The cell range C4:J6 will be merged into one cell, as will D7:K9 and C15:L20. This has been done to enable that the text "Custom Computer Parts � By WarlordTF � Click 'Next' TO Start Your Order" will be fitted in with this font

  2. GSCE ICT Microsoft Excel Coursework

    challenge is turned down by the fighter, they will automatically lose the fight and therefore they will be overtaken by the challenger. This ladder system would not be ideal because if a fighter had been at the top of the ladder for the whole year, and then on the last

  1. System requirements analysis

    It would be even less appropriate if the designer/s had to redo the whole database, details, booking system, etc if the data was destroyed due to an unfortunate event.

  2. Financial Model to help organise the year eleven prom

    Bell MT is size 11 and then Baskerville old face is size 10. I needed a place for information to be inserted; I chose this to be outlined white boxes, then put just under the headings "only in white boxes provided".

  1. System administration report

    - Shift report - Posting Scan Other functions - Reservations - Making reservations. - Housekeeping - Schedule for Housekeeping. - Building maintenance- what is the value of the building: fixed asset. - History & marketing - a brief description of particular topics related to marketing of the hotel.

  2. ICT Job Applications - Enricé's Tapas Bar.

    N/A GCSE Qualifications 2 Text 100 Y N/A N/A N/A GCSE Qualifications 3 Text 100 Y N/A N/A N/A GCSE Qualifications 4 Text 100 Y N/A N/A N/A GCSE Qualifications 5 Text 100 Y N/A N/A N/A GCSE Qualifications 6 Text 100 Y N/A N/A N/A GCSE Qualifications 7 Text

  1. DTP analyse

    I will also gather all the details such as the address of the shop, the logo of the shop and the contact details of the shop.

  2. ICT Access

    Consideration of alternative solutions Mr. Hock has acknowledged his existing system is not appropriate for his requirements therefore he is advancing the recording process, which allows the entry of details however the previous paper based designs displaying viewings were recorded within a book, his preferences would be to create individuals files of properties, customers and viewings within an application.

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