Đang Thực Hiện

MS Access/sql reports from Spiceworks app

Objective

To automate the emailing of client reports. To provide a billing report.

Overview

As a small IT support company we require some report add-ons to our current call logging system – Spiceworks. Spiceworks is a free system where we utilize the helpdesk portion only.

Direct access to the database can be done through an ODBC connection (sqlite3 driver). Spiceworks is currently running on a Small Business Server 2003 server on premises. The reports needed, must be added to a separate system. This could be MS access, but other recommendations can be made.

Database to include:

1. Customer table - client details, maintenance contract details, hourly rate for desktop support and server support, labour hours carried. Contract client y/n, contract value, available hours, services.

2. Services table, services: firewall Management, domain hosting, Internet Access, BackIT,

3. Company table – Our company details, company logo change option

4. Table links to [url removed, login to view] (Live data/copy of)

5. Forms to add/edit data.

Report requirements:

1. Individual Reports by client name (Will be given to each client), listing all calls for the month and details of each call. Also to include total hours utilized for the month. Then a calculation illustrating contract hours, less used hours. Hours over contract to be billed and hours not utilized. Calculation also needs to include any hours carried forward from the previous month. Hours are only carried to the following month for 6 months, then fall away.

2. Single report by client containing contract value, hours over contract for the month for all contract clients. Non-contract client hours to be billed, Equipment supplied & services. This is used for billing purposes.

The client reports need to be auto emailed or alternatively output to a pdf file. If file output, the name of the file needs to match the client name or be constant. This can then be picked up by [url removed, login to view] which is a free email sending app which gets run in a batch file.

Note

I am a network engineer, not a programmer. I have only guesstimated the tables required to give a better understanding of what is needed. I have accessed the Spiceworks database from MS Access quite easily, but do not have the skills to compile the queries and reports in a professional manner.

Future Projects (Not in this project)

Moving forward, we will be looking at producing the client reports from our website, with a client login and the reports accessible from there. We are also looking at automating the billing. So the system would produce and email the invoice. An output file would then be created to import the invoices into the accounting system.

Kỹ năng: Microsoft Access, MySQL, Kiến trúc phần mềm

Xem thêm: access spiceworks sql reports, which company need a engineer, what support will i need from management, what skills do i have, what is needed to be an engineer, what is client services, what is business services accounting, we provide accounting services, sql programmer software, sql programmer hourly rate, sql pdf file, sql overview pdf, sql database programmer, sql database business, small network it services contract, skills required for accounting, skills needed for a professional programmer, sending invoices, sending invoice, sending an invoice, project management hourly rate, project management engineer, programmer sql, professional services contract, professional email services free

Về Bên Thuê:
( 0 nhận xét ) Sandton, South Africa

Mã Dự Án: #1680290

16 freelancer đang chào giá trung bình R4345 cho công việc này

srinichal

I look forward to discuss and deliver the project

R5250 ZAR trong 18 ngày
(53 Đánh Giá)
6.6
rhomeu

MS Access expert here. Please check my profile. Thanks

R3500 ZAR trong 7 ngày
(40 Đánh Giá)
6.5
Krusche

Working with external databases from MS Office applications is exactly one of our core competences in terms of VBA. Please check the PMB.

R5000 ZAR trong 7 ngày
(9 Đánh Giá)
5.3
winnet21

I have experience in this project, I will do it quickly

R1750 ZAR trong 10 ngày
(15 Đánh Giá)
5.2
sikandermandal

Please see PMB.

R5200 ZAR trong 10 ngày
(10 Đánh Giá)
4.7
VBAWhizz

Hi, I am a Cape Town based freelancer with 20 years of Access database design and programming experience. I have lots of experience in client databases and emailing reports directly from these databases. Please see y Thêm

R3500 ZAR trong 7 ngày
(7 Đánh Giá)
4.7
KellogITSolution

Hello Me an Ms-Access Expert working on MS-Access & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample c Thêm

R1750 ZAR trong 5 ngày
(22 Đánh Giá)
4.3
jeanek

Hello. I am an MS Access expert with a UK BSc. Computing degree, and over eight years of professional IT work experience. Please refer to my private message for further information on my bid. Thank you. Kind regards.

R3900 ZAR trong 21 ngày
(3 Đánh Giá)
3.4
shagoon2u

Experts are ready to start immediately

R4000 ZAR trong 7 ngày
(1 Đánh Giá)
2.2
T89bDNv2S

Custom Software Development - <b><i>Removed by Admin</i></b>

R5250 ZAR trong 1 ngày
(0 Đánh Giá)
0.0
P5C768

I have completed projects very similar to this in the past and I am confident I can help you with this one. It sounds like you will provide a static data set for the development and then complete the ODBC connection y Thêm

R4172 ZAR trong 5 ngày
(0 Đánh Giá)
0.0
EdDrakes

With the length of experience I have, I am sure I can cover your requirements except in the "future" zone requiring Access reporting from a web site.

R10000 ZAR trong 14 ngày
(0 Đánh Giá)
0.0
tahirsiddiqui786

I already developed reports in access 2007 for my accounts and inventory system currently running in industry.

R5250 ZAR trong 30 ngày
(0 Đánh Giá)
0.0
pawanyadav777

hi sir Dolphinesoft is a professional Software Development Company providing complete IT solutions. website designing, software development and internet marketing and full featured web services including B2B and B2C e Thêm

R4000 ZAR trong 21 ngày
(0 Đánh Giá)
2.8
huzaifaatlancer

Hi, please check you pm!

R1750 ZAR trong 5 ngày
(0 Đánh Giá)
0.0
samkusoma

I have been doing this in University for 5 years of my study there I am a graduate Engineer with a speciality in Electronics and Computers. I have attached my Thesis that you can have a look at and let me know. I Thêm

R5240 ZAR trong 4 ngày
(1 Đánh Giá)
0.0