Microsoft Access 2010 Bible

Chapter 2: Creating Access Tables 53 Design your tables very conservatively, and allow for larger values than you ever expect to ...

Part I: Access Building Blocks 54 OLE Object The OLE Object field stores OLE data, highly specialized binary objects such as Mic ...

Chapter 2: Creating Access Tables 55 field description can help clarify a field whose purpose is ambiguous or give the user a mo ...

Part I: Access Building Blocks 56 Changing a Table Design Even the best planned table will require changes from time to time. Yo ...

Chapter 2: Creating Access Tables 57 Cross-Reference Table relationships and the Relationships window are discussed in Chapter 3 ...

Part I: Access Building Blocks 58 l (^) Text to Number, Currency, Date/Time, or Yes/No: In most cases, the conversion will be ma ...

Chapter 2: Creating Access Tables 59 Each field data type has its own set of properties. For example, Number fields have a Decim ...

Part I: Access Building Blocks 60 l (^) Validation Rule: Ensures that data entered into the field conforms to some business rule ...

Chapter 2: Creating Access Tables 61 l (^) [color]: Displays the output in the color (black, blue, green, cyan, red, magenta, ye ...

Part I: Access Building Blocks 62 All the previous formats are the default formats based on setting the Decimal Places property ...

Chapter 2: Creating Access Tables 63 l (^) General Date: If the value contains a date only, don’t display a time value and vice ...

Part I: Access Building Blocks 64 l (^) h: Displays the hour using one or two digits (0–23) l hh: Displays the hour using two di ...

Chapter 2: Creating Access Tables 65 Several examples of custom text formats using the “English (United States)” regional settin ...

Part I: Access Building Blocks 66 Yes). To customize the appearance of the Yes/No field, set its Format property according to th ...

Chapter 2: Creating Access Tables 67 l (^) Third section: Defines the “placeholder” character that tells the user how many chara ...

Part I: Access Building Blocks 68 FIGURE 2.19 The Input Mask Wizard for creating input masks for Text and Date field types The I ...

Chapter 2: Creating Access Tables 69 Captions can be as long as 2,048 characters, more than adequate for all but the most verbos ...

Part I: Access Building Blocks 70 entered for values such as inventory quantities, and that entries are restricted to different ...

Chapter 2: Creating Access Tables 71 You can also use Visual Basic for Applications (VBA) code to set a field’s AllowZeroLength ...

Part I: Access Building Blocks 72 Indexed The Indexed property tells Access that you want to use a field as an index in the tabl ...