Microsoft Office Tutorials and References
In Depth Information
Table after changing field values in a record
field values changed
You’ve completed all of Elsa’s updates to the Position table. Now you can close the
6. Close the Position table, and then close the Northeast database.
Elsa and her staff members approve of the revised table structure for the Position table.
They are confident that the table will allow them to easily track position data for NSJI’s
Session 2.2 Quick Check
1. What does a pencil symbol in a datasheet’s row selector represent? A star symbol?
2. What is the effect of deleting a field from a table structure?
3. How do you insert a field between existing fields in a table structure?
4. A field with the
data type can appear in the table datasheet as a
5. Describe the two ways in which you can display the Import dialog box, so that you
can import a table from one Access database to another.
6. In Datasheet view, what is the difference between navigation mode and editing mode?
To reinforce the tasks you
learned in this session, go
to the SAM 2003 Training
Companion CD included
with this text.
In this tutorial, you learned how to create and save a new database and how to create and
save a new table in that database. With this process, you also learned some important
guidelines for designing databases and tables, and for setting field properties. You worked
in Design view to define fields, set properties, specify a table’s primary key, and modify a
table’s structure. Then you worked in Datasheet view to add records to the new table,
both by entering them directly in the datasheet and by copying records from another
Access database. To complete the database design, you imported tables from another
Access database into the new database you created. Finally, you updated the database by
deleting records and changing values in records.