Understanding Jet Database FilesJet Workgroup Information FilesJet Record-Locking Information FilesJet Add-In (Library) DatabasesCreating a New Jet DatabaseExploring the Properties of Tables and FieldsTable Properties for SubdatasheetsField PropertiesChoosing Field Data Types, Sizes, and FormatsChoosing Field Sizes for Numeric and Text DataSubtypes for Numeric DataFixed-Width Text FieldsSelecting a Display FormatStandard Formats for Number, Date/Time, and Yes/No Data TypesThe Null Value in Jet TablesCustom Display FormatsUsing Input MasksWorking with the Northwind Traders Sample DatabaseUsing the Table Wizard to Add a New TablePreparing to Add a Table Related to the Employees TableDesigning the HRActions TableDetermining What Information the Table Should IncludeAssigning Information to FieldsCreating the HRActions TableCreating a Table Directly in Datasheet ViewSetting Default Values of FieldsWorking with Relations, Key Fields, and IndexesEstablishing Relationships Between TablesCascading Updates and DeletionsSelecting a Primary KeyAdding Indexes to TablesAltering Fields and RelationshipsRearranging the Sequence of Fields in a TableChanging Field Data Types and SizesNumeric FieldsText FieldsConversion Between Number, Date, and Text Field Data TypesChanging Relationships Between TablesWorking with Object Dependencies and Access Smart TagsEnabling and Viewing Object DependenciesActivating the Access Property Options Smart TagAdding an Internet-Based Smart Tag to a FieldCopying and Pasting TablesUsing the Table Analyzer WizardGenerating a Data Dictionary with the Database DocumenterTroubleshootingGaps In AutoNumber Field ValuesExtra Indexes Added By AccessIn the Real World—Database Strategy and Table Tactics