Creating Your First Simple Table by Entering Data

If you’ve been following along to this point, you should still have your new Kathy’s Wedding List database open with Table1 open in Datasheet view, as shown in Figure 4-8. (You can also follow these steps in any open database.) What you see is an empty datasheet, which looks quite similar to a spreadsheet. Access 2007 automatically created the first field, called ID, in the left column. Leave this field intact for now. In the second column Access has placed another field with the Add New Field heading. You can enter just about any type of data you want in this field—text, dates, numbers, or currency. But unlike a spreadsheet, you can’t enter any calculated expressions in a datasheet. As you’ll ...

Get Microsoft Office® Access 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.