Microsoft Office Tutorials and References
In Depth Information
Working with Tables and Fields in Your Database
Close Design view, and click the Yes button when Access asks whether
you want to save the table.
Click the File button in the top-left corner of Access, and choose Save
from the drop-down menu.
When the Save As dialog box appears, provide a name that describes the data
stored in the datasheet. When you need the data in this table to create other
database objects, you’ll be grateful that you named the table descriptively.
Working with Tables and Fields in Your Database
Now that you’ve created a simple table, entered data, changed field names,
and saved the table so that your data is well-labeled and easy to find later,
you’re ready to tackle some of the nitty-gritty details of using Access 2013’s
Table Datasheet view. We start with other ways to create a table and ways to
add preformatted fields to your newly created tables.
Finding other ways to create a table
If you’re adding a table to an existing database, the second group of
buttons on the Create tab of the Ribbon — the Tables group (see Figure 1-4) —
allows you to create new tables.
Figure 1-4:
Click a
button in
the Tables
group to
create a
new table.
The three buttons in this group are
Table: Creates a new, blank table displayed in Datasheet view, allowing
you to enter data immediately. Clicking this button is the simplest way
to create a new, blank table and display it in Datasheet view.
Table Design: Creates a new, blank table displayed in Design view,
allowing you to define fields. See Chapter 2 of this minibook for more
information on using Table Design view to refine your table and field
definitions.
Search JabSto ::




Custom Search