UNIT 3 - DATA HANDLING
CONTENTS
Introduction Page 4
Action Plan Pages 5 - 7
The Problem Pages 8 - 9
Analysis Pages 10 - 20
Customer Information Page 11
Product Information Page 14
Order Information Page 18
Reason for Using 3 Tables Page 20
Design Pages 21 - 25
Customer Table Data Page 21
Product Table Data Pages 22 - 23
Order Table Data Page 24
Relationships Page 25
Implementation Pages 26 - 64
Tables Pages 26 - 36
Error Messages Page 36
Queries Pages 37 - 42
Relationships Page 43
Reports Pages 44 - 52
Processes Pages 53 - 57
Forms Pages 58 - 62
Sub-Tasks Pages 63 - 64
Testing Pages 65 - 67
Evaluation Pages 68 - 75
Improvements Pages 69 - 71
Evaluation Criteria Pages 71 - 73
Objective Based Evaluation Page 74
Possible Improvements Page 74
Time Management Page 75
Standard Ways of Working Pages 76 - 77
�
1. INTRODUCTION
This is a database I created, it shows the steps taken to make the database user friendly and to meet the users needs. I created 3 different tables, 2 simple forms, 2 simple queries and a complicated query. I had also created 2 simple reports and a complicated report. I customised all the reports, queries and forms to make them user friendly and make them look professional.
�
Action Plan
To keep myself organised and on top of my work I had set out an action plan. This is a method of making your work easier by cutting it down into chunks and setting out weekly targets for me that need to be met. A note was taken of all the problems that were encountered so that they could be avoided in the future and also so that they could be evaluated...