Student
Purpose
In this project, a database management system will be implemented to make the self-ordering easier. The users for this program will be used for customers in various restaurants. It will take a customer’s order, total it, and give them an amount. The system will instruct the customer to enter the correct amount. If the amount is not enough, the system will instruct them to enter more money. If it is too less, however, the system will them issue out change.
Use of Visual Basics
Visual Basic for Applications (VBA) will be used because it is a programming language built right into many Microsoft programs. This language is built on the Basic programming language made popular by PCs over the past 25 years. VBA shares similarities with other Windows implementations of the Basic language, such as Visual Basic. If you are familiar with programming in a different language (including using macros), you can quickly get up to speed with VBA.
There are a few terms you should know before you start programming in VBA:
• Procedure. A section of programming code, designed to accomplish a specific task, which your program statements can use throughout your program. There are two types of procedures: functions and subroutines.
• Function. A procedure that returns a value after it completes its task. When called, functions typically appear on the right side of an equal sign in an expression.
• Subroutine. A procedure that does not return a value after it completes its task.
• Module. A named collection of procedures. You typically attach modules to specific forms or reports.
You can accomplish many tasks simply by using macros. This implies--and correctly so--that not everyone needs to use VBA. As a general rule, if you can accomplish a task by using macros, do so. Macros are simpler to implement and easier to maintain. However, there are certain tasks which you cannot do with macros or which you can better implement through VBA. You should use VBA instead of macros
In this project, a database management system will be implemented to make the self-ordering easier. The users for this program will be used for customers in various restaurants. It will take a customer’s order, total it, and give them an amount. The system will instruct the customer to enter the correct amount. If the amount is not enough, the system will instruct them to enter more money. If it is too less, however, the system will them issue out change.
Use of Visual Basics
Visual Basic for Applications (VBA) will be used because it is a programming language built right into many Microsoft programs. This language is built on the Basic programming language made popular by PCs over the past 25 years. VBA shares similarities with other Windows implementations of the Basic language, such as Visual Basic. If you are familiar with programming in a different language (including using macros), you can quickly get up to speed with VBA.
There are a few terms you should know before you start programming in VBA:
• Procedure. A section of programming code, designed to accomplish a specific task, which your program statements can use throughout your program. There are two types of procedures: functions and subroutines.
• Function. A procedure that returns a value after it completes its task. When called, functions typically appear on the right side of an equal sign in an expression.
• Subroutine. A procedure that does not return a value after it completes its task.
• Module. A named collection of procedures. You typically attach modules to specific forms or reports.
You can accomplish many tasks simply by using macros. This implies--and correctly so--that not everyone needs to use VBA. As a general rule, if you can accomplish a task by using macros, do so. Macros are simpler to implement and easier to maintain. However, there are certain tasks which you cannot do with macros or which you can better implement through VBA. You should use VBA instead of macros
Bibliography: Harbour, J. S. (2008). Visual Basic. Net Programming for the Absolute Beginner. Cincinatti, OH: Premier Press. Petroutsos, E., & Cirtin, T. (2002). Mastering Visual Basics.Net. Alameda, CA: SYBEX. Sigon, T. (2009, October). What is Visual Basics? Retrieved from Visual Basics: http://visualbasic.about.com/od/standalonevb6/l/bllearnvba.htm Valiev, S. (2008). Microsoft(r) Visual Basics.Net Programming Fundamentals. Huntington, NY: Frontenac Books.