Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Looking for advice re: Mac-friendly CRM and SQL
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="pmachalek" data-source="post: 725695" data-attributes="member: 67497"><p>I run a company currently comprised of me and two business partners. The three of us operate out of our respective homes. I'm the primary business builder, but ideally all three of us should have access to our prospect and client data.</p><p></p><p>All three of us have Macs.</p><p></p><p>Currently, I have a very clunky system of tracking customer data in Excel spreadsheets. I also do our books with QuickBooks. As a result, I do way too much redundant and repetitive busywork because none of my stuff is cross-referenced.</p><p></p><p>I really, really want to set up a SQL-style database so that I can pull in all of my existing data and cross-reference it with itself so that I never have to enter a person's data more than once. And I'd love to get this database online so that my partners can access it. But I would need to protect it from hacking.</p><p></p><p>In an attempt to facilitate this, I just downloaded MySQL. But, having done that, I don't know how to proceed. And to be honest, I don't know if it makes sense for me to have taken the step of downloading it in the first place.</p><p></p><p>Years ago, before I switched over to Mac, I learned and really enjoyed Microsoft Access. I would love to use a tool like this to create my database. I am not a programmer, but Access is intuitive enough for me to be able to use it pretty well.</p><p></p><p>Does anybody have any advice for me? Am I being silly in wanting to design a database? Should I just buy a Mac-friendly CRM package? Is there a Mac-friendly CRM package that has bookkeeping functionality as well?</p></blockquote><p></p>
[QUOTE="pmachalek, post: 725695, member: 67497"] I run a company currently comprised of me and two business partners. The three of us operate out of our respective homes. I'm the primary business builder, but ideally all three of us should have access to our prospect and client data. All three of us have Macs. Currently, I have a very clunky system of tracking customer data in Excel spreadsheets. I also do our books with QuickBooks. As a result, I do way too much redundant and repetitive busywork because none of my stuff is cross-referenced. I really, really want to set up a SQL-style database so that I can pull in all of my existing data and cross-reference it with itself so that I never have to enter a person's data more than once. And I'd love to get this database online so that my partners can access it. But I would need to protect it from hacking. In an attempt to facilitate this, I just downloaded MySQL. But, having done that, I don't know how to proceed. And to be honest, I don't know if it makes sense for me to have taken the step of downloading it in the first place. Years ago, before I switched over to Mac, I learned and really enjoyed Microsoft Access. I would love to use a tool like this to create my database. I am not a programmer, but Access is intuitive enough for me to be able to use it pretty well. Does anybody have any advice for me? Am I being silly in wanting to design a database? Should I just buy a Mac-friendly CRM package? Is there a Mac-friendly CRM package that has bookkeeping functionality as well? [/QUOTE]
Verification
Name this item 🌈
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Looking for advice re: Mac-friendly CRM and SQL
Top