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

en 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 font une offre moyenne de $586 pour ce travail


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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(29 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 21 jours
(7 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(6 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(11 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(19 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(18 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(1 Évaluation)

ready to start

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(0 Commentaires)

MS Access Expert here. Try me!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)