May 04 2012
Microsoft Office Professional 2007:
Microsoft office professional is a complete suite of productivity and database software that includes the 2007 versions of Publisher, Excel, Outlook, Outlook with Business Contact Manager, PowerPoint, Access, and Word. Powerful contact management features help you consolidate all customer and prospect information inthe one place, while improved menus present the right tools exactly when you need them. the Microsoft Office Professional 2007 price: $ 70.00
When you migrate applications to Microsoft office 2007 Access, you will find some new features related to data processing, these new features, most in need of new ACCDB database format. Although there are many new data-related functions, the paper focuses on two specific features, you should consider migrating your application: First, it is in ACCDB format, including how to save images in Microsoft office 2007 Access. The second feature at the MDB or ACCDB format, processing refers to the embedded database stored in the file system itself, rather than images.
Save the image in its native format
In earlier versions of Access, you add any image stored in the Image control to the form or report in a database, as a bitmap (BMP). BMP image files are not compressed, such as JPEG, GIF and other image file format images. Therefore, the database may become greater than they need. In addition, the functionality provided in other formats, such as transparency, the conversion is lost.
Access to 2007 stored images (ie, for the specified image screen, without any conversion, control of the property in its native format image).
Save the native image format properties
MDB database default, continue to BMP format images are stored in maintaining cross-version compatibility. If you know only Microsoft office 2007 Access client application to access your database, and to take advantage of the new image storage format, you can change the storage format of the image properties in accordance with the following steps:
Click the Microsoft Office Button, and then select Access Options. “
Select the current database, and then select the “Keep Source image format.
Use the attachment field type
Northwind Traders application always contains photos of each employee. Access 2000 version of the picture stored in the same database folder, rather than embedding an OLE Object field in the Employees table. VBA code to run in the employee table of the current user through the mobile form of the events of each picture.
In Microsoft office 2007 Access, this code by using a new field type, attachment type to be eliminated. The attachment enables you to one or more files to the current record.
Take advantage of the attachment field type, you have to start ACCDB format into the database. You can select the Microsoft Office Button “menu conversion.
After the conversion of your database, you can follow these steps to add and use the attachments in the current field is used to store the name of a photo image of the text field:
In the Navigation Pane, right-click the Employees table, and then select the Design view.