Project 1b Data Handling Coursework Guidance

Project Requirements

For this project you are required to carry out two main tasks:

Task 1: Using a database (10 Marks)

Using a customer booking system for a hotel (The White House Hotel) enter data, sort and query it and printout the results.  The database must be created using Microsoft Access.

Task 2: Creating Your Own Database (18 Marks - but you must do ALL of Task 1 to score any marks on Task 2)

You must decide on the data you would like to use to set up your own database system.   Explain where you have found the data you have used (both IT and Non-IT sources) and how you will enter the data into your database table.  Create queries and reports so that you can interrogate the data and printout the results.  Finally, explain how you set up the database and why you chose the field names, data types and queries that you used. 

Examples of possible data to use:
Stock data for a shop (Videos, Music CDs, PC Games, Second-hand cars, bikes, fashion accessories, clothing, football memorabilia)
Membership  data for a club or organisation (Names, addresses, telephone numbers, email addresses, memebership types,  etc)

Use the checklist below to make sure you have produced all the necessary evidence:

  To do Evidence Marks
  Task 1:  Using A Database 8 - 10  Printed Sheets  

1

 Enter the White House Hotel customer information into a database.  Printout the whole database.
(NB - You can use other databases for this task)
  • Printout of the whole database
 1
2 Answer simple questions about the database using sort tools (A to Z and Z to A)
  • Printouts of the whole database sorted in different ways
 2

3

 Change information about customers and details about new customers on a data collection sheet that you have designed and made.
  • Printouts or hand-written sheets showing the empty data collection sheet and the sheet with the details added to it.
 2
4 Update the customer database with the new information that appears on the data collection sheet
  • Printouts of the whole database showing  the new data added
 2

5

 Produce a list of questions that you can ask about the data in the customer database.  Show evidence that you have used the questions to make queries.
  • Printouts of the questions and the results of queries.
 3
  Task 2: Creating Your Own Database 17 - 20 Printed Sheets  
6 Decide on the data you will use to create a database of your own.  Explain where you will obtain the data to enter into the database (Using IT and Non IT sources of information)
  • Printout of your project proposal including your research methods.
 2

7

 Create a table design for your database.   Explain the choice of field names, data types and validation rules that help to   make your data entry accurate.
  • Printout of the database table design
 2

8

 Create a data collection sheet that can be used to collect the data you are going to enter into the database.
  • Printout of the data collection sheet with the data added
 1

9

 Create the database table and include validation rule messages.
  • Screen capture Printout of the database table in design view.   Printout of the validation rule messages
 3

10

 Enter the data you have collected into the database table. 
  • Printout the whole database.  (For both marks printout the database table first with some errors and then with the errors corrected)
 2

12

 Sort the database table alphabetically (A to Z and Z to A) by appropriate fields
  • Printouts of the database table sorted in different ways
 2

13

 Create a list of questions you could ask of your database (queries).  Think of questions that will enable you to   use complex queries using AND, OR and NOT.
  • Printout of the questions
 1

14

 Produce the results of the different queries that you have done on the data. For three marks produce graphs using the results of the queries.
  • Printouts of the results of the queries and graphs
 3

15

 Annotate printouts explaining how you set up the database and ran the queries and sorts
  • Annotated printouts of screen captures
 1

16

 Write a brief explanation of your choice of software and comment on how easy it was to use the software to produce the required outputs - forms, tables and graphs
  • Hand written or printed sheet
 1

Total Marks

 28