Task 1

Preparation.

• Write a short introduction to this task, include what sort of data will be kept, what tables will be needed and how they will be linked together, why a database is more efficient and accurate than a paper based storage system, and what data will be accessed from it.
• Using the data given to you by Mr Brown, write down your database table designs on the two blank forms:       (Suppliers & Products).
• Create a folder inside your GNVQ folder and name it 'Unit2Database'.
  

Task 2

Create a Suppliers Table in Access.

• Open Microsoft Access as a blank database, and name it 'JB Sports'.
• Create a table that holds the details of the suppliers, by using your written designs.
• Create a Primary key, this should be the brand name of the product.
• Name the table 'Suppliers', and save.

Top

Task 3

Create a Products Table in Access.

• Create a second table that holds the details of the products, by using your written designs.
• Create a Primary key, name the table 'Products', and save.
  

Suggested completed table designs.

Task 4

A Relationship.

• Build a relationship between the two tables by linking the two tables together.
• The brand name should be a suitable link field. Use referential integrity to show a one to many link.
• Save the relationship and screen print the results for your portfolio, ensure your name is written on it.

Top

Task 5

Evidence of Created Tables.

• Use the main menu bar to create an analysis of the database so far. Use Tools > Analyse > Documenter, print off the results, ensure your name is on the print outs.

Task 6

Enter the Data into the two Tables and create Reports.

• You may do this using one of two methods, you may enter by using the Tables, or you may enter by creating a Form. If you create a Form ensure it fits onto a single screen page, and use colour, shading, fonts to customise it. Which ever way you do it proofread your entries as this will save time later.
• Create two reports for the two finished tables; sort the suppliers report alphabetically, and the products report numerically.
• Print off both reports for your portfolio, ensure your name is written on them.
  

Top

Task 7

Searching for Information (Queries).

• A customer is looking for shoes that are size 13, search the database for all shoes of this size.
• You need the show the shoe size, the shoe name, the price, sale price if applicable, and company name.
• Print a report of this search, and annotate to explain how you managed to design your query.
  

Task 8

Searching and Sorting.

• A customer is looking for shoes that are White / Grey colour, and would like to see a list of shoes available sorted by lowest price order, search the database for these shoes.
• You need to show the shoe colour, the name, the features, the price, and the company name.
• Print a report of this search, and annotate to explain how you managed to design your query.
  

Top

• A new supplier thinks she can deliver her shoes to the shop faster than another supplier. She has asked the manager what shoes he gets supplied from Bristol with a delivery date of more than a week.
• Search the database for this criteria, (hint: you need to search from both tables).
• You need to show the suppliers name and address, the shoe name, and the delivery.
• Print a report of this search, and annotate to explain how you managed to design your query.

• Ensure you have completed the preceding tasks before starting this task.
• The sale prices for the Reebok shoes have replaced the normal prices, and the sale price is now blank, amend your database.
• The Reebok Wire shoe has now been discontinued due to the long delay in receiving the future orders, delete the entry in the database.
• Print a report for just the Reebok shoes only showing the new changes, and annotate to explain how you did it.
  
  
  

Task 12

Extension.

• Search for another supplier from the Internet and note the details of the shoes it sells.
• Add these details to your database giving each a suitable reference number. Three or four new entries will suffice.
• Print a report of your choice that includes your new products for your portfolio, annotate it to show what you did.
• Keep a print out of your source material as evidence.
• Produce a search of your own on your database, print off the report and annotate it to show what you did.
  

Task 13

Files.

• Check that you have done all of the tasks by going through your portfolio.
• Create a back up folder to copy your work to, this could be a floppy disk.
• Ensure that your database is saved in the appropriate folder, print out a screen shot of your files along with a screen shot of where your back up files are kept.
• Your folder must contain print outs of all the tasks from 4 to 12, and screen print outs of your files.
• Check your work against the Marks checklist to ensure you have completed the tasks.
  

Task 14

Evaluation.

Write about a half page evaluating your database, use the list below for guidance:

• Briefly state the purpose of the database;
• Explain any problems you encountered in the design of your database and any changes you have made, or would like to make to improve the design;
• Did you have to amend your design to include any searches;
• Could you have made any more fields or tables to improve the effectiveness of the database;
• Did you find creating a database easy or difficult;
• How satisfied are you with the final result;
• Is there anything else you consider important or necessary to comment on?
• Finally do you think John Brown will be pleased with the results of your work?
  

Top