Great answer, James. I'll have to check out Google sheets.
John Viescas, Author
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
On Jul 11, 2016, at 9:26 PM, James McAlister firstname.lastname@example.org [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Zach (now that I know your name!),
I failed to mention that after my downloads I did all of my analysis and reporting in Access since it was easy to set up a basic set of reports and then choose different queries as needed. There are plenty of real experts here (not me for sure!) who can help you with that.
On Mon, Jul 11, 2016 at 2:21 PM, James McAlister <email@example.com> wrote:
John has give you an authoritative answer on using Access for your project and also mentioned Filemaker as a potential but expensive option. So let me make a few comments about Filemaker.Filemaker will do exactly what you want, and you can download a 30-day free trial of Filemaker Pro to just check out the the basic capabilities. To do any real programming, however, you'd need Filemaker Pro Advanced, and there's no trial available for it. To deploy on mobile you'd also need their Filemaker Server product and the hardware and expertise to set it up properly and keep it running or else rent space from a company that specializes in Filemaker hosting. Then you could deploy to mobile after all of the necessary database design for layouts suited for the mobile devices which will have access. Once all of that is done properly mobile access is easy and effective. The Filemaker website has lots of videos describing all of this, and you can pick up some ideas there. Plus, there's a pretty good (and free) customizable template at www.fmstartingpoint.com. Given that you're only working there for the summer, I wouldn't go this route because of the learning curve and initial investment. Long term, however, it could be viable.On the other hand, you might be able to do something with free Google Sheets (easily deployed on mobile) for basic data collection and regularly download the data for analysis, reports, etc., in Access. Or you might do something similar with Airtable (www.airtable.com).Even though I use Filemaker daily for a variety of tasks, I opted for Google Sheets (quick and easy and free) this spring to deploy voter lists to a large number of field workers to mark up as they had made their contacts. Afterward I would download the marked version and prepare reports for the candidate. Not ideal, but it worked well for the short term.Whatever you do, security of your data is always an issue.Just my two cents worth. :-)JamesOn Mon, Jul 11, 2016 at 1:23 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:The trick is getting it on mobile. FileMaker can do it - but it's expensive. Access *might* be able to do it with a web app, but you'd need a Windows Sharepoint server at your disposal.Sorry to be such a downer, but IMO the technology isn't there yet to make it easy to build a mobile solution using Access.John Viescas, AuthorEffective SQLSQL Queries for Mere MortalsMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access Applications(Paris, France)On Jul 11, 2016, at 4:33 PM, firstname.lastname@example.org [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Posted by: John Viescas <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (7)|
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.