I’m thinking of creating a Microsoft Access Data Base to record site records for field inspections. Is this the best option?
Each Field Site item with have:
Location description
Location details
Provide for linking to site maps
Allow for 100 sites
Each site item will have:
A drop down Description
A drop down Condition
A date of inspection
GPS Location
Allow for 20 items per site
Provide for linking to photographic records
Provide for linking to documents
Provide site and item work history
Provide for history of person making amendments or adding data
Provide for record printing. i.e. summary site report
Answer
You could set up your files in Access or using Airtable but you may also want to look at setting it up using a tool like iAuditor to automate the report-creation process. You should be able to do what you want on the free plan and you could have reports sent to your Dropbox via email upon completion. Final option would be to have a custom app set up in Podio with the output being a pdf document created using Globiflow or having the information flow, via Zapier, to Webmerge to pre-fill a Word document.
Ensure you’re capturing client information in an engaging way so you don’t lose customer leads. Make your online forms an integral part of your sales process. We offer the following lead generation forms (customised to suit your needs): Health insurance quote form Mailing list sign up form Online mortgage application form Vendor contact information form …
There are some parts of my job that sound so boring to my children that I should tell them about my day as bedtime stories. Building better systems and processes is one of them. Integrating apps is another. But the winner? Building intranets for businesses. For most people in a corporate environment (including myself), the …
Thanks for the answer request. What you’ve got: Not much money No real skills What you want: To start a business I’m taking a wild guess on this one that you either had a bad experience working for someone else, are looking for more of a lifestyle business or love Shark Tank… or all three …
I need a database created for field inspections
Further details of question
I’m thinking of creating a Microsoft Access Data Base to record site records for field inspections. Is this the best option?
Each Field Site item with have:
Each site item will have:
Answer
You could set up your files in Access or using Airtable but you may also want to look at setting it up using a tool like iAuditor to automate the report-creation process. You should be able to do what you want on the free plan and you could have reports sent to your Dropbox via email upon completion. Final option would be to have a custom app set up in Podio with the output being a pdf document created using Globiflow or having the information flow, via Zapier, to Webmerge to pre-fill a Word document.
Related Posts
Lead Generation Form Template Options
Ensure you’re capturing client information in an engaging way so you don’t lose customer leads. Make your online forms an integral part of your sales process. We offer the following lead generation forms (customised to suit your needs): Health insurance quote form Mailing list sign up form Online mortgage application form Vendor contact information form …
It’s not called an intranet
There are some parts of my job that sound so boring to my children that I should tell them about my day as bedtime stories. Building better systems and processes is one of them. Integrating apps is another. But the winner? Building intranets for businesses. For most people in a corporate environment (including myself), the …
What is the best business to start with the lowest overhead if I don’t have a lot of money and no real skills?
Thanks for the answer request. What you’ve got: Not much money No real skills What you want: To start a business I’m taking a wild guess on this one that you either had a bad experience working for someone else, are looking for more of a lifestyle business or love Shark Tank… or all three …