Is Microsoft Access right for you? Here are several reasons why I often recommend Access to my clients.

Not sure if you need one table or two in Microsoft Access? Here's a guide.

When to use a subforms in a Microsoft Access database

Porting Microsoft Access tables to SQL Server

Use properties of Excel connections to gain access to real-time data points in your database.

Dealing with the "database is in an inconsistent state" error message, and other symptoms of Microsoft Access corruption.

Using VLOOKUP data from Access and SQL Server databases

In recent blogs, I've been discussing the various ways you can connect data between Microsoft products. So far, I've covered Access,...

Add a link to SQL server data to your Excel worksheet.

Linking to data in SQL Server from a Microsoft Access database

Creating links to Microsoft Access data in your Excel worksheet.

Create a Microsoft Access table that is linked to an Excel file.

Use Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.

I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that...

Today we’ll be looking at preventing duplicate values from being entered into your Excel sheet. This is the final entry in a series that...

Use MS Access to find duplicates in your Excel data

Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.

Use MS Access to clean numeric fields that contain text.

Use MS Access to clean phone numbers in your Excel data.

Adding a Visual Basic structure to your Excel file for validating data.