MS Access Project - Data Formatting/Reporting
5240
$$
- Posted:
- Proposals: 6
- Remote
- #897
- Archived
Description
Experience Level: Intermediate
We are a small electrical contractors, and our engineers carry out electrical inspection and testing, parts of our inspection and testing work are carried out on a palmtop computer and we want to automate the reporting process.
--
currently the process is as follows.:
- engineers input data in to pocketaccess on a palmtop computer
- this file is then transferred to PC via Microsoft ActiveSync, which converts the file to a ms access file
- this file then needs to be formatted to populate a industry standard form (we currently export this data manually and drop it into an Excel spreadsheet)
- this spreadsheet is then printed and added to a collection of word documents (standard terms and condition of business, important information, and quality assurance sheets)
- the office staff then manually input the customer and address details into a word template to print onto a pre-printed certificate.
- -
We want to automate this, so the engineer inputs the address on the palmtop, then all of the inspection details, comes back to the office uploads the file, runs the software/access and hits print so the whole process is automated.
--
Your ideas are appreciated.
We can supply:
- example templates
- example files
- copies of logos
- copies of inspection forms and certificates.
--
I look forward to hearing from you.
--
currently the process is as follows.:
- engineers input data in to pocketaccess on a palmtop computer
- this file is then transferred to PC via Microsoft ActiveSync, which converts the file to a ms access file
- this file then needs to be formatted to populate a industry standard form (we currently export this data manually and drop it into an Excel spreadsheet)
- this spreadsheet is then printed and added to a collection of word documents (standard terms and condition of business, important information, and quality assurance sheets)
- the office staff then manually input the customer and address details into a word template to print onto a pre-printed certificate.
- -
We want to automate this, so the engineer inputs the address on the palmtop, then all of the inspection details, comes back to the office uploads the file, runs the software/access and hits print so the whole process is automated.
--
Your ideas are appreciated.
We can supply:
- example templates
- example files
- copies of logos
- copies of inspection forms and certificates.
--
I look forward to hearing from you.

Jamie M.
99% (18)Projects Completed
34
Freelancers worked with
29
Projects awarded
17%
Last project
4 Nov 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy