Business Solutions Tricks of the Microsoft Office 2007 Gurus

14. Table and Query Tricks

IN THIS CHAPTER

Validating Data Entry

Using an Input Mask to Ensure Consistent Data Entry

Setting a Default Value for a Field

Requiring a Value for a Field

Ensuring That No Duplicate Values Display in a Field

Selecting a Field Value from a List

Entering a Field at the End for Easier Editing378

Inserting Hyperlinks into a Table

Importing Data from an Outlook Folder

Collecting Access Data via E-mail

Finding Duplicate Records with a Query

Selecting the Top Values with a Query

Adding a Custom Calculated Column to a Query

Calculating Inventory Value

Calculating Order Totals

Prompting for Query Criteria

Microsoft Access is the data powerhouse of the Office suite. It’s a full-fledged relational database management system, ...