Microsoft Support Number OR Call Toll-Free @ 1-844-478-2887

Thursday, June 3, 2010

Microsoft Access 2010 Features





Microsoft takes Office 2010 to a after that level with heavy accent on web services. Microsoft Access 2010 sets latest standards with exciting server-specific features and capabilities, with a few additional still to arrive. Access 2010 adds the ease of Access application development for making of Web forms and information. With the latest features IT managers will have the simplicity of SharePoint 2010 product organization that will assist them in managing Access data, application objects and application activities. Clearly, Access 2010 features are quite useful for small databases such as address books and CD/DVD collections. We various a list of 10 best new features in Microsoft Access 2010 that would lift an end-users occurrence.

1. Web-ready database arrangement

In some environments the web is a latest desktop. Access developers team takes this into thought to offer a web-ready format for databases. In previous versions of Access you could distribute to web via scripting technologies to access the data. Access 2010 makes web applications still more faster using the Web Database type.
Access 2010 provides SharePoint Business Connectivity Services (BCS) Support. It includes web services and line-of-business applications data. You can make right into the applications with Microsoft Access 2010. It helps keep your system safe by allowing you to view data that is trusted and validated by the IT employees.

2. AutoFormat changed by Office themes

In Microsoft Access 2010 autoformat has been unconcerned from the Fluent user interface and it has been replaced by Office Themes. The earlier versions of Access depended leading formats to paint various forms and reports with the same color and styles. However, these formats are unique to Access. Microsoft Access 2010 replaces it with desktop themes that can be approved over to other Office applications such as Word and PowerPoint.

3. Global replace to MRU file list

One of the mainly substantial features of Office 2010 is the improvement to the MRU file list. This might seem a little modify but you can now right click entries in the list and choose to remove them or pin it to the list so that it is never popped off.
The default page is called Backstage View and replaces the File menu. It provides the links to view the Application Log, check for web compatibility, publish, compact, analyze or encrypt your database. Further, the relationship window has been removed from the ribbon where it resided in Access 2007.

4. Table Macros

The mainly stimulating new feature for the developers is the addition of macros to the Access table. The coolest thing concerning this development environment is that you can right-click the page and copy part or all of the macro and paste it into a new section. Paste the text of the macro into Notepad to share it with others, such as the newsgroup post where you ask for assistance with the code.

Here's a list of new features with triggers

• Create, delete, or edit a record
• Set a field or variable value
• Raise an error
• Log an event
• Send an Email

5. Macros (General)


In Access 2010 you have a Table Macros. Like the macros in earlier versions you can assign a lot of events. Macros may be represented with XML that lends them more reliability with programmers.

6. Add Field

The task pane is removed in Microsoft Access 2010 and replaced with Data Type gallery. In Access 2007 you could add a compliment of fields that have been defined in other tables such as email or DOB and retain their previously described properties. The new feature in Access 2010 allows you to add a tribute of fields all at once. For occasion, you can include the Street, City, State, Zip and Country. Simply click the address field to add all the above mentioned list of fields. It's a great new feature.

7. Pre-Built Application Templates

Get happening with a pre-built application that will allow a starting point before customizing to your wants. It helps you to make sure your base application has been built properly and optimized to be reused across your group.
Post a Comment