Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [Z] data types considerations when changing copying filtering support lookups support overview Required field property support text-based 2nd data validation applying rules 2nd creating table rules 2nd Design view input masks 2nd 3rd 4th 5th 6th lookups 2nd 3rd preventing blank fields 2nd 3rd preventing duplicate values 2nd 3rd 4th setting default values 2nd 3rd writing rules 2nd database design 2nd 3rd 4th 5th 6th database diagram defined database objects defined managing reports as types of databases Attachment data type compacting consistency and copying creating 2nd 3rd 4th creating in previous versions front end to importing consideration linking opening 2nd opening previous versions 2nd planning saving saving as previous version saving with different names /formats shrinking tables and templates for transferring records to using someone else's Datasheet option (layouts) Datasheet view copying rows in hyperlink support primary key and running queries switching views 2nd tables and datasheets customizing filtering records 2nd 3rd 4th find-and-replace feature formatting 2nd forms and forms vs. moving around printing 2nd query results as searching records 2nd 3rd 4th sorting records 2nd 3rd 4th Date data type filtering support date expressions queries and validation rules and 2nd Date( ) function 2nd 3rd Date/Time data type description date/time information arranging for reports 2nd copying dBase decimal numbers 2nd Decimal option (Field Size property) Decimal Places field property Default Value property default values dynamic deleting attachments cascading deletes 2nd fields fields from reports records 2nd 3rd records from forms 2nd relationships Design view accessing data types creating queries 2nd 3rd data validation field validation rules for forms lookup lists ready-made masks setting primary key in switching to 2nd updates in Disabled Mode disaster recovery Double option (Field Size property) double-clicking collapsing ribbon Edit mode toggle expanding columns launching queries opening tables Down Arrow key duplicate records preventing dynamic default values |