MS Access Project - Data Formatting/Reporting
5954
$$
- 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 collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies