Figure 2-30 shows adding records in datasheet mode to the table.
You can enter information into all fields except the Contact ID field (ContactID). AutoNumber
fields automatically provide a number for you.
FIGURE 2-30
Adding records to a table using Datasheet view
Although you can add records directly into the table through the Datasheet view, it is not the most
efficient way. Adding records using forms is better.
Understanding the Attachment Data Type
Microsoft recognizes that database developers must deal with many different types of data. Although
the traditional Access data types (Text, Currency, OLE Object, and so on) are able to handle many
different types of data, until Access 2007 there was no way to accommodate complete files as Access
data without performing some transformation on the file (such as conversion to OLE data).
Access 2007 adds the Attachment data type, enabling you to bring entire files into your Access
database as ???attachments??? to a field in a table. When you click on an attachment field, Access
opens a small dialog box (shown in Figure 2-31) enabling you to locate files to attach to the table.
Pages:
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333