Create Access Database for a Book Publisher

Storniert Veröffentlicht Aug 6, 2012 Bezahlt bei Lieferung
Storniert Bezahlt bei Lieferung

I run a small book publishing company, but managing everything off a spreadsheet has become unwieldy. I tried learning Access 2010, but I quickly got bogged down and confused. So now I'm stuck running things off a spreadsheet and a database. It takes a week every time I have to figure quarterly taxes or royalties. I need help.

The database you create must:

• Split out payments for orders and purchase orders to apply the correct amount of profit to each book ordered

• Track sales of each title by number of units sold

• Track sales of each title by profit

• Track expenses for each order

• Track progress of a title toward breakeven vis-à-vis development costs

• Track each title’s development costs

• Track each title’s publishing information

• Track royalties already paid

• Track and figure royalties owed (by title, by author, by quarter, and by year)

• Track purchase orders coming in

• Track purchase orders fulfillment costs

• Track purchase orders payments received

• Track purchase orders profits (total and by book and author)

• Track expenses across all categories

• Track payments and income from all channels

• Give me taxes owed at the click of a button (for quarter and year and sales tax)

• Track customers, including total purchase history

• Generate custom e-mail lists/reports from customers

• Separate when sales happened from when those sales were paid for

• List and track authors

• Track author sales expenses

• Track author sales income (and be sure those profits don’t figure into royalties)

• Track PayPal fees

• Generate invoices that can be sent to bookstore and library customers

• Import reports from Paypal

• Import reports from Snowfall Press (printer)

• Import reports from LightningSource (printer)

• Import reports from Kindle/Amazon

• Import reports from Sony/Nook

• Import reports from Kobo

• Connect payments for Amazon/LSI with breakdown of Amazon/LSI sales from months earlier

• Generate taxes owed at the press of a button

• Generate royalties owed at the press of a button

Datenbankverwaltung Microsoft Access

Projekt-ID: #2382451

Über das Projekt

20 Vorschläge Remote Projekt Aktiv Aug 11, 2012

20 Freelancer bieten im Durchschnitt $590 für diesen Job

NourElDeen

Dear SIR, We Are An Expert Team Of Developers, In This Type Of Program In Real life, We Can Do This Job Perfect For You.

$500 USD in 20 Tagen
(57 Bewertungen)
5.5
kulhanekd

I have 15 years exp in access design. I can create the database you need. thanks Donna

$750 USD in 20 Tagen
(35 Bewertungen)
5.8
winnet21

Hi, I have experience with this project I am very happy to work with you in this project Best regards winnet21

$550 USD in 20 Tagen
(20 Bewertungen)
5.4
Krusche

Hello. We are a German Company with a team of 3 dedicated VBA developers and we've done the similar projects. Please check your PMB.

$900 USD in 21 Tagen
(7 Bewertungen)
4.8
frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Please see attached sample application that how much user friendly Mehr

$1000 USD in 30 Tagen
(19 Bewertungen)
4.5
mrintelligence

Look for LIVE DEMO in PMB

$501 USD in 20 Tagen
(3 Bewertungen)
3.3
sharpcodernet

Hi, .NET developer with 7+ years of experience is ready to help you. Please, check PMB for more details. Thanks.

$555 USD in 25 Tagen
(1 Bewertung)
2.6
bgill

I have plenty of experience with access. Wokring with other dbs for 4 years and access for 3. Also I was a teaching assistant for a university level access course. I just completed a intense access project on Freelan Mehr

$900 USD in 10 Tagen
(1 Bewertung)
2.6
Gema75

ready to start

$750 USD in 20 Tagen
(4 Bewertungen)
2.3
freejw2000

What you need is a database plus user interface in Access. I have database design, administaration experience, and Access development experience.I had built a complete system for a foreign currecy trading company from Mehr

$750 USD in 15 Tagen
(0 Bewertungen)
0.0
muhammadibaad

Sir, I have expertise in Database application development and implementation,for more detail,plz check pmb. Thanks

$450 USD in 20 Tagen
(0 Bewertungen)
0.0
GDH67wOt0

Custom software development - <b><i>Removed by Admin</i></b>

$750 USD in 1 Tag
(0 Bewertungen)
0.0
salmanazhar1221

I totally understand your projects and I have recently made similar software (vb + access) which was capable of stick handling, producing reports, recording transactiins, cash balances, keeping record of debtors and cr Mehr

$250 USD in 7 Tagen
(0 Bewertungen)
0.0
Powerman7000

MS Access Expert here. Try me!

$250 USD in 7 Tagen
(0 Bewertungen)
0.0
swalvekar

I have experience in MS Access so I would like to take up this project. Thank you

$500 USD in 10 Tagen
(0 Bewertungen)
0.0
Ivcha92

We are new software development group. Our priority of development is database oriented. We have an interesting offer for you. Check your PM for more details

$600 USD in 20 Tagen
(0 Bewertungen)
0.0
korayerguven

I am exprienced in Ms Access for 10 years. I will do the job as soon as possible. Please give me a chance.

$250 USD in 6 Tagen
(0 Bewertungen)
0.0
hq007

Hello there, I am working in Relational Database Management System since 1998. and created hundreds of projects of hospitals , traders, distributers, retailers, schools, property dealers. For More see my skills. Than Mehr

$700 USD in 10 Tagen
(0 Bewertungen)
0.0