Wednesday, March 2, 2011

A2 DESIGN

You must list the objectives of the new system, including the improvements you hope to make. You design all new paperwork for collecting and printing info. You design the screens that will be used. The database structure has to be drawn. TABLES linked with ID fields plus and QUERIES (searches) that will take place in the Database every week / day. You then can draw the new flowchart of how the job will be done with the new computer system.
Make sure you have a paragraph to accompany every drawing, flowchart and table design to help the Client / examiner understand the reason you have added it to your project.
Query example:
Attendance List Query
FIELDS: StuName; StuHouse; ClassAttend?; ClassDate='Today"
Note the Field Naming convention that indicates which TABLE each field is from.
Sign-Off - Just List the sections of the design work to be confirmed by your client as ok.

No comments:

Post a Comment