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


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.


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.


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. Microsoft Excel and Microsoft Access

    To find and retrieve just the data that meets conditions you specify, for example if you were looking for people who live in a certain town, you can create a query. To analyse your data or present it a certain way you can create a report.

  2. System administration report

    As there is a risk of diseases such as Repetitive Strain Injury (RSI), eyestrain, back trouble, stress & fatigue and tripping over wires that can cause a safety hazard. RSI is particularly common to those who use the keyboard constantly, this leads to rheural arthritis and employee can sue a hefty amount to the hotel for compensation.

  1. Design of solution - In solution to the doctors surgery system that ...

    Dr_Patients Text 1000 ( The patient of the doctor (will use drop down box Doctors Table Appointments table Key field Field Name Type Size Validation Description ( Appointment_No Autonumber LI ( The number of the appointment ( Appointment_ time Date/number 10 Data type The time of the appointment ( Appointment_

  2. Different types of technology How I use ICT at home and at school

    The ability to share files is also extremely useful. If I really need a song and my friend has it, he can use MSN to send it to me. He can also send me other things such as photos, videos and games. If I'm having trouble with some work, he can send me an example in which would give me a clearer understanding.

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

  2. ICT (double award) - Business systems portfolio.

    Once this has been done the system has a stock list and will remove the item off the list. This is useful because at the end of each day the system can be checked to see what stock they are running low on, and will be able to order some more before they completely run out.

  1. Planning my tables and the complete database for the new system.

    "99999".00" Dhs. 547.00 SELL PRICE "Dhs. "99999".00" Dhs. 1,050.00 TYPES This table contains the type of items that the company holds, eg. TV, mobile phone etc. This table will be used for queries and for grouping (relationships + sub-forms) the items by item types so that the company can see which companies deal with the concerned product.

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

    John Doyle: No, Thank You Me: Ok, can I ask what your company do now and what would you want them to do. Doyle: The company produce car insurance on the phone, what I would prefer is for the quote to be given straight after the details have been entered Me: Is this what you would like me to create?

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