Microsoft Office Tutorials and References
In Depth Information
Tables, views, and data types
Now, while still in Datasheet view, let’s examine the actual datasheet.
Notice the following:
• The i rst column has a i eld name, ID, which is the primary key. A primary key is the
unique record identii er for a table.
• The second column is ready to receive your input.
The light green color indicates the cell
that is available for input.
While there are multiple ways to add i elds to a datasheet, you’ll assign the data type and then
enter the name of the i eld. A data type determines what you can store and just as importantly,
what you cannot store in a i eld. For example, you cannot enter letters, characters such as A,
B, C, into a Funds i eld with a Currency data type, or into a Birthday i eld with a Date/Time
Data types can have some unexpected properties. For example, the Text i eld can contain
numbers, and numbers may have a data type such as Text, Number, and Currency.
For Table1, you will add i elds for Last Name, First Name, and Date of Birth.
To add i elds to a table in Datasheet view:
Click the Click to Add down arrow and select Text from the Data Type drop-down menu.
In the new column, replace Field1 by typing LastName .
Field names cannot have spaces or symbols, but they can have underscores.
Repeat steps 1 and 2 to add a FirstName i eld.
Now to add Date of Birth, be sure to click Date & Time from the Data Type drop-down
menu. Rename Field1 by typing DOB .