History of Carphone Warehouse Plc

2302 Words10 Pages
Contents Background 4 Description of Company 4 Ethos, House Style and Existing Publications 4 User Requirements 5 Background 5 Expected Outcomes/ Aims and Objectives 5 User Interface Requirements 6 Hardware 7 Entity Relationship Diagram 7 Design 9 Design of Inputs 9 Data Dictionary and Normalisations 9 Design of Validation Techniques 13 Design of Security/Password Protection Technique 13 Design of On Screen Data Entry Forms 14 Design of Queries 16 Single Table Query 16 Multiple Table Query Using Relational Links 17 Multiple Table Query Using Relational Links with Search Criteria 17 Parameter Query 17 Append or Delete or Update query 17 Design of Outputs 18 Design of Report 18 Design of processes 19 Automated Routines using Programming Code 19 Design a Calculation in a Query or Form 20 Implementation 21 Create Tables and Links 21 Tables 21 Links / Relationship Diagram 31 Two Data Validation Techniques 31 Validation Technique One 31 Validation Technique Two 32 Calculated Field in Query or Form 34 Create 2 Forms 35 Form 1 – ‘f_Login’ 35 Form 2 ‘f_MainMenu’ 36 Create form with sub form 37 Create User Friendly Interface 39 Create Two Macros 41 Navigation Macro – Next Record 41 Open Form Macro 43 Queries 44 Single Table Query 44 Multiple Table Query using Relational Links 46 Multiple Table Query using Relational Links with Search Criteria 47 Parameter Query 48 Append or Delete or Update query 50 Create a Report 50 Low Stock Report ‘rpt_lowstock’ 50 Automated Routines using Programming Code 52 Password Entry System 52 Print Report 54 Testing 55 Test User Interface and Test all Routes through the Database 55 Test all data entry 62 Test Report 93 Test Queries 94 Single Table Query 94 Multiple table query using relational links 97 Multiple table query using relational links with search criteria 98 Parameter

More about History of Carphone Warehouse Plc

Open Document