How to do a mail merge using Microsoft Word and Excel to quickly create personalized templates for imported data

You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once.

What is Microsoft Access? Here's how the database management system works, and how it differs from Excel

Microsoft Access is a database management system (DBMS) that businesses can use to store and manage large amounts of data.
Houston Chronicle

How to Import an Excel Spreadsheet Into Access With a Macro

If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true. Macros are small programs that execute commands you specify. Write ...
Hosted on MSN

8 ways to use Microsoft Excel as a lightweight database

While Microsoft Excel is widely recognized for its spreadsheet functionality and calculation capabilities, it’s often overlooked as a powerful tool for managing small to medium-sized datasets. When ...
Ars Technica

How do I secure an Access database for web use?

I'm using an Access 2000 database with a Cold Fusion 5 front end and I want to make sure the data inside the database is reasonably secure. No credit card info or sensitive personal info is contained ...
TechRepublic

How to use passwords to grant users access to different Microsoft Excel workbook ranges

How to use passwords to grant users access to different Microsoft Excel workbook ranges Your email has been sent You can password protect a Microsoft Excel file, and ...
TechRepublic

How to use Microsoft Excel’s VSTACK() function to combine multiple data sets

How to use Microsoft Excel’s VSTACK() function to combine multiple data sets Your email has been sent Have you ever received data that you had to consolidate manually? It’s tedious work and prone to ...