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.
Looking into sales dashboard software that can connect to various data sources. Some options include: Geckoboard Klipfolio Blitzrocks Plecto Boxiqq Comparing a wide range of sales dashboard options showed me that it’s hard to find a simple software program that isn’t enterprise in pricing or look, that has the basic features + a few extra …
I love health food stores and especially the ones where you feel less like you’re on the outside and more like you’re part of the family. In doing some innovation work for a health food store, let’s have a look at ways to experiment with their business model. Ideas include: Starting a paid membership program …
A CRM for a financial planning business in Australia needs to meet the unique needs of the financial services industry. Using the latest, secure, hosted solutions, we develop custom financial advice practice CRMs that allow you to: Track sales leads Manage financial planning clients Create an intranet for employees to view Standard Operating Procedures (SOP), …
There comes a stage in every business where they need to upgrade their email and ensure their whole team is using email as efficiently as possible. For some teams, it’s setting up a Gsuite account and getting personal emails for the team but for other teams, especially the ones that was instant transparency with their …
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
Business Dashboard Software For Tracking Sales Commissions Comparison
Looking into sales dashboard software that can connect to various data sources. Some options include: Geckoboard Klipfolio Blitzrocks Plecto Boxiqq Comparing a wide range of sales dashboard options showed me that it’s hard to find a simple software program that isn’t enterprise in pricing or look, that has the basic features + a few extra …
10 innovative ideas for a health food store
I love health food stores and especially the ones where you feel less like you’re on the outside and more like you’re part of the family. In doing some innovation work for a health food store, let’s have a look at ways to experiment with their business model. Ideas include: Starting a paid membership program …
The unique needs of a financial planning CRM
A CRM for a financial planning business in Australia needs to meet the unique needs of the financial services industry. Using the latest, secure, hosted solutions, we develop custom financial advice practice CRMs that allow you to: Track sales leads Manage financial planning clients Create an intranet for employees to view Standard Operating Procedures (SOP), …
Our team needs a shared inbox, what do we use?
There comes a stage in every business where they need to upgrade their email and ensure their whole team is using email as efficiently as possible. For some teams, it’s setting up a Gsuite account and getting personal emails for the team but for other teams, especially the ones that was instant transparency with their …