Microsoft (MS) Access and SQL are different database applications with pros and cons. But, instead of choosing between them, you can, as it turns out, make them work together.

Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats. ... for example, "MS SQL Database." ...

One more example. Access allows you to add a validation rule to a column such that, for example, the only acceptable values in a field called "Title" might be Mr., Mrs., Miss., Ms, etc. SQL Server ...

This folder contains selected samples and scripts for chapter 2. 2.001 -- Not included: listing is DB2 specific. 2.002 -- Not included: listing is DB2 specific. 2.003 -- Contained as query Listing ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.