Microsoft Office Tutorials and References
In Depth Information
Creating the First Table for Your Data
If you’re thinking about using your database in a SQL environment, don’t use
spaces in your field names. SQL doesn’t like spaces! You can use capital
letters and underscores to make your field names readable instead, as in
LastName and Last_Name.
Changing a field name
In the database-building process, changing field names is easier if you do it
sooner rather than later — that is, before you use the names a zillion times
in tables, queries, forms, reports, and code.
You can rename a field in a single table, but if you use the field in other places
in the database, be sure that the Name AutoCorrect feature is on. To see the
Name AutoCorrect options, click the File button near the top-left corner of the
Access window; then click the Options button at the bottom of the drop-down
menu. Click Current Database in the Navigation Pane of the Access Options
dialog box, and scroll down to the Name AutoCorrect Options section, which
contains three Name AutoCorrect box check boxes. Make sure that the second
check box, titled Perform name AutoCorrect, is selected.
To change a field name in Datasheet view, follow these steps:
1. Double-click the current name.
Access displays the name in white letters, highlighted with black.
Whatever you type replaces the highlighted name.
2. Type the new name, and press Enter.
The field name has been changed. Check it carefully to make sure that
it’s exactly what you intended.
Alternatively, you can right-click the field name, choose Rename Field from
the contextual menu, type a new name, and press Enter.
Saving your table
As soon as you enter data, Access saves it. So why do you need to save your
tables? It’s not to save the data; it’s to save both the structure of the table
and its field definitions. What you save when you save a table is the table
definition, which includes how the table looks in Datasheet view (such as the
size and order of the columns) and the information in Design view (the field
names, data types, descriptions, and field properties).
Save a table design by using one of these methods:
✦ Click the Save button (which looks like a floppy disk and is on the toolbar
above the Ribbon).
✦ Press Ctrl+S.