Once a table displays in Datasheet View, you can simply start entering data into its cells but because the columns would have insignificant names, you should make sure they display names that can identify their type of information.
A field can have almost any name: "Book Title", "This Is The Book Title", "My Book Titles", etc. Some of your fields will have only tinny data, like a person's age, the number of books in an office, a person’s middle initial, etc, it might not be a good idea to give them a name that would take too much space. In the future, when you start programming, it would be easier to handle field names that are composed of only one word, without
an empty space.
To name a field, first figure out what the data in the category will be made of. If you are planning to enter employees' salaries in a field, you can just call the field Salary. If you want to specify employees’ names by first name, middle name, and last name, you can use such field names and make them distinct. In this case, you could name the first field as firstname (in one word), the last name would be called
lastname. Although this good technique allows you to use one word name, some people including yourself might be confused. The suggestion is to distinguish wherever a new English
(or the language you are using to design your database) name starts in the field name, by using a starting uppercase. Instead of
firstname, you can use FirstName. Instead of fullname, you can use FullName. Instead of
firstdayofmonth, you can use FirstDayOfMonth.
To change the name of a field, you can click its column header, such as Field1. You can also right-click a column and click
Rename Column. Alternatively, when any cell under a column has focus, on the main menu, you can click Format -> Rename Column and type the new desired
Practical Learning: Naming Datasheet Fields
- Double-click the header of the first field: Field1. When it is highlighted, type
OrderDate and press Enter
- Click anywhere under the Field2 column to activate it
- On the menu bar, click Format -> Rename Column. That puts the field name in edit mode
- Type OrderTime
- Right-click Field3 and click Rename Column from the context menu
- Type Container and press Tab