Annulé

Create Access Database for a Book Publisher

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

Compétences : Administration de Bases de données, Microsoft Access

Voir plus : publisher company access database, create access database track book sales, sales administration, paypal library, microsoft publisher access, microsoft access publisher, microsoft access database development, microsoft access administration, kindle authors, import administration, e mail lists, e book company be, custom database development, by author, a publishing company, access 2010 purchase order database, access database publisher book, book publisher database, book publishing company access database, lightningsource, list of book and authors, author book lists, vis, order split, Microsoft publisher

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #2382451

21 freelance ont fait une offre moyenne de 586 $ pour ce travail

kulhanekd

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

750 $ USD en 20 jours
(29 Commentaires)
5.7
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 en 21 jours
(7 Commentaires)
4.8
MDavidCrompton

Hi, I have been developing applications in Access and Excel for over 20 years, recently with [url removed, login to view] check feedback - Excel as well as Access. Just completing a database for someone in the States. Feedback du Plus

650 $ USD en 14 jours
(6 Commentaires)
4.7
winnet21

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

550 $ USD en 20 jours
(11 Commentaires)
4.7
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 Plus

1000 $ USD en 30 jours
(19 Commentaires)
4.5
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 en 20 jours
(18 Commentaires)
4.1
amfuries

############# *********** WE HAVE DONE THE SIMILAR APPLICATION PLEASE CHECK THE PM *********** #############

500 $ USD en 5 jours
(2 Commentaires)
3.2
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 Plus

900 $ USD en 10 jours
(1 Commentaire)
2.6
sharpcodernet

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

555 $ USD en 25 jours
(1 Commentaire)
2.6
Gema75

ready to start

750 $ USD en 20 jours
(2 Commentaires)
1.6
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 Plus

250 $ USD en 7 jours
(0 Commentaires)
0.0
DaddyWarbucksEsq

My name is George Panko, dba The Immaculate Collection. I am relatively new to this freelancer site, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining MS Plus

500 $ USD en 14 jours
(0 Commentaires)
0.0
Powerman7000

MS Access Expert here. Try me!

250 $ USD en 7 jours
(0 Commentaires)
0.0
GDH67wOt0

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

750 $ USD en 1 jour
(0 Commentaires)
0.0
swalvekar

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

500 $ USD en 10 jours
(0 Commentaires)
0.0
muhammadibaad

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

450 $ USD en 20 jours
(0 Commentaires)
0.0
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 Plus

750 $ USD en 15 jours
(0 Commentaires)
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 en 20 jours
(0 Commentaires)
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 en 6 jours
(0 Commentaires)
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 Plus

700 $ USD en 10 jours
(0 Commentaires)
0.0