In Progress

CREATE ACCESS 2007 OR ALPHA 5 DATABASE

I need a database to collect data from bank statements. The data will be used to code information for bookkeepers who will ultimatly enter the data into QuickBooks. I am building new sets of books for my businesses and personal accounts from the year 2000 forward. I have several companies some with several accounts and have used different banks over the years. I will also have personal bank accounts. The fields should include the business name, bank name, account number, transaction type, amount, date, category, payee or party, transaction id, and a comment field. I want a form for data entry. The form should "lookup" upon itself and or lists to minimize keystrokes. Many of the fields will have redundant information. The data should be able to be sorted by company, bank, date....and exported to QuickBooks or at least to Excel.

I have Access 2007 and Alpha 5 Version 9. It would be helpful for the database to be multiuser and accessible across my LAN and from remote users. A hosted site is a viable option. The database can be in some other format, SQL...with Access or Alpha 5 as a front end.

Skills: Accounting, Intuit QuickBooks, Microsoft Access

See more: alpha access 2007, access 2007 alpha, alpha database, type account accounting, sql data entry form, sql database business, remote excel, redundant data entry, quickbooks bookkeepers, payee id, sql create database, bank account number, field accounting, end year accounting, data entry keystrokes, data entry excel 2007, data entry access 2007, data entry banks, data entry alpha, bank type, bank forward, accounting name, accounting books, accounting bank, 53 bank

About the Employer:
( 18 reviews ) Hot Springs, United States

Project ID: #533296

Awarded to:

tootwotrue

Please see PMB for details. Thanks, Drew

$150 USD in 2 days
(6 Reviews)
5.4

7 freelancers are bidding on average $155 for this job

KellogITSolution

Hello Please Check your PMB.

$110 USD in 3 days
(25 Reviews)
4.5
AlosDeveloper

Hello, please see PMB

$250 USD in 1 day
(6 Reviews)
4.0
nmppatel

I am an IT professional with 10 yrs experience. I have very good experience with SQL Server 2000/2005, Ms-Access 2000/2003/2007. I have completed many projects on GAF in Ms-Access skill. I will provide quick & professi More

$225 USD in 3 days
(5 Reviews)
3.3
zafarulhaq

I am in. Please share more details. Bye

$150 USD in 5 days
(0 Reviews)
0.0
azizulkhn

8/9 years experiance of database.

$100 USD in 4 days
(0 Reviews)
0.0
rathodjayant

we give u best quality and support

$100 USD in 2 days
(0 Reviews)
0.0