Data pro Thomas LaRock dives into the intricacies of SQL Server design, emphasizing the power of smart datatype decisions.

I'm currently working on a database that includes a table to keep track of customers. This table holds (among other things) the customer's address. To date, these addresses have all been located ...

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.