Comeau Software Solutions

Making sense of technology since 2000.

Menu
  • Home / Updates
  • Services / Contact Us
  • Rogue C# Project Page
  • More Resources
    • Join Ocala’s Tech Community!
    • YouTube Channel
    • Personal Site
Menu

Category: Database Design

Filtering Combo Boxes in Microsoft Access

Posted on February 1, 2022February 18, 2023 by Andrew Comeau

Combo boxes are extremely useful in Microsoft Access and other design environments. They provide a compact control from which your users can access a drop-down menu that enables them to choose from a variety of options. In my applications, combo boxes often pull their rows from lookup tables such as product or customer lists and…

Read more

Customizing Reports in Microsoft Access

Posted on May 25, 2021January 4, 2023 by Andrew Comeau

In my latest video, I go into more detail about Microsoft Access report settings. This video is also an addition to my tutorial series, Managing Your Data with Microsoft Access which is now free on YouTube. Microsoft Access has always been known for having a great report designer with which you can put together professional…

Read more

Online Course – Managing Your Data with Microsoft Access

Posted on March 17, 2020January 4, 2023 by Andrew Comeau

One of the things I hear about Microsoft Access is that it’s simply too complicated for many people to work with. This is because Access is designed for building database applications that can be used to automate and manage processes. Too few resources approach it from that perspective. This leaves users and students without the…

Read more

Deploying MS-Access Table Design Changes to Remote Files

Posted on August 7, 2019February 18, 2023 by Andrew Comeau

A New Challenge for Access I designed a Microsoft Access database for one of my clients and it’s split into two files – a front-end file with all the forms, reports and code and a back-end file with the tables. That’s pretty standard. During the development process, I needed to make adjustments to the table…

Read more

How to Perform a Basic MySQL Installation in Windows

Posted on January 25, 2019February 18, 2023 by Andrew Comeau

One of the nice features of MySQL as a database software is its noinstall option in which you download the files themselves and perform a manual installation that takes just under a gigabyte of space on your drive.  If you’re a developer or a student, this means you can quickly create a new self-contained instance wherever…

Read more

What is Referential Integrity?

Posted on November 18, 2018February 18, 2023 by Andrew Comeau

One of the fundamental differences between an Excel spreadsheet and a Microsoft Access or SQL Server database is the database’s ability to group data by subject into tables and create links between that information.  This type of organization enables the user to store large amounts of data and retrieve specific information quickly by writing queries that…

Read more

Performing a Basic Install of MySQL or MariaDB in Windows

Posted on May 21, 2017February 18, 2023 by Andrew Comeau

One of the great things about MySQL and MariaDB are their versatility of installation. They can be setup as a Windows services and trimmed out with some extra utilities or it can be installed on a flash drive as a portable server. The easiest installation is certainly the Windows Installer with a wizard for MySQL…

Read more

Calculated Fields in CiviCRM

Posted on June 14, 2016December 27, 2022 by Andrew Comeau

One of CiviCRM’s strengths is the ability to add custom fields to hold specific information about your contacts. One thing it doesn’t offer (yet) is a calculated field type that will present the results of calculations of other fields.  While calculated fields are generally discouraged in relational database design, they are sometimes necessary within a…

Read more

MySQL User Defined Function Example: Data Cleanup

Posted on May 23, 2016February 14, 2023 by Andrew Comeau

(Updated June 9, 2016) The Challenge One of my current projects involves migrating a large amount of data away from an old custom Borland Paradox application into a new CiviCRM system. As with too many quickly-constructed apps, this old Paradox database wasn’t especially well designed and, among other the other challenges in salvaging the data, there were…

Read more

Installing MySQL on Mac OS X El Capitan

Posted on February 23, 2016February 18, 2023 by Andrew Comeau

A few months ago, I wrote about how to install MySQL on Windows with IIS. Now I want to show you how to create an AMP web programming stack (Apache, MySQL & PHP) on Mac OS X. As with Windows, you could just go with a ready-made development environment like MAMP but, if you’re going to be…

Read more
  • 1
  • 2
  • Next

ComeauSoftware.com provides learning resources, including tutorials and videos, to guide you in understanding today's technology. Please check out our YouTube channel and bookmark this site to stay informed of upcoming projects.

Comeau Software Solutions also provides software consultation, including the development of database solutions, in Ocala, Florida. This includes rescuing Microsoft Access database projects and assistance in move to other solutions. Please contact us for more information on how we can help you with your project needs.

Available on Amazon.com


10% Happier Revised Edition: How I Tamed the Voice in My Head, Reduced Stress Without Losing My Edge, and Found Self-Help That Actually Works--A True Story


Dan Harris
  • Articles
  • C#
  • Careers
  • Commentary
  • Database Design
  • Databases
  • Hardware
  • How-to
  • Humor
  • Internet
  • Jobs
  • Linux
  • Microsoft Access
  • MySQL
  • Ocala I.T. Professionals
  • Personal
  • Personal Tech
  • Programming
  • Resources
  • Reviews
  • Rogue C# Series
  • Software
  • SQL
  • Uncategorized
  • Web Design
  • Writing
©2023 Comeau Software Solutions | Theme by SuperbThemes