I gang

Access Database

I require a simple Access database please.

It doesn't have to be graphically nice, but it does have to be easy to read with a sensible layout.

It will have five tables:

- clients

- domains

- transactions

- hostingTypes

- transactionCodes

- conversions

The system should use forms to show a list of businesses and will allow you to add/edit/remove businesses.

Each business will have:

business name, first name, last name, email, phone,

fax, mobile, street, suburb, state, country, general notes,

member since (date),

total transactions amount (get from transactions table),

average monthly spend (= total $ divided by months since "member since" date)

When you click on a business in the list you will see the above info, and you will also see:

- a list of domains

(table layout: columns will be: domain name, domain renewal date, hosting renewal date)

(need to be able to add/edit/remove rows)

- a list of transactions

(table layout: columns will be: date, code, amount)

(need to be able to add/edit/remove rows)

- a list of conversions

(table layout: columns will be: date, successful (Y/N))

------------------------

When you click on a domain the fields will be:

- domain name

- plesk user

- plesk password

- ftp user

- ftp password

- cms user

- cms password

- mysql user

- mysql pass

- sql server user

- sql server pass

- email addresses [large field = varchar(max)]

- domain registration due date

- hosting due date

- hosting type (different types in separate SQL table)

- hosting cost

-----------------------

When you click on a transaction you will see:

- transaction date

- transaction description

- transaction code (from transaction codes table)

- transaction amount

------------------------

When you click on a conversion you will only see:

- conversion date

- conversion successful (Yes or No selection)

-------------------------

I hope this all seems clear and easy.

Kind regards, Cerridiel

Færdigheder: Microsoft Access

Se mere: access database transaction, sql database business, cost microsoft sql server, sql server max, sql microsoft access, microsoft access sql, max sql server, domain renewal cost, access database, simple notes database, sql table remove, access conversion, server allow access, simple access registration database, read codes database, access notes database, selection access, access 2013 email, monthly database access, domain name registration system, email database country, mysql tables rows, mysql allow server access, registration system microsoft access, cost code database

Om arbejdsgiveren:
( 95 bedømmelser ) Glass House Mountains, Australia

Projekt-ID: #4109042

Tildelt til:

jhaynes75

Professional software developer with 13 years experience. Please see PM.

$75 AUD på 1 dag
(29 bedømmelser)
6.1

7 freelancere byder i gennemsnit $90 for dette job

fastudiovw

I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio

$175 AUD in 10 dage
(619 bedømmelser)
7.1
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$110 AUD in 5 dage
(10 bedømmelser)
4.7
sinfulm3

Hello Sir, kindly check PMB.

$70 AUD in 3 dage
(6 bedømmelser)
3.6
operations808

I would like to develop this Access database for you. Thanks

$70 AUD in 3 dage
(0 bedømmelser)
0.0
emindede

I can help you on your project. I worked on similar and maybe more complex then this Acccess database project.

$100 AUD in 7 dage
(0 bedømmelser)
0.0
leonardomsbr

let me help you.

$31 AUD på 1 dag
(0 bedømmelser)
0.0