Access Database

In Progress

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

Skills: Microsoft Access

See more: require simple access database please, access database transaction, sql database business, cost of microsoft sql server, sql server max, sql microsoft access, microsoft access sql, max sql server, domain renewal cost, c# with access database, c with access database, access database, simple notes database, sql table remove, access conversion, server allow access, simple access registration database, password pass phone, read codes database, access notes database, selection access, access 2013 email, monthly database access, domain name registration system, email database country

Project ID: #4109042

Awarded to:

jhaynes75

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

$75 AUD in 1 day
(29 Reviews)
6.1

7 freelancers are bidding on average $90 for this 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 days
(619 Reviews)
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 days
(10 Reviews)
4.7
sinfulm3

Hello Sir, kindly check PMB.

$70 AUD in 3 days
(6 Reviews)
3.6
operations808

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

$70 AUD in 3 days
(0 Reviews)
0.0
leonardomsbr

let me help you.

$31 AUD in 1 day
(0 Reviews)
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 days
(0 Reviews)
0.0