Encerrado

[url removed, login to view] Easy Assignment

This assginment will test your skills using ADO .NET and stronly typed DataSets. The Database named [url removed, login to view] contains the database for this application. It has the following tables and fields:

The following list describes the fields in the table named tblAccounts:

* fldAccountNumber (Integer) - Unique ledger account number

* fldCategory (String) - Account category (Asset, Liability, Capital)

* fldDescription (String) - Account description

The following list describes the fields in the table named tblTransactions:

* fldTransactionID (Integer) - Unique Transaction ID

* fldAccountNumber (Integer) - Account number

* fldTransactionDate (Date) - Date of transaction

* fldTransactionAmount (Single) - Transaction amount

* fldTransactionDescription (String) - Transaction description

* fldDebitCredit (Integer) - a value of 1 indicates a debit and a value of 2 indicates a credit.

## Deliverables

A vb.net file that contains the source code for the assignment. I do not need a compiled executable. Here is the full assignment

This assginment will test your skills using ADO .NET and stronly typed DataSets. The Database named [url removed, login to view] contains the database for this application. It has the following tables and fields:

The following list describes the fields in the table named tblAccounts:

* fldAccountNumber (Integer) - Unique ledger account number

* fldCategory (String) - Account category (Asset, Liability, Capital)

* fldDescription (String) - Account description

The following list describes the fields in the table named tblTransactions:

* fldTransactionID (Integer) - Unique Transaction ID

* fldAccountNumber (Integer) - Account number

* fldTransactionDate (Date) - Date of transaction

* fldTransactionAmount (Single) - Transaction amount

* fldTransactionDescription (String) - Transaction description

* fldDebitCredit (Integer) - a value of 1 indicates a debit and a value of 2 indicates a credit.

Your program should support the following capibilities:

* Use the OleDbConnection, OleDbDataAdapter, and DataSet classes and use strongly typed DataSets throughout the project.

* On the main form, create a File, Open menu. Using an OpenFileDialog box, allow the user to select the location and name of the datbase file to open. Configure the connection as necessary to use the file selected by the user. Do not hard code the database name into the connection string.

* The Main form should act as a viewer. Display data from the table named tblAccounts in single bound control instances. Allow the user to navigate from one account record to another. On the same form, display data from the table named tblTransactions in a DataGrid control instance. Display only the transactions for the currently selected account. Use a DataRelation to do this.

* On this same form, display the total value of the debit transactions and the total value of credit transactions for the currently selected account.

* Create a second form that will allow the user to add, change, and delete account records. Make sure that referential integrity is enforced. Make sure that the primary key relationships are enforced.

* Create a third from that will allow the user to record a transaction. You may implement this form however you see fit (I would use dynamically created control instances.) Rember that using a double entry accounting system, that a transaction may be applied to multiple accounts. The total value of the debits must match the total number of credits. Your application should implement this functionality.

## Platform

VB.Net(Prefer 2003, but 2002 is OK)

Habilidades: .NET, Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic

Ver mais: vb net data entry, vb data entry form, vb code for data entry form, test your data entry skills, string match, open.mdb file, open mdb file, open.mdb, match string, list of accounts in accounting, list of accounting skills, liability in accounting, double entry in accounting, debit and credit in accounting, data entry classes, data bound control, box net, bound table, basic accounting test, accounting test 2, vb.net list, list vb.net, ledger accounting, main primary menu, Ledger

Acerca do Empregador:
( 1 comentário ) United States

ID do Projeto: #3044230

5 freelancers estão ofertando em média $42 para este trabalho

TakeRealUK

See private message.

$42.5 USD in 3 dias
(555 Comentários)
6.7
sergruch

See private message.

$17 USD in 3 dias
(84 Comentários)
5.5
mcperic

See private message.

$51 USD in 3 dias
(19 Comentários)
3.1
tem0912

See private message.

$76.5 USD in 3 dias
(0 Comentários)
0.0
tsvex

See private message.

$21.25 USD in 3 dias
(0 Comentários)
0.0
joampaacute

See private message.

$42.5 USD in 3 dias
(0 Comentários)
0.0