MS Office solutions. Fantasy mobiles require: An excel spreadsheet with two work sheets; Inventory & Monthly Sales GUI to update stock quantities on the first worksheet GUI to calculate total and average sales of a

The first 200 words of this essay...

MS Office Development

Contents

1. Introduction 3

2. Task A 4

2.1 System requirements 4

2.2 Prototyping 4

2.3 Implementation part 1 6

2.4 Functional Testing 10

2.5 Logical Testing 10

2.6 Implementation Part 2 12

2.7 Functional Testing 15

2.8 Logical Testing 15

3. Task B 17

3.1 System Requirements 17

3.2 Prototyping 17

3.3 Implementation 18

3.4 Functional Testing 19

4. Task C 20

4.1 System Requirements 20

4.2 Pseudocode 20

4.3 Implementation 20

4.4 Testing 22

5. Evaluation 24

5.1 Evaluation of the Solutions 24

5.2 Self Evaluation 25

6. Bibliography 26

6.1 Books 26

6.2 Websites 26

6.3 Online Articles 26

6.4 Other 26

1. Introduction

Microsoft Office is an office suite of related applications. VBA (Visual Basic for Applications) is an advanced feature which can be used within the office suite applications to develop solutions for office environment problems. When coming from a VB.Net background, you have a head start but nonetheless there is still a learning curve to undergo. The VBA object library also