Đang Thực Hiện

135450 E4 Access Database


i publish 2 small monthly local magazines (TNCD and TSCD), with a mix of existing customers and new customers normally boking advertising space for a 3 month period in advance, sometimes just booking for one month at a time - invoices are sent out every month

i curently use excel to store data, but want to now use access

i made a start by creating 3 tables and relationships in the db (see attached file) and need the following: (please let me know if you think the fields in the tables need modifying)

a table (new table? or add to one of existing tables?) to create a sales ledger with a form to add data recording customer sales invoices and record payments received from customers

a form to enable data entry and a new record created for new customers, and new sales orders, with a command button generating a report showing details for a new order so as i can print and send to customer to confirm his order showing size of space booked, for number of months, production fee (if any) in what edition of the magazine ie TNCD or TSCD or both as well as invoice amount (if i have an email address for the customer i currently send confirmation via email - is it possible to generate text straight into an email from the report, if not then a command button to export it to a text file or word document so as i can manually copy and paste it into an email

a form to enable generation of a report and to print the months invoices in a 'batch' rather than having to create and print one at a time which i currently do! also ability to view an old invoice (eg customer not recieved) and print again a a 1 off

a report showing sales for month (option to choose to view for any month ie 2 months ago, current month, next month etc) and year sales totals for each magazine and for both, as well as page totals for monthly sales of advertisg space ie may 07 sales of �1000 and 16.75 pages of advertising space sold for TNCD and sales of �900 and 15.50 pages of advertising space sold for TSCD

a report showing current outstanding accounts, with amounts owed per customer and totals

database not locked in any way, as i will need to be able to run my own queries, reports, and modifiy the layout of forms and reports etc, and ability to export data to a spreadsheet, and ability to import data to an existing table and to a new table

Kĩ năng: Bất kì công việc gì, Microsoft Access

Xem nhiều hơn: what is database entry, what is a data entry form in a database, what are data entry forms, well now magazine, want to create my own database, production spreadsheet, paste magazine, old database, microsoft access data entry forms, microsoft access data entry form, i need an access database, db import export, data entry form in access, creating data entry forms in access, creating an access form for data entry, creating a data entry form in excel, creating a data entry form in access, create data entry form access, create an access form for data entry, batch data entry, access db forms, access database data entry form, 1000 word document, time magazine layout, customer database in excel

Về Bên Thuê:
( 0 nhận xét ) paris, France

ID dự án: #1881622

Được trao cho:


Please see PMB for details.

$150 USD trong 7 ngày
(0 Đánh Giá)