Skip to content

Comeau Software Solutions

Helping you make sense of technology.

  • Home / Contact Us
  • Blog
  • Current Projects
    • New Book! Self-Guided SQL with SQLite
    • Rogue C# Project Page
  • More Resources
    • Find us on Facebook
    • Privacy Policy
  • YouTube Channel

Comeau Software Solutions  provides software consultation, including the development of database solutions. 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.

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


Self-Guided SQL: Build Your SQL Skills with SQLite

Early Release edition
now available on LeanPub!

Search Results for: Microsoft Access

Microsoft Access
Calling Parameter Queries in Microsoft Access VBA

November 4, 2023

0

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
Databases
Editing Excel Worksheets with Microsoft Access

November 2, 2023

0

It’s actually possible to populate specific cells in an Excel worksheet with information from your Access database. Here’s how you do it.


Read More
Databases
Connecting Microsoft Access to MySQL

July 3, 2022

0

In my latest video, I demonstrate how to use Microsoft Access as a front-end for MySQL without having to create a DSN entry on the client machine. Access easily connects to MySQL through an ODBC connection but the standard practice is to create a dedicated data source under the ODBC Data Sources Administration panel in […]


Read More
Database Design
Filtering Combo Boxes in Microsoft Access

February 1, 2022

0

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
Database Design
Customizing Reports in Microsoft Access

May 25, 2021

0

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
Databases
Splitting a Database in Microsoft Access

March 23, 2021

0

My latest video shows how to split a database in Microsoft Access to separate the data from the user interface and programming elements. Access can link to data from different file formats including Excel, text files and other Access databases. For multi-user applications, you can have an Access file with just the forms, reports, queries […]


Read More
Database Design
Online Course – Managing Your Data with Microsoft Access

March 17, 2020

0

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
Databases
Should You Keep Using Microsoft Access?

November 11, 2019

0

Full Disclosure – I Owe My Career to Access I’ve been working with Microsoft Access off and on since 1997, just a few years after it was first introduced in ’92. I can realistically say that learning Access made my career in I.T.. I’d had some previous programming and database experience with Borland Paradox and […]


Read More
Databases
How to Shut Down Remote Instances of Microsoft Access

November 6, 2019

0

When you’re managing a multi-user Microsoft Access application, there are times when you need all users out of the database so that you can make changes to table structures and other items. Asking everyone to shut down is unreliable and using the Windows Task Manager to forcibly shut down instances of Microsoft Access is risky […]


Read More
How-to
Helping Users Work With Subforms in Microsoft Access

March 19, 2019

0

Creating an Access application for other people means anticipating how the users are going to interact with your program. Without clear direction from the program or you, users can be easily confused by even simple things like the order in which data is to be entered. One of the basic tools in Access is the […]


Read More
  • 1
  • 2
  • 3
  • …
  • 6
  • Home
  • Contact Us
  • Privacy Policy

Contact Info:
Comeau Software Solutions
P.O. Box 770253
Ocala, Florida 34470

Email: services@comeausoftware.com

© Comeau Software Solutions, 2025. (Theme: WP Minimalist) Free Theme By BlazeThemes.