Access%20-%20CH%203%20and%20more

Access%20-%20CH%203%20and%20more - Click to edit Master...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click to edit Master subtitle style 11/05/07 Dr. K. Chen 11 CIS 2640: Business Reporting Book: Access 2007 Data Analysis Chapter 3 11/05/07 Dr. K. Chen 22 Objectives l The OLE Object data type l Aggregate Queries l Action Queries 11/05/07 Dr. K. Chen OLE Object Type (1) l Each field should have a data type defined for it. All data values stored under the field have to be in that data type. l OLE Object is a special data type used to store binary data. Why OLE Object type? l What kind of data is binary data? Pictures, Audio clips, MS Office files, and many others 33 11/05/07 Dr. K. Chen OLE Object Type (2) l To store binary data (e.g., a picture file) in a field, you need to first create the field as the OLE Object type in Design View . 44 11/05/07 Dr. K. Chen OLE Object Type (3) l To insert binary data in Data Sheet view, right-click the OLE Object field and select Insert Object. 55 11/05/07 Dr. K. Chen OLE Object Type (4) l All the following types of files can be stored in an OLE Object field. 66 11/05/07 Dr. K. Chen OLE Object Type (5) l The easiest way to avoid problems when inserting binary data is to follow the two step procedure below: l Step 1 : Create the binary data file (e.g., PDF, Word, Excel) outside of MS Access l Step 2 : Insert it by selecting the file. 77 11/05/07 Dr. K. Chen OLE Object Type (6) l The table below stores an image file in the first record of the Logo field, an MS Word document in the second record, and an Adobe PDF file in the third. l Double-clicking the field value brings back the content. 88 Watch out for Package. See discussion in class. 11/05/07 Dr. K. Chen Something is WRONG??...
View Full Document

Page1 / 36

Access%20-%20CH%203%20and%20more - Click to edit Master...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online