Activity of Mar. 11, 2011

Post date: Mar 11, 2011 8:41:18 PM

Something that nearly every company needs, including your publishing company, is a zip code database. Your contacts table, for instance, includes a zip code field, and you need it for mailing and shipping and even things like mapping your customers to see where they come from. Today you will add a zip code table to the Tasks database. You will write queries "against" it to see what's there, but also to create, update, and delete records. You'll also look at the SQL statements that are generated by the query design view. The R (for read or retrieve) queries will serve as the basis for reports.