Database Guides

These links connect to how-to articles on our web site. All of them appeared in our twice-monthly newsletter. To receive your own copies by e-mail, please add your name to the list.

Organizing Data for Analysis.
You’ve gathered your data and put it all in the computer. You open your database or spreadsheet anxious to see what secrets it reveals. Then frustration — no matter what you do you can’t produce the analysis you had expected. Why, everything that’s needed seems to be there? Learn How to Structure Data for Analysis.

Building Relationships.
Our world is built on relationships. The same is true with data we collect and generate. Sometimes we want to connect clients with projects, other times with invoices and payments. Having a system with the flexibility to do both is critical, otherwise we are plagued by needless duplication and the errors that inevitably brings. That is why relational databases are so useful. Learn How to Build Relationships Between Database Tables.

Looking for More?

We offer public and private classes and database consulting.

Public classes.
Five database classes are offered every month: Mastering Access, Advanced Access, Mastering FileMaker Pro, Advanced FileMaker Pro and SQL. See our Class Schedule for dates and pricing.

Private Classes.
Schedule a private class for your team with a custom curriculum that emphasizes topics of greatest interest to your group. It can include subjects from any of our classes.

Consulting.
We can also provide consulting services for people who need advice or hands-on projects assistance.