Loading

Excel to Access Converter Application

Submitted by: 
Language: 
Visitors have accessed this post 8126 times.


Excel to Access Converter is a simple program under VB Classic which convert xls files to mdb file format.

Download now and learn something from this code.

Thank you :-)




Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Write a C# program that stimulates the following banking system:

1) Defines a client class that contains method main( ) with following tasks :-

a. Declares an object of type “Accounts” class under the name “Customer”
Note: - no initialization for “Customer” is required at this stage.

b. Asks the user to enter an integer account#.

c. If account# entered is greater than 9999, the user is considered as a new customer .A default class constructor (without parameters) is used to create an object with the name “Customer”. In this case, customer balance will start with zero as shown by the description of class “Accounts” in number (2) below.

d. If account# is less than or equal to 9999 then the customer is to be asked to enter an initial balance to start with. Following that, a constructor of class “Accounts” with a double parameter is invoked by passing an initial balance value that is set by the user to create an object with the name “Customer”.

e. Regardless of which constructor of the two class constructors is used, the account# value is to be assigned to the property “AccountNo” of the “Customer” object.

f. Repeatedly asks the customer (by implementing a loop) to select one out of four choices as follows :

i. “V/v” to view the balance by calling method ViewBalance( ) .
ii. “E/e” to exit the program.
iii. “D/d” to deposit an amount entered by the user when prompted. The amount entered is send to method Transaction( ) of object “customer” as a parameter.
iv. “W/w” to withdraw an amount entered by the user when prompted. The amount entered is send to method Transaction( ) of object “customer” as a parameter value after negating it .

Note:- Method ViewBalance( ) is to be called immediately after calling method Transaction( ) in case of options “D” and “W”.

2) Defines class “Accounts” that is to be instantiated from within the client class stated above:-

a. Declares a double property with the name “Balance” and an integer property under the name “AccountNo”.
b. Declares a default constructor (without parameter).
i. Transfers the execution to another constructor. A zero will be passed as a parameter value to the latter constructor.
c. Declares a second constructor (with one parameter) that calls method Transaction( ) by passing the amount received by the constructor parameter .
d. Defines method Transacation( ) that only adds a value received by its parameter to the Property “Balance”.
e. Defines method ViewBalance( ) that displays the current values of both the AccountNo and the Balance.

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.