Đ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 [url removed, login to view] pages of advertising space sold for TNCD and sales of �900 and [url removed, login to view] 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 thêm: well magazine, want create database, production spreadsheet, paste magazine, old database, batch data entry, time magazine layout, think straight, ledger, database queries, access reports data entry, customer details database, generate reports excel, creating access database forms, database invoice microsoft access, create access database spreadsheet, requirements time table generation, customer invoice report, access creating reports, excel access table, publish advertising, create file table access, access order, excel sales monthly report, sales report access

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

Mã Dự Án: #1881622

Đã trao cho:


Please see PMB for details.

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