Datasheet

folders, click once to select the one in which you want to store your
database.
c. As needed, click the New Folder button (a folder with an asterisk on
it) and name your new folder — click OK to return to the File New
Database dialog box.
d. Click OK — the name you gave the file in Step 2 is applied, and the
file is saved to the location you chose.
4. Click the Create button.
A blank table opens with the first cell in the grid (the first field in the
first record) selected.
At this point, you can begin entering records into your first table or begin
naming your fields and setting them up. The field names go in the topmost
row (the “ID” field is already created), and “Add New Field” is atop the
column with the active cell. If you choose to save your table now (right-click
the Table1 tab and choose Save), you can name your table something more
useful than “Table1.”
Starting with a template
Access provides templates, or database cookie-cutters, for your new data-
base needs. You’ll find a list of template categories on the left side of the
Access window when you first open the application. As shown in Figure 1-13,
you can choose a template category on the left (which changes the displayed
icons in the center of the workspace), or pick a particular template from the
icons representing the templates available at Microsoft Office Online.
Everything from Assets and Inventory to Marketing to Accounting and
Finance is represented, so chances are, you’ll find just what you need.
Figure 1-12:
Name and
choose a
location to
store your
database
file.
24
Part I: Basic Training
05_046120 ch01.qxp 11/15/06 1:57 PM Page 24