The UNION query: a way to stack multiple SELECT queries into a single resulting data set.

The UPDATE query: a dangerously powerful tool for making bulk changes to data in your Access tables.

Discover the power of INSERT INTO queries in Microsoft Access, a vital tool that allows you to add a single record or transfer data from one table to another.

The SELECT query is the source of a relational database system's true power.

Referential integrity is the key to ensuring data quality in a relational database. Learn what it is and how to enforce it among your back-end tables.

In Access, tables can be local (stored in the front-end file) or linked (stored in a separate database). Let's explore when and why to use each type.

"Front-end" and "back-end" are the terms we use to distinguish between the user interface and the data storage, respectively.

Queries are how we get useful information from data stored in tables. They also let us make bulk changes to our data. ... Be careful with queries!

If you know Excel worksheets, Access tables will look very familiar. Be careful, though! There is a "key" difference between the two.

A short primer on the difference between bound and unbound forms in Microsoft Access, along with example use cases for each.