2007 Microsoft® Office System Inside Out

Setting Table Design Options

Now that you understand the basic mechanics of defining tables in your desktop database, it’s useful to take a look at a few options you can set to customize how you work with tables in Design view. Close any open tables so that all you see is the Navigation Pane. Click the Microsoft Office Button and then click Access Options to see all the custom settings offered.

You can find the first options that affect table design in the Advanced category as shown in Figure 27-32. One option that we highly recommend you use is Use Four-Digit Year Formatting, found in the General section. When you enable four-digit year formatting, Access 2007 displays all year values in date/time formats with four digits instead of two. This ...