LSP 121 Lecture Notes - Lecture 1: Social Security Number, Hyperlink, Government Database
Document Summary
You many need to separate files or there"s too much data in a single file. You need to look at the data in many different ways. Number: use when you plan to do arithmetic. Date/time: whenever the data is a date. Autonumber: when access automatically inserts the numbers for you. Hyperlink: whenever the data is a link. Yes/no: primary key: a field that can uniquely identify every record. If you are searching for a particular record, you can use the primary key. A social security number is the primary key for most government databases: an index lets you search for one or more records. Allows for more secure access to only parts of the data.