I need a database created for field inspections

I

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:

  • 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.

About the author

Rich Peterson

I've spent the last 10 years planning, mapping & reimagining the processes of hundreds of SMBs. Whether the goal is more money, more time, more clarity or more customer smiles, my insightful process is worth every minute for my successful clients.
-----------
Disclaimer: I use affiliate links on my website and only recommend what I use, have used or have vetted in the best interest of my readers. I may earn a commission if you click on an affiliate link, but it won’t cost you extra.

By Rich Peterson

About

For the past 10 years, we’ve worked with hundreds of clients and tens of thousands of students to help them get a clear picture of how to systemise their business. We’re not fans of spam, cheap mass-marketing tactics or automating your business to within an inch of it’s life. We are fans of a customer experience where humans deal with humans, skills are appreciated, personality is maintained and where clients get more value than they expected. We’re also fans of automating any process that doesn’t deliver client-facing value in a simple, easy-to-maintain way.

In a nutshell, we provide advice, implementation support & training to small to medium, service-based businesses to help them deliver a better customer experience & a more automated workflow. Everyone on the same page, moving in the same direction with a clear picture of who does what.
----------------------

Recent Posts