{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Access%20-%20CH%203%20and%20more - CIS 2640 Business...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style 11/05/07 Dr. K. Chen 11 CIS 2640: Business Reporting Book: Access 2007 Data Analysis Chapter 3
Background image of page 1

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

View Full Document Right Arrow Icon
11/05/07 Dr. K. Chen 22 Objectives l The OLE Object data type l Aggregate Queries l Action Queries
Background image of page 2
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
Background image of page 3

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

View Full Document Right Arrow Icon
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
Background image of page 4
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
Background image of page 5

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

View Full Document Right Arrow Icon
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
Background image of page 6
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
Background image of page 7

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

View Full Document Right Arrow Icon
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.
Background image of page 8
11/05/07 Dr. K. Chen Something is WRONG?? l Pictures are stored as “Package” in the Logo column. They can’t be used in MS Access Forms and Reports.
Background image of page 9

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

View Full Document Right Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}