Category Archives: MS Access General Information

How to Design Clean Forms in Microsoft Access

You open a form and something feels off. There are fields everywhere. Nothing stands out. You are not sure where to begin. That feeling is common, and it usually comes from the same root cause. The form is trying to do too much at once.

A clean form does not try to impress. It tries to guide. When it works well, users stop thinking about the form and just do their work.

Start with one clear goal

Every good form begins with a simple decision. What is this form meant to do. Not two things, not five things, just one.

It might be entering a new client, updating an order, or reviewing a record. That single purpose should drive every choice that follows. When you are clear on the goal, it becomes easier to decide what belongs on the form and what does not.

If you feel the need to keep adding fields or actions, it is often a sign that you are solving more than one problem. That is the moment to pause and split the experience. Two simple forms will almost always work better than one overloaded one.
 

Make it easy to scan

When a form opens, users do not read it right away. They scan it. Their eyes look for structure, for a starting point, for some kind of flow.

This is where layout matters more than people think. When fields are aligned and spaced well, the form starts to feel predictable. Labels sit close to their inputs, so there is no confusion about what belongs where. Related fields are grouped together, which helps users process information in small chunks instead of one large block.

Space plays an important role here. Without space, everything blends together. With just enough space, each section gets room to breathe. The form feels calmer, and that calm feeling makes it easier to use.

A good test is quick. Open the form and look at it for two seconds. If the structure is not clear right away, the layout needs work.
 
Continue reading

Access – Playing With Database Properties – Part 2

I while back I publish about Database Properties:

In this post I thought I’d simply provide a listing of the common properties (you know the ones we see in the File -> Options -> Current Database dialog) with their relevant information so you as a developer can automate them without needing to search endlessly for property names, types, value as I have never found any proper documentation on the subject from Microsoft (or anywhere else).
 
Continue reading

Understanding Data Normalization: Bringing Order to Database Chaos

Data normalization represents a sophisticated approach to database design that transforms chaotic, unstructured information into a streamlined, efficient system. Much like an architect carefully plans a complex building, database professionals use normalization to create robust, intelligent data structures that can adapt and scale with organizational needs.
 

Understanding the Data Dilemma

Imagine a small business tracking customer orders using a single, massive spreadsheet. Every time a customer places an order, their complete details are rewritten: name, address, contact information, along with product specifics and pricing. This approach quickly becomes a nightmare of redundancy, inefficiency, and potential errors. Normalization emerges as the elegant solution to this complex problem. It’s not just a technical process, but a strategic methodology for organizing information in a way that minimizes redundancy, maximizes data integrity, and creates a flexible foundation for future growth.

Consider a scenario where a customer’s telephone number is repeated with every single order. If that customer changes phone numbers, you’d need to update dozens or hundreds of records manually. Normalization eliminates this complexity by storing core information in a single, authoritative location.
 
Continue reading

Working With Dates and Times

This is something I’ve been wanting to do for quite a while, that is, to create a page dedicated to working with Dates and Times.

I was doing a little more advanced Date/Time VBA programming and decided that now was as good a time as ever to start creating such a page.  So here it is.

This article will evolve with time, so come back from time to time.

Continue reading

Sharing a Microsoft Access Database Online With Multiple Users

Today, I thought I’d briefly touch upon a more and more common question, which is:

How can we share a Microsoft Access database online between multiple users?

In today’s world, sharing data is simply a necessity!  So it is only natural to have the need to share Microsoft Access data with people outside of your network, over the Internet…

I previously posted about this issue in my article:

Today, I wanted to continue the discussion a little more.

So How Can We Do It Exactly?

Continue reading

Modern Web Browser Control Initially Displaying Blank Page

Software Bug

Yep, another bug with the Modern Web Browser control.

Worse, this issue occurs when simply trying to navigate to a URL via VBA using the form’s current event. At the opening of a form, navigation is simply completely unreliable and more often than not renders a blank page! Sometimes it works, but most of the time it does not! When navigating the records, the event works just fine, this bug is limited to the initial opening/loading of the form/report control. So in most instances, the user ends up with a blank Modern Web Browser control when they should be seeing content.

Continue reading

Microsoft Access Database Schemas

Database Schema - Relationship diagram

What is he talking about? Microsoft Access doesn’t having schema, does it?!

No, and that’s the point!

I recently came across the following discussion on UtterAccess

in which MadPiet’s comment regarding Microsoft Access lacking schemas got me thinking a little.

For larger projects, schemas can be very beneficial for organizing and grouping database objects (amongst other things).  So instead of having one listing of all the objects mixed together, they are (or at least, can be) sub-divided and grouped by ‘subject’.  So in a corporate database, perhaps we would have groupings like:

  • HR
  • Sales
  • Management
  • IT

So what can be done in Access then to facilitate things?  How can we make working in larger projects a little more bearable when we’re dealing with 100s or even 1000s of objects?
Continue reading

Microsoft Access Compact and Repair

What is Compact and Repair (C&R)?
What does it do exactly?
Why do most experience developers recommend it so much?

Well, these are some of the questions that I am going to try to answer in this article. So let’s take a closer look at Microsoft Access’ Compact and Repair command.

Continue reading

Microsoft Access Database Bloating Main Causes

I recently released a YouTube video regarding the Compact and Repair command.

My objective with that video was to only summarily touch upon the command, how to run it and explain the 2 main benefits. I was aiming for a video for new users, and introduction to the subject.

I received a negative comment stating that I didn’t explain the causes of bloating …, I didn’t delve into the details of the issue enough.  Thus, I thought that today I’d start trying to cover some of the more known root causes of database boating and will most probably create a follow-up in the future to discuss this further.

Continue reading