• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Building Tables in an Access Project > Setting Table Design Options

Setting Table Design Options

Now that you understand the basic mechanics of defining tables and relationships in your Access project, let’s take a look at several options that allow you to customize how you design your tables. To view the database options, choose Options from the Tools menu.

You can find the first options that affect table design on the General tab, as shown in Figure 17-28. As I mentioned in Chapter 4, I highly recommend that you select All databases under Use four-digit year formatting. When you select this option, Access displays all year values in date/time formats with four digits instead of two. This is important because when you see a value in two-digit date format, such as 15 MAR 12, you won’t be able to easily tell whether this is March 15, 1912, or March 15, 2012. Although you can affect the display of some formats in your Windows Regional Settings in Control Panel, you won’t affect them all unless you set four-digit formatting in Access.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint