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: SQL

Calling Parameter Queries in Microsoft Access VBA

Posted on November 4, 2023November 4, 2023 by Andrew Comeau

Microsoft Access parameter queries enable you to pass criteria from outside a query. This article shows how they can be called from VBA.

Read more

5 Reasons You Should Learn SQL

Posted on January 22, 2022February 18, 2023 by Andrew Comeau

Let me tell you a story … In 2002, I was interviewing for a database support position and feeling pretty good about my chances. I’d been working with Microsoft Access for a few years, everyone at the last job knew me as the expert and general tech guru and I was hoping things panned out…

Read more

New Video – Learning SQL with SQLite

Posted on June 14, 2021July 28, 2021 by Andrew Comeau

An essential skill … If there is one programming language that I would recommend for everyone, it’s Structured Query Language (SQL). SQL (often pronounced “sequel”) is the main language used to communicate with databases including Oracle, SQL Server and Microsoft Access. It’s the set of commands used to write and retrieve data. If you work…

Read more

Recovering a Corrupted Table in Access With VBA

Posted on November 16, 2019December 2, 2019 by Andrew Comeau

Recently, a client started experiencing errors, seemingly at random, in the database application I managed for them. The errors immediately started mentioning corruption and then these came through … Error 3167 – Record is Deleted Getting everyone out of the system and running a Compact / Repair seemed to help, but then … “The Microsoft…

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

How to Convert Between Decimal and Binary in T-SQL

Posted on February 21, 2018November 9, 2022 by Andrew Comeau

For the past six months, I’ve been teaching night classes in database programming and my students are just about ready to take Microsoft’s 98-364 exam. Now, we’re transitioning over to C# programming for the next phase of the program but I have to keep their SQL skills fresh for the exam.  Tonight, it was time to…

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

Importing Case Data into CiviCase

Posted on June 8, 2016February 14, 2023 by Andrew Comeau

Migrating to CiviCase On a recent project, I setup CiviCRM and CiviCase to enable a local organization to better manage its client database. The old database had been developed in Borland Paradox and was quickly becoming unusable. As a free and open source solution, CiviCRM turned out to be just the solution needed to accommodate this…

Read more

Data Analysis with Microsoft Access

Posted on May 26, 2013February 14, 2023 by Andrew Comeau

Tackling the Data One of the strengths of Microsoft Access is its ability to import and link to data from different sources.  With Access you can also query and report on the data in ways that a spreadsheet program like Excel doesn’t readily provide.  This can come in handy as part of a database application…

Read more

ComeauSoftware.com provides learning resources, including tutorials and videos, to help 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 data solutions, in Ocala, Florida. This includes help with Microsoft Access database projects and assistance in moving to other solutions when needed. Please contact us for more information on how we can help you with your project needs.

Available on Amazon.com


The Self-Taught Programmer: The Definitive Guide to Programming Professionally


Cory Althoff
  • 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