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

One of the most tools provided by Microsoft Access is the ability to keep specific data in tables. Hence, I will use the table to create lists of accommodation from a certain criteria.Microsoft Access allows the

Extracts from this document...

Introduction

Software Selection, Task 3 I have chosen the software Microsoft Access 2003 and Microsoft Word 2003 to do my Task 3 in. There are many facilities within Microsoft Access and Microsoft Word which will aid me to do this task. In task 3, I am asked by Stuart to do several things. Stuart is having problems with printing lists of particular types of accommodation for people who have sent him a letters asking for bed and breakfasts with four doubles. He wants me to create a system so he can find the right accommodation for each request. He wants me to create a list of accommodation using data from a file he has provided. One of the most tools provided by Microsoft Access is the ability to keep specific data in tables. Hence, I will use the table to create lists of accommodation from a certain criteria. Microsoft Access allows the ability to import files from other folder/files on the computer. This is an immense advantage as it saves huge amounts of time in having to type everything from scratch. ...read more.

Middle

When the query is run a dialog box will appear asking you to enter a parameter value for the phrase you put in brackets for the criteria, which was for a particular field, in the query design grid. The value you enter is passed to the query as the parameter. This will show the query to the value one entered for the phrase in the dialog box. This is the type of system Stuart wants so he can enter the value of a field and a list of that field will appear as a query, (this means for the first part he can search bed and breakfast with four doubles). Access also allows one to create reports. Reports enable queries to be printed and presented in a much neater and professional looking style, although there are no dividing lines (except dividing the field titles and the query data, and dividing the page information and the query data), all the information is equally spaced out so that it is clear and easy on the eyes to read, both when seen on the screen and when printed out. ...read more.

Conclusion

I decided to use Microsoft Word to aid me in this mini-task as it has the option to create a mail merge. This means I can link up a database to a document (a letter in my case) which I will be sending to multiple people. I will create a query in Microsoft Access to find out the addresses of the hotels with 25 or more double rooms. I will then import the letter from the Lancre Festival file (Word also allows one to import files; another good feature which I will use). After importing the file I will use mail merge to gain the data from the query I produced earlier on. The main reason for me to choose Microsoft Word was as it has the facility to use mail merge; something I must do as Stuart wants me to for creating the letter). Some other features of Word that may help me but are not necessary are, one is able to change the colour of the font and the font itself and use bold, italics etc. These features will be helpful as I could use them to make the letter look professional, something Stuart probably would want. By Adil Iqbal 4LC ...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. Different types of technology How I use ICT at home and at school

    It replaces boring classroom lectures, taking notes etc. to computerised activities. Students in the whole class are now encouraged to participate and students don't idly sit by and take notes, bringing forth subjective learning as some people take notes more while others take nothing in from taking notes or listening to lectures.

  2. ICT Access

    Hock wants to develop a system allowing him to locate clients or properties easily these will be presented with in a table listing crucial information relevant to the subject. As Mr. Hock operates the estate agents he has little time to create a design himself therefore he appointed me.

  1. IT Coursework~The importing of clothing are too slow at the moment, especially jeans.

    Often the customers might decide to change some components to a cheaper one or a better one, so the shop assistance has to look up the prices and recalculate the quote. This is very time consuming. Customers may have walked out of the shop fed up with waiting and he has consuming.

  2. This system is to be used by members of staff to access information about ...

    User Objectives 1. Record-keeping system must provide complete and accurate details of all our members and trainers. 2. Record-keeping system must link each member with their personal trainer so we can easily see a list of clients for each trainer.

  1. The end user of my program is for the people applying for the insurance ...

    details are collected in a very tedious and a long process for the phone assistants complete the registering of the customer the phone assistant through a number of various process just to store the document. (a) A letter from the potential customer (b)

  2. Task 2 - Access Database - ICT CW

    Requirements The firm wishes that the computer system becomes a more useful tool in there business and will help ease the workload of the staff and make the company more efficient and runs more smoothly. When the data is implemented the hope it will help to store there stock levels easier and help keep it up-to-date easily.

  1. System administration report

    The application is useful and effective to the hotel. The application has numerous options such as: - What rooms are available and when; - Reservations for customers can be made; - Customer details, E.g. way of payment; - Length of stay; - How many occupants in a room; - What

  2. Microsoft Excel and Microsoft Access

    With the powerful mathematical functions Excel allows you to model real-life situations. For example by using the correct formulas, predictions can be made showing how much profit an organisation will make in the future.

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