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

Kemahiran: Microsoft Access

Lihat lagi: 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

Tentang Majikan:
( 95 ulasan ) Glass House Mountains, Australia

ID Projek: #4109042

Dianugerahkan kepada:


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

$75 AUD dalam sehari
(29 Ulasan)

7 pekerja bebas membida secara purata $90 untuk pekerjaan ini


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

$175 AUD dalam 10 hari
(619 Ulasan)

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

$110 AUD dalam 5 hari
(10 Ulasan)

Hello Sir, kindly check PMB.

$70 AUD dalam 3 hari
(6 Ulasan)

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

$70 AUD dalam 3 hari
(0 Ulasan)

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

$100 AUD dalam 7 hari
(0 Ulasan)

let me help you.

$31 AUD dalam sehari
(0 Ulasan)