Database, data handling, how to create a database system

Essay by zafran55B+, November 2008

download word file, 63 pages 0.0

Downloaded 32 times

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