Working with Access

Tips, Tricks, and Answers

The following articles are available for the 'Working with Access' topic. Click the article's title (shown in bold) to see the associated article.

Conditional Formatting with Data Imported from Access
If the information you import from Access into Excel isn't interpreted just right, it can have consequences on your conditional formatting. This tip explains those consequences and how you can correct for any potential problems.

Preparing Data for Import into Access
When importing Excel information into Access, you need to be concerned with the condition of the data. Here's how to make sure that two common offenders—Social Security Numbers and ZIP Codes—are imported properly.