Update and use a database to search for and present information for a business purpose

For this task you must download the database file or dataset below in order to complete the following tasks

DatabaseFile (this file is in a Ziparchive which must be extracted to use) Dataset File

This database contains details of host families who are able to accommodate staff and students when they are in Paris. You will enter, edit and delete data in order to complete the database the way the French department needs the database to be.

You will also be required search for data relevant to the trip and for the higher levels you will also sort data and print report(s).

Task A

A Update the database as follows:

Adding a Record A new host family has just joined the exchange scheme. They live in the St Germain district and can accommodate 2 guests. They offer vegetarian cuisine, have 1 child and speak English. Their rating is excellent and they have been allocated Reference F1300. Add a new record for this host family.
Editing a Record Edit the record for F1101 – this family are now able to accommodate 2 guests.
Deleting a Record The host family with the reference F1909 has withdrawn from the scheme. Delete this entire record from the database.

Check your amendments carefully to ensure that you have not made any errors.

Task B

The trip organisers would prefer to place students with hosts who have an excellent rating.

Create a query to show the trip organisers:

  • the host reference,
  • the district where the hosts are located and
  • how many guests the host is able to accommodate.

For Higher levels this query should display the data in alphabetical order of district

Task C

Use the query you created in Task B to present the information in a suitable report.

Task D

Some students have special dietary requirements. The trip organisers would like to find out which hosts offer Vegetarian, Vegan or Halal cuisine. The trip organisers will need to know all the information about each of these hosts.

You need to create another query to show this information. This query should display the data in numeric order of the number of guests that can be accommodated.

Task E

Present the results of this query in a suitable report. You must choose a different report format from the one that you used for your first query.

Adding. editing and deleting records

[local /wp-content/uploads/2010/08/Add-Edit-Delete-records.flv]

Creating a basic query

[local /wp-content/uploads/2010/08/Creating-a-simple-query-office-2010.flv]

Creating a basic query in Office 2003

Creating a query with more then 1 criterion

[local /wp-content/uploads/2010/09/querywithmorethen1criteria.flv]

Creating a report

[local /wp-content/uploads/2010/09/creating-a-report-Acess2010.flv]

Similar Posts

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.