Free E-Books

Select the table name in the Database window.
2. Click once on the table name, and press F2.
3. Type the new name of the table and press Enter.
TIP TIP
82
Access Building Blocks Part I
You can also rename the table by right-clicking on its name in the Navigation pane, and selecting
Rename from the shortcut menu. After you change the table name, it appears in the Tables list,
which re-sorts the tables in alphabetical order.
If you rename a table, you must change the table name in any objects where it was previously
referenced, including queries, forms, and reports.
Deleting tables
Delete a table by selecting the table in the Navigation pane and pressing the Delete key. Another
method is by right-clicking a table and selecting Delete from the shortcut menu. Like most delete
operations, you have to confirm the delete by selecting Yes in a confirmation dialog box.
Copying tables in a database
The copy and paste options in the Clipboard group on the Home tab allow you to copy any table
in the database.


Pages:
305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329