May 04 2012

Microsoft office 2007 Access data processing changes

Published by at 3:03 am under Uncategorized

Microsoft Office Professional 2007:

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.

Tags

microsoft office 2007 Microsoft office 2010 Microsoft office 2010 doanload Microsoft office 2010 download Microsoft office 2010 dpwnload Microsoft office 2010 Key office 2007 Office 2007 download office 2007 skill office 2010 office 2010 download Office 2010 key office 2010 skill office 2010 technology outlook 2010

No responses yet

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.

Search