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.
I recently put together a short course on all the top hosted website builders that you can use to develop your website. The main reason for creating the course was to save people time in evaluating the hundreds of options for developing an easy-to-manage website. Some of my main findings were: You often have to compromise on …
David Allen, the author of Getting Things Done, coined the term to describe one of the core steps of his “fundamental process”: Write down a project or situation that is most on your mind at this moment. Now describe in a single written sentence your intended desired outcome for this problem or situation. What needs …
I feel your pain on this one. Although it’s become so much easier to create and send out email newsletters using tools like Mailchimp, Mailmunch, Convertkit and Drip, it’s still quite fiddly to look through all the specs, work out the pricing (do I pay per list or per subscriber?) and then look at the …
Paint two pictures. The business x10 with your current systems and the business x10 with different systems choices. There are some insightful tools that a systems adviser uses to help you see your business from different angles and perspectives. Using these tools, they can give you a snapshot of how your whole boat sails today …
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
Why be a Weebly Designer in Australia?
I recently put together a short course on all the top hosted website builders that you can use to develop your website. The main reason for creating the course was to save people time in evaluating the hundreds of options for developing an easy-to-manage website. Some of my main findings were: You often have to compromise on …
Fundamentals: Next Action Step
David Allen, the author of Getting Things Done, coined the term to describe one of the core steps of his “fundamental process”: Write down a project or situation that is most on your mind at this moment. Now describe in a single written sentence your intended desired outcome for this problem or situation. What needs …
I hate email marketing but want to publish a free newsletter
I feel your pain on this one. Although it’s become so much easier to create and send out email newsletters using tools like Mailchimp, Mailmunch, Convertkit and Drip, it’s still quite fiddly to look through all the specs, work out the pricing (do I pay per list or per subscriber?) and then look at the …
Paint two pictures
Paint two pictures. The business x10 with your current systems and the business x10 with different systems choices. There are some insightful tools that a systems adviser uses to help you see your business from different angles and perspectives. Using these tools, they can give you a snapshot of how your whole boat sails today …