Creating New Types of Fields

General database functions, such as storing data in tables, finding specific data by using queries, and displaying data in forms and reports, are fairly well defined and have been for some time. The types of data traditionally stored in database tables are text values, numbers, dates, and so on. As time has passed and computers have become faster and more powerful, users’ needs have changed. Product databases, for example, benefit from having pictures of the products stored in the database. Yes, in previous versions of Access you could link to a file by using a hyperlink or OLE data type, but Access 2007 cuts to the chase and lets you include the image in your database directly.

If you like, you can attach multiple ...

Get Microsoft® Office Access™ 2007 Plain & Simple 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.