Proceedings of the 2012 National Conference on Information Technology and Computer Science

Design of Purchase-Sales-Inventory Business Software Based on Excel

Authors
Shunjin Wang
Corresponding Author
Shunjin Wang
Available Online November 2012.
DOI
10.2991/citcs.2012.45How to use a DOI?
Keywords
Software design; ActiveX control; VBA code; record pointer; purchase-sales-inventory
Abstract

Purchase-sales-inventory software is a common tool of small business enterprise information and can be designed by using Excel. This paper focuses on the idea of fool business software design with Excel sequence, record pointer and ActiveX control, and introduces the skills in invoking development tool, setting Macro security, using name and sequence, using Excel function, eliminating loop computation, designing record pointer, and designing Reset" and "Confirm" control buttons in software design.

Copyright
© 2012, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

Volume Title
Proceedings of the 2012 National Conference on Information Technology and Computer Science
Series
Advances in Intelligent Systems Research
Publication Date
November 2012
ISBN
978-94-91216-39-8
ISSN
1951-6851
DOI
10.2991/citcs.2012.45How to use a DOI?
Copyright
© 2012, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Cite this article

TY  - CONF
AU  - Shunjin Wang
PY  - 2012/11
DA  - 2012/11
TI  - Design of Purchase-Sales-Inventory Business Software Based on Excel
BT  - Proceedings of the 2012 National Conference on Information Technology and Computer Science
PB  - Atlantis Press
SP  - 162
EP  - 165
SN  - 1951-6851
UR  - https://doi.org/10.2991/citcs.2012.45
DO  - 10.2991/citcs.2012.45
ID  - Wang2012/11
ER  -