Microsoft Office Tutorials and References
In Depth Information
Editing a Table
Getting Started with
Your First Database
Tip: Don’t be too timid about tweaking your table. You can always rename fields later, or even add
entirely new fields. (It’s also possible to delete existing fields, but that has the drawback of also clearing
out all the data that’s stored in that field.)
6. ChooseFile ➝ Save(orpressCtrl+S)tosaveyourtable.
Access asks you to supply a table name (see Figure 25-8).
Congratulations! The table is now a part of your database.
A good table name is a short text title that doesn’t have any spaces
(like Dolls here).
Note: Technically, you don’t need to save your table right away. Access prompts you to save it when you
close the datasheet (by clicking the X at the document window’s top-right corner), or when you close
As you can see, creating a simple table in Access is almost as easy as laying out
information in Excel or Word. If you’re itching to try again, you can create another table
in your database by choosing Create ➝ Tables ➝ Table from the ribbon. But before
you get to that stage, it makes sense to take a closer look at how you edit your table.
Editing a Table
You now have a fully functioning (albeit simple) database, complete with one table,
which in turn contains one record. Your next step is filling your table with useful
information. This often-tedious process is data entry.
To fill the Dolls table, you use the same datasheet you used to define the table. You
can perform three basic tasks:
• Editing a record. Move to the appropriate spot in the datasheet (using the
arrow keys or the mouse), and then type in a replacement value. You may also
want to use Edit mode, which is described in the next section.
• Inserting a new record. Move down to the bottom of the table to the row that
has an asterisk (*) on the left. This row doesn’t actually exist until you start
typing in some information. At that point, Access creates the row and moves the
asterisk down to the next row underneath. You can repeat this process endlessly
to add as many rows as you want (Access can handle millions).